You can generally avoid the problem with a cftransaction tag if you're doing the MAX(id) thing, but the other solutions are better (especially the new CF8 goodies which, for example, are a life saver for Oracle).
On Tue, Aug 19, 2008 at 11:12 PM, Scott Stewart <[EMAIL PROTECTED]> wrote: > " > > Be aware though that inserting a record and then selecting the MAX id can > result in an incorrect ID if more than one thread runs this code at the same > time. You'd probably be better off getting the last inserted ID from the > cfquery itself if you are on CF8, or looking at using a native database > function like scope_identity() (the actual function varies across > platforms). > > " > > Good point to ponder....... -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311261 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4