Hi everyone...
I'm trying to update a few columns on one row using an sql statement, but I
don't seem to have the correct syntax...
I'm using :-
$dbh->do("update <tablename> set <column1> = <new-value1> <column2> =
<new-value2> where <column3> = <value3>");
This doesn't work... however if update only one column it does, so I figure
I must be missing something. I've looked through the docs and can only find
update examples with one column to be updated.
Please help!!!!!!
Simon