Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re^2: RFC:Tutorial: Using jQuery, Json, and Perl for Web development

by bradcathey (Prior)
on May 29, 2010 at 14:06 UTC ( #842174=note: print w/ replies, xml ) Need Help??


in reply to Re: RFC:Tutorial: Using jQuery, Json, and Perl for Web development
in thread RFC:Tutorial: Using jQuery, Json, and Perl for Web development

Point taken, but not sure how to satisfy. I just spent the last hour or so trying to find out exactly what needs to happen.

I learned this technique from chromatic's venerable piece DBI is OK several years ago. Just came across Updating my database, where keys are escaped, but not quote as elegantly as I had hoped. Also looked again at $dbh->quote() but not seeing how that works with keys.

Can you point me in the right direction on this one? I'd appreciate it because I use this approach a lot. Thanks.

—Brad
"The important work of moving the world forward does not wait to be done by perfect men." George Eliot


Comment on Re^2: RFC:Tutorial: Using jQuery, Json, and Perl for Web development
Download Code
Replies are listed 'Best First'.
Re^3: RFC:Tutorial: Using jQuery, Json, and Perl for Web development
by afoken (Prior) on May 29, 2010 at 14:31 UTC

    $dbh->quote_identifier() should be sufficient. $dbh->quote() is only for values, and only for those rare cases where placeholders cannot be used.

    Alexander

    --
    Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://842174]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (13)
As of 2015-07-31 13:41 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (277 votes), past polls