RE: CFtransaction crap

2002-04-03 Thread David Schmidt
> -Original Message- > From: Dave Watts [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 03, 2002 5:51 AM > To: CF-Talk > Subject: RE: CFtransaction crap > > > > I generally use cftry/cfcatch in conjunction with cftransaction. > > This allows you to ro

RE: CFtransaction crap

2002-04-03 Thread Dave Watts
> Ok I don't think the ODBC drivers I have support the > cftransaction, how can I be sure though, there isn't > an error message. If I am updating a record and I > rollback at the end, it should go back to the number > it was before, correct? Or does it only work for > inserts. Yes, if you m

RE: CFtransaction crap

2002-04-03 Thread Robert Everland
III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 8:51 AM To: CF-Talk Subject: RE: CFtransaction crap > I generally use cftry/cfcatch in conjunction with cftransaction. > This allows you

RE: CFtransaction crap

2002-04-03 Thread Dave Watts
> I generally use cftry/cfcatch in conjunction with cftransaction. > This allows you to roll back if errors are encountered. You really don't have to do this. That's one of the features that CFTRANSACTION provides for you. If you have multiple queries within a single transaction, and any fails,

RE: CFtransaction crap

2002-04-02 Thread David Schmidt
Whoops, This should be correct. Sorry for the mis-code. :) Robert, I generally use cftry/cfcatch in conjunction with cftransaction. This allows you to roll back if errors are encountered. The general outline is this: some sql... some sql... Set it to false

RE: CFtransaction crap

2002-04-02 Thread David Schmidt
Robert, I generally use cftry/cfcatch in conjunction with cftransaction. This allows you to roll back if errors are encountered. The general outline is this: some sql... some sql... Set it to false if there was an error... Success!!!