Beefy Boxes and Bandwidth Generously Provided by pair Networks httptech
Welcome to the Monastery
 
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
Re^3: RFC:Tutorial: Using jQuery, Json, and Perl for Web development
by afoken (Parson) 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 about the Monastery: (12)
As of 2014-04-17 17:25 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    April first is:







    Results (453 votes), past polls