Re^2: sql queries updation improper

[Tobin Cataldo]

in reply to Re: sql queries updation improper
in thread sql queries updation improper

The OP said that cid is autoincremented. With MySQL you don't have to handle an autoincremented column.

[derby]

Autoincrementing happens on the insert, not the update. There's not enough info in the OP but cid is either the primary key or part of a compound key and it needs to be part of the update sql. (sigh ... I need to remove *master of subtlety* from my CV).

[spatterson]

This is where DBI]'s last_insert_id comes in handy ... oh, thats only in DBD::Pg but you can always select the highest id immediately after inserting a record.