Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
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 (Monsignor) 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 contemplating the Monastery: (11)
As of 2016-08-30 13:17 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    The best thing I ever won in a lottery was:















    Results (418 votes). Check out past polls.