Re: Mysql syntax error

in reply to Mysql syntax error from DBI

Since "drain cleaner" is two words, it should be quoted. An easy way to solve this and similar problems is to use placeholders. Something like:

my $sth =$dbh ->prepare("UPDATE products set pname=? and  unit=? and q
+ty=? and cost=? WHERE id = ?");
$sth->execute($pname, $unit, $qty, $cost, $id);
[download]

should do the trick. The question marks are replaced by the values passed to execute. For more information, see DBI.

Are you sure it was a book? Are you sure it wasn't.....nothing?

Comment on Re: Mysql syntax error Download Code

Replies are listed 'Best First'.
Re: Re: Mysql syntax error by dbwiz (Curate) on Nov 10, 2003 at 19:00 UTC
`my $sth =$dbh ->prepare("UPDATE products set pname=? and unit=? and qty=? and cost=? WHERE id = ?");` [download] should do the trick. No. It shouldn't. The SQL syntax is wrong (see meetraz's answer.	[reply] [d/l]

In Section Seekers of Perl Wisdom