i'm not sure if that's thread-safe tho... I don't remember offhand what set nocount does... but the @@identity variable is from any table in any sql server session across the database or possibly the server, not sure... SQL Server 2000 introduced a SCOPE_IDENTITY() function which _is_ thread-safe...
<cfquery> insert stuff; select scope_identity() as something; </cfquery> This function ensures that the value returned is from the last table inserted in your currently executing batch -- so if it's not in your cfquery, it won't affect the result. (iirc including triggers on the table you're inserting into which has been known to cause problems with @@identity) ... so the rule of thumb is to use scope_identity() if you can. > <cfquery> > set nocount on; > insert stuff; > select @@identity as something; > set nocount off; > </cfquery> > Just did this day before yesterday. :-) > --Ben > Phill B wrote: >> I cant remember how to return the id from an insert. I >> have searched >> but I can't find what I'm looking for. Not to mention >> people keep >> buggin me making my job harder than it should be. :-| >> >> >> Anyway, it is some thing like @@identity but I cant >> remember. Little help? >> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187114 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
