This might help everyone... Regardless of DBMS... http://www.forta.com/blog/index.cfm/2007/7/6/ColdFusion-8-Can-Return-Identit y-Values
-----Original Message----- From: James Holmes [mailto:[email protected]] Sent: Wednesday, April 28, 2010 9:43 PM To: cf-talk Subject: Re: SQL Gurus... obtaining the correct Incremental ID You can of course avoid the whole issue by using the result_name.IDENTITYCOL value returned from the cfquery tag (if you are on CF8 or higher). mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 29 April 2010 01:51, Che Vilnonis <[email protected]> wrote: > > When using "set nocount on", "select @@identity as xyz" and "set > nocount off" in a cfquery, how can I be certain that two transactions > that occur at roughly the same time obtain the proper incremental id > from an Identity column? Is their a SQl equivalent to CF's cflock tag? > > Thanks, Che > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:333225 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
