I generate a UUID just before the record is stored and plunk that into a variable. Then I store the UUID into an indexed field along with whatever else I need. Then I query back for the UUID, taking the ID field from that second query's results for further use/processing.
Has the advantage of not relying on any specific db, which in turn is ONLY a good thing if your code has to run unaltered on more than one platform. Also requires no locks, transactions etc. Never any worries about race conditions or whatnot.
--
-------------------------------------------
Matt Robertson, [EMAIL PROTECTED]
MSB Designs, Inc. http://mysecretbase.com
-------------------------------------------
--
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
