Since serializable is the only isolation level that is meant to eliminate phantom reads, that means that this approach will probably only work if you set the isolation level to serializable (and, of course, that your RDBMS supports it). Which includes the performance implications that this isolation level brings.
On Mon, Oct 26, 2009 at 3:09 PM, Brian McCairn <brian.mcca...@medicapp.eu>wrote: > > select the max id straight after the insert and wrap it all in > cftransaction tags > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327703 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4