Hi, I can implement nested transactions with ADO because you have access to the connection.
But as you know cftransaction can not be nested and opening and closing tag must be on same page. Is there a way to do something like the below in ORACLE. I don't see how when you an't be sure what connection CF might use to process your query. I don't want to start writing stored procs in oracle <cfquery attributes> set transaction name 'inner' </cfquery> <cfquery attributes> insert into .... </cfquery> <cfquery attributes> update .... </cfquery> <cfif CONDITION> <cfquery attributes> rollback 'inner' </cfquery> <cfelse> <cfquery attributes> commit 'inner' </cfquery> </cfif> --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
