Beefy Boxes and Bandwidth Generously Provided by pair Networks
Come for the quick hacks, stay for the epiphanies.
 
PerlMonks  

Re^2: sql queries updation improper

by Tobin Cataldo (Monk)
on Jul 16, 2007 at 13:00 UTC ( [id://626835]=note: print w/replies, xml ) Need Help??


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.

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
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

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://626835]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others avoiding work at the Monastery: (3)
As of 2024-03-29 14:18 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found