Thanks. cleared a big headache.. it was like questioning your own wife; does she/it or does she/it not? lol
On Tuesday, May 1, 2007 11:17:33 AM UTC+5:30, Dr. Tarique Sani wrote: > > From > http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_last-insert-id > > "The ID that was generated is maintained in the server on a > per-connection basis. This means that the value returned by the > function to a given client is the first AUTO_INCREMENT value generated > for most recent statement affecting an AUTO_INCREMENT column by that > client. This value cannot be affected by other clients, even if they > generate AUTO_INCREMENT values of their own. This behavior ensures > that each client can retrieve its own ID without concern for the > activity of other clients, and without the need for locks or > transactions." > > HTH > Tarique > > -- > ============================================================= > PHP for E-Biz: http://sanisoft.com > Cheesecake-Photoblog needs you!: http://cheesecake-photoblog.org > ============================================================= > > > On 5/1/07, [email protected] <javascript:> > <[email protected]<javascript:>> > wrote: > > > > Hello Cake Folk, > > I have been trying to determine if Model::getLastInsertID is > > thread safe. I'm looking to get the id of the record that I inserted > > with the statement (I'm using save() for inserting, not just > > updating): > > > > $this->Thing->save($this->data) > > > > I'd like to be able to use the ID of this record without retrieving it > > again. I would like to continue to use the auto-increment feature of > > my database. > > > > Obviously, my concern here is having forty people all click a create > > button at the same time. > > > > > > Thanks for any light you can shed. > > > > > > > > > > > -- You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php?hl=en-US.
