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
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
RE: Nesting CFTRANSACTIONs
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
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! -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: 31 January 2001 17:21 To: CF-Talk Subject: Nesting CFTRANSACTIONs We have a custom tag that has a CFTRANSACTION in it. That tag is called from 3 other templates, all of which call it from within a query-driven CFLOOP. Ideally, I'd like to be able to retain the CFTRANSACTION within the custom tag but also wrap a CFTRANSACTION around the query-driven loop, but I'm getting this error: CWebException: Error: Invalid use of CFTRANSACTION tag Explanation: You have used a CFTRANSACTION tag within the scope of another CFTRANSACTION tag (nesting of CFTRANSACTION tags is not permitted). This error very likely results from the unintentional omission of the end tag (/CFTRANSACTION) for your first CFTRANSACTION. The closing tag is there, BTW. Is nesting CFTRANSACTIONS possible at all, perhaps by using certain attribute parameters? 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