Any database transaction can go inside a transaction block. The purpose of this is to basically treat everything inside as a single transaction so that you can do a ROLLback if there is any error.
This is covered in the CF docs actually, so if your not sure you can RTFM. Russ -----Original Message----- From: Rick Root [mailto:[email protected]] Sent: 24 September 2010 16:01 To: cf-talk Subject: Re: cfinsert/cfupdate On Fri, Sep 24, 2010 at 10:55 AM, Leigh <[email protected]> wrote: > > Sounds good. It would certainly come in handy. Especially the ability to retrieve identity/autoincrement values. Can you do that by running it inside cftransaction? <cftransaction> <cfinsert> <cfquery>select @@identity ... or whatever your db uses</cfquery> </cftransaction> I'm not sure if putting this kind of thing in cftransaction does anything for you at all or even if you can put cfinsert inside a transaction... Ric ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337486 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
