2009年2月5日星期四

[fw-db] Transactions: Possible to Insert and Update same row in one trans?

Hello,

Is it possible to insert data into a table, then use that 'lastinsertID' in
an update call to the same row just inserted , all within the same
transaction?

I want to:
1. insert a new row with some data.
2. get the last inserted id.
3. update the row i just inserted with other data using the iD of that row
just added.

So is this possible to do within the same transaction?

I know it sounds dumb, but there is other stuff going on between #2 and #3
that I get data generated from another insert..etc..

Thanks.


--
View this message in context: http://www.nabble.com/Transactions%3A-Possible-to-Insert-and-Update-same-row-in-one-trans--tp21861186p21861186.html
Sent from the Zend DB mailing list archive at Nabble.com.

没有评论: