Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re: SQL Quoting

by Purdy (Hermit)
on Jan 29, 2002 at 02:44 UTC ( #142217=note: print w/replies, xml ) Need Help??


in reply to SQL Quoting

Just wanted to add that if you just need to 'do' a command instead of preparing/executing it (useful if you are going to execute the same sql statement more than once), it also has support for placeholders (as the previous posters mention, placeholders rock!).

# Note the 'undef' in between the sql statement and the # bound variables. $rv = $dbh->do( "UPDATE table SET column=? WHERE column=?", undef, "New Value!!", $variable );

Jason

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (5)
As of 2019-11-23 02:48 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Strict and warnings: which comes first?



    Results (113 votes). Check out past polls.

    Notices?