The first one, so you can rollback the transaction in the CFCATCH block:
<cftransaction action="begin">
<cftry>
<cfquery>
<cfquery>
<cfquery>
<!--- this is optional --->
<cftransaction action="commit" />
<cfcatch>
<!--- something happened, roll it back --->
<cftransaction action="rollback" />
</cfcatch>
</cftry>
</cftransaction>
---
Barney Boisvert, Senior Development Engineer
AudienceCentral (formerly PIER System, Inc.)
[EMAIL PROTECTED]
voice : 360.756.8080 x12
fax : 360.647.5351
www.audiencecentral.com
> -----Original Message-----
> From: Andy Ousterhout [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, May 28, 2003 12:38 PM
> To: CF-Talk
> Subject: <cftransaction> <cftry> order
>
>
> Brain cramp....Which is best/correct:
>
> <cftransaction>
> <cftry>
>
> <cfcatch>
>
> </cftry>
> </cftransaction>
>
> OR
>
> <cftry>
> <cftransaction>
>
> </cftransaction>
>
> <cfcatch>
> </cftry>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
