Re^2: sql queries updation improper

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

Comment on Re^2: sql queries updation improper

Replies are listed 'Best First'.
Re^3: sql queries updation improper by derby (Abbot) on Jul 16, 2007 at 13:58 UTC
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). -derby	[reply]
Re^3: sql queries updation improper by spatterson (Pilgrim) on Jul 17, 2007 at 15:39 UTC
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. just another cpan module author	[reply]