> And this is the info in the MySQL 5 docs that convinced me > that LAST_INSERT_ID() was a safe means of retrieving id's, > even with unlimited number of users working simultaneously... > > ============================================================== > > 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. > > ============================================================== > > Am I wrong in my understanding? No locks, no transactions needed?
You are correct. No locks or transactions are needed. Many database servers provide analogous functionality. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301911 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
