11 Jun
2002
11 Jun
'02
1:39 p.m.
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