RE: CFTransaction & Rollback on error?
Yep. Something like this: Error Handler Code is similar to this (the parts that matter for this discussion... ): But, I get the error I initially reported on the Rollback line. Hope that helps some. Shawn Grover -Original Message- From: Justin Scott [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 11:29 AM To: CF-Talk Subject: Re: CFTransaction & Rollback on error? You are using action="begin" on the opening CFTRANSACTION call right? -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com - Original Message - From: "Shawn Grover" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, April 16, 2002 1:28 PM Subject: RE: CFTransaction & Rollback on error? > Nope, got the same error. Thanks though. > > Any other ideas/insight? > > Shawn Grover > > -Original Message- > From: Justin Scott [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 16, 2002 10:23 AM > To: CF-Talk > Subject: Re: CFTransaction & Rollback on error? > > > Just before the CFABORT, try placing the CFTRANSACTION check in again and > close the transaction if there is one open. > > -Justin Scott, Lead Developer > Sceiron Internet Services, Inc. > http://www.sceiron.com > > > - Original Message - > From: "Shawn Grover" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, April 16, 2002 12:17 PM > Subject: CFTransaction & Rollback on error? > > > > I have a custom tag that handles errors for us. I added these lines of > code > > to the tag to do a rollback, if an error occurs and a transaction is in > the > > process: > > > > > > > > > > > > > > However, I keep getting an error saying the rollback MUST be between > > and tags. > > > > My custom tag eventually does a if an error occurs (after > > displaying appropriate messages). Is that where the problem is? If so, > do > > I need to do an explicit rollback like this? > > > > Any suggestions are appreciated. Thank you. > > > > Shawn Grover > > > > > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFTransaction & Rollback on error?
You are using action="begin" on the opening CFTRANSACTION call right? -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com - Original Message - From: "Shawn Grover" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, April 16, 2002 1:28 PM Subject: RE: CFTransaction & Rollback on error? > Nope, got the same error. Thanks though. > > Any other ideas/insight? > > Shawn Grover > > -Original Message- > From: Justin Scott [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 16, 2002 10:23 AM > To: CF-Talk > Subject: Re: CFTransaction & Rollback on error? > > > Just before the CFABORT, try placing the CFTRANSACTION check in again and > close the transaction if there is one open. > > -Justin Scott, Lead Developer > Sceiron Internet Services, Inc. > http://www.sceiron.com > > > - Original Message - > From: "Shawn Grover" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, April 16, 2002 12:17 PM > Subject: CFTransaction & Rollback on error? > > > > I have a custom tag that handles errors for us. I added these lines of > code > > to the tag to do a rollback, if an error occurs and a transaction is in > the > > process: > > > > > > > > > > > > > > However, I keep getting an error saying the rollback MUST be between > > and tags. > > > > My custom tag eventually does a if an error occurs (after > > displaying appropriate messages). Is that where the problem is? If so, > do > > I need to do an explicit rollback like this? > > > > Any suggestions are appreciated. Thank you. > > > > Shawn Grover > > > > > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFTransaction & Rollback on error?
Nope, got the same error. Thanks though. Any other ideas/insight? Shawn Grover -Original Message- From: Justin Scott [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 10:23 AM To: CF-Talk Subject: Re: CFTransaction & Rollback on error? Just before the CFABORT, try placing the CFTRANSACTION check in again and close the transaction if there is one open. -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com - Original Message - From: "Shawn Grover" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, April 16, 2002 12:17 PM Subject: CFTransaction & Rollback on error? > I have a custom tag that handles errors for us. I added these lines of code > to the tag to do a rollback, if an error occurs and a transaction is in the > process: > > > > > > > However, I keep getting an error saying the rollback MUST be between > and tags. > > My custom tag eventually does a if an error occurs (after > displaying appropriate messages). Is that where the problem is? If so, do > I need to do an explicit rollback like this? > > Any suggestions are appreciated. Thank you. > > Shawn Grover > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFTransaction & Rollback on error?
Just before the CFABORT, try placing the CFTRANSACTION check in again and close the transaction if there is one open. -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com - Original Message - From: "Shawn Grover" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, April 16, 2002 12:17 PM Subject: CFTransaction & Rollback on error? > I have a custom tag that handles errors for us. I added these lines of code > to the tag to do a rollback, if an error occurs and a transaction is in the > process: > > > > > > > However, I keep getting an error saying the rollback MUST be between > and tags. > > My custom tag eventually does a if an error occurs (after > displaying appropriate messages). Is that where the problem is? If so, do > I need to do an explicit rollback like this? > > Any suggestions are appreciated. Thank you. > > Shawn Grover > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFTransaction & Rollback on error?
I have a custom tag that handles errors for us. I added these lines of code to the tag to do a rollback, if an error occurs and a transaction is in the process: However, I keep getting an error saying the rollback MUST be between and tags. My custom tag eventually does a if an error occurs (after displaying appropriate messages). Is that where the problem is? If so, do I need to do an explicit rollback like this? Any suggestions are appreciated. Thank you. Shawn Grover __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists