Maya I tried something similar to what you are showing as suggested by somebody earlier in the thread. Same result.
By the way, the fact that the commit occurs before the catch should not be an issue (should it?). If there is an error above the commit statement, it will jump over the commit and go directly to the cfcatch. That commit will never get executed (right?). I have code similar to this elsewhere in this application and it works fine. The only difference is that in the working code the cftry, transactions, and loop are all done on the processing page (calling methods in a .cfc), whereas in this example everything is contained in the cfc method. I am wondering if that has anything to do with it. I am going to try to break it out and handle the transactions, etc on the calling page and see if that makes a difference. Steve Maya Tulchinsky wrote: > Steve, > > You have <cftransaction action="commit" /> before cfcatch. > > Move commit to after you done with error. > Here is some code that should work: > > <cfcatch type="any"> > <cftransaction action = "rollback"/> > <cfrethrow> > <cfset commitIt = "No"> > </cfcatch> > > </cftry> > </cftransaction> > > <cfif commitIt> > <cftransaction action="commit"/> > > </cfif> > > Hope that helps. > > MT > --- --- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:258427 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
