This isn't really a nested CFTRANSACTION.
The word CFTRANSACTION appears 3 times but the ACTION="ROLLBACK"
and ACTION="COMMIT" are effectively sub-tags.
The 3 different things are analogous to the 3 SQL commands, BEGIN/END
TRANSACTION, ROLLBACK and COMMIT.
There's only one transaction block, delimited by the ACTION="BEGIN"
and the </CFTRANSACTION>.
You can't nest CFTRANSACTION blocks. It wouldn't make sense.
Nick
-----Original Message-----
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 01, 2001 1:16 PM
To: CF-Talk
Subject: RE: Nesting CFTRANSACTIONs
Actually <CFTransaction> can be nested in 4.5
Here is the sample code from the CFStudio 4.5.2 docs:
<CFTRANSACTION ACTION="BEGIN">
<CFQUERY NAME='makeNewCourse' DATASOURCE='cfsnippets'>
</CFQUERY>
------------------------------------------------------------------->
<CFCATCH TYPE="DATABASE">
<CFTRANSACTION ACTION="ROLLBACK"/>
<CFSET commitIt = "No">
</CFCATCH>
<CFIF commitIt>
<CFTRANSACTION ACTION="COMMIT"/>
<CFELSE>
<CFSET commitIt="Yes">
</CFIF>
</CFTRANSACTION>
-----Original Message-----
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 01, 2001 7:07 AM
To: CF-Talk
Subject: RE: Nesting CFTRANSACTIONs
> Explanation: You have used a CFTRANSACTION tag within the
> scope of another CFTRANSACTION tag (nesting of
> CFTRANSACTION tags is not permitted).
>
> Sorry to point out the obvious but!
Lol!
Well, I was clutching at straws thinking that maybe certain attribute
combinations allowed it, but now you mention it, I suppose it is pretty
clearly stated ;-)
Back to the drawing board.
Thanks
--
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services
http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
