Don't ask to ask, just ask | |
PerlMonks |
Re: SQL Update Errorby rdfield (Priest) |
on Feb 18, 2004 at 11:54 UTC ( [id://329885]=note: print w/replies, xml ) | Need Help?? |
There is no from clause in an update statement (except in sub-queries). In answer to your direct question "where am I going wrong?", I suspect that one of the variables that you are interpolating into your statement contains a comma. Have you tried printing the SQL statement that you create? Have you tried executing that statement directly against the database using a command line utility supplied with your RDBMS software? rdfield
In Section
Seekers of Perl Wisdom
|
|