I was running it in-between another cfquery tag, is this wrong? Neil
----- Original Message ----- From: "Scott Weikert" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, February 11, 2003 6:40 PM Subject: Re: @@identity and serialization errors. > At 06:29 PM 2/11/2003 -0500, you wrote: > >Yes so you are doing two things to the DB within one query? > > I guess you could say that. Though the second thing isn't really doing > anything 'to' the DB, just retrieving the value of the ID field for that > newly created row. Works like a champ for me. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4