We do it like this:
<cftransaction action="begin" isolation="serializable">
<cftry>
<!--- [mjh] Query here: --->
<cfquery>
...
</cfquery>
<cftransaction action="commit" />
<cfcatch>
<cftransaction action="rollback" />
<cfdump var="#cfcatch#">
<cfabort>
</cfcatch>
</cftry>
</cftransaction>
Will Tomlinson wrote:
> Figured someone would know and answer quicker than me testing this.
>
> Can you wrap a query with cftry inside a cftransaction?
>
> Thanks,
> Will
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259429
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
