Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re: DBI and MySQL

by Kanji (Parson)
on Jul 12, 2002 at 06:06 UTC ( [id://181218]=note: print w/replies, xml ) Need Help??


in reply to DBI and MySQL

As you suspect, it is your (My)SQL syntax and not Perl/DBI at fault here, and can be fixed by removing the second WHERE in your statement because (in simple queries, anyway) you're only allowed one WHERE clause.

Something else you might want to do is investigate the use of placeholders (example below), which will automatically quote your variables so they don't break your SQL (ie, if you searched for O'Reilly, you'd have an extra apostophe in your statement!).

$sql = " SELECT * FROM dataflex WHERE attorney = ? AND issue = ? "; $sth = $dbh->prepare($sql) or die "preparing: ", $dbh->errstr; $sth->execute($INPUT{'attorney'},$INPUT{'issue'}) or die "executing: ", $dbh->errstr;

Note also the use of die instead of print, so that the script finishes after the first error instead of generating an endless stream of them, potentially confusing things...

    --k.


Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others lurking in the Monastery: (7)
As of 2024-04-19 15:09 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found