What version are you using? I don't notice the problem with mx 7.0.2 >Why do you have SET NOCOUNT in the first place?
The resulset generated by the insert can prevent cfquery from picking up the SELECT @@identity statement. SET NOCOUNT supresses the insert's resulset. Though they should be using SCOPE_IDENTITY() Janet ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292103 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
