RE: Using CFTRY - CFCATCH to rollback database tranaction

2002-02-04 Thread Haggerty, Michael A.
Mark; Put everything in a CFTRANSACTION type=serializeable block. Should one fail, they are all rolled back. Mike -Original Message- From: mark kecko [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 2:41 PM To: CF-Talk Subject: Using CFTRY - CFCATCH to rollback database trana

RE: Using CFTRY - CFCATCH to rollback database tranaction

2002-02-04 Thread Tyler M. Fitch
Mark, Depending on what database you're using should do exactly what you want. If anything in all those queries fails they all get rolled back to their original state. A cftry/cfcatch can be added so the user doesn't get an error screen, but as far as the

Re: Using CFTRY - CFCATCH to rollback database tranaction

2002-02-05 Thread Chris Norloff
The 4.5.2 documentation has an example of what you want to do, by using cft ransaction with cftry/catch Look at the usage example in the tag descripti on for cftransaction. Chris Norloff -- Original Message -- from: "mark kecko" <[EMAIL PROTECTED]> Reply-

Re: Using CFTRY - CFCATCH to rollback database tranaction

2002-02-05 Thread Chris Norloff
The 4.5.2 documentation has an example of what you want to do, by using cft ransaction with cftry/catch Look at the usage example in the tag descripti on for cftransaction. Chris Norloff -- Original Message -- from: "mark kecko" <[EMAIL PROTECTED]> Reply-

RE: Using CFTRY - CFCATCH to rollback database tranaction

2002-02-05 Thread Dave Watts
> The 4.5.2 documentation has an example of what you want to > do, by using cftransaction with cftry/catch Look at the usage > example in the tag description for cftransaction. Unfortunately, that "example" is probably the worst instance of poor coding you're going to find within the documenta