Re: sql queries updation improper

Uhh ... yeah ... you're missing something. Read that second sql statement out loud while looking at your table. Do you see it? update table set field = value where id = key. Looks like the table is updated correctly to me. Still don't see it? Okay, here's a hint: where's cid come into play?

-derby

Comment on Re: sql queries updation improper Download Code

Replies are listed 'Best First'.
Re^2: sql queries updation improper by Tobin Cataldo (Monk) on Jul 16, 2007 at 13:00 UTC
The OP said that cid is autoincremented. With MySQL you don't have to handle an autoincremented column.	[reply]
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]