in reply to SQL Update Error
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
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Re: SQL Update Error
by pelagic (Priest) on Feb 18, 2004 at 12:51 UTC | |
Re: Re: SQL Update Error
by mpeppler (Vicar) on Feb 18, 2004 at 15:24 UTC | |
by pelagic (Priest) on Feb 18, 2004 at 15:28 UTC | |
by monktim (Friar) on Feb 18, 2004 at 17:02 UTC | |
by mpeppler (Vicar) on Feb 18, 2004 at 21:55 UTC | |
by pelagic (Priest) on Feb 19, 2004 at 09:31 UTC |
In Section
Seekers of Perl Wisdom