Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: variables inside SQL statements

by indigo (Scribe)
on Oct 11, 2000 at 02:24 UTC ( #36141=note: print w/ replies, xml ) Need Help??


in reply to variables inside SQL statements

Note - Interpolating variables into SQL is bad. Instead, use 'bind' variables, like so:

my $sql = 'INSERT INTO table ( path ) VALUES (:1)'; # Compile sql my $sth = $dbh->prepare($sql) or die $dbh->errstr; # Bind path to :1 $sth->execute('/path/to/this') or die $dbh->errstr;


Comment on Re: variables inside SQL statements
Download Code
RE: Answer: variables inside SQL statements
by merlyn (Sage) on Oct 11, 2000 at 03:44 UTC
      You mean there are databases other than mySQL and Oracle? I don't understand. :)

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (6)
As of 2015-07-06 03:39 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 (70 votes), past polls