Thanks, I completely missed the "last_inserted_id" part of that blog post :O I ended up using LAST_INSERTED_ID() for MySQL and SCOPE_IDENTITY() for SQL Server. / Per
On 12/4/06, Matt Robertson <[EMAIL PROTECTED]> wrote: > > On 12/4/06, Per Djurner <[EMAIL PROTECTED]> wrote: > > I'm trying to find a good solution that works for me when it comes to > the > > classic problem of selecting the last inserted ID in a database table > and > > making sure it's thread safe. > > http://mysecretbase.com/get_the_last_id.cfm > > -- > [EMAIL PROTECTED] > Janitor, MSB Web Systems > mysecretbase.com > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262838 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4