Re: cftransaction cftry order

I would go with: cftry cftransaction /cftransaction cfcatch /cfcatch /cftry Since you want to catch the error that occurred as a result of the statements within the transaction. HTH Donnie Bachan Phone: (718) 217-2883 ICQ#: 28006783 Nitendo Vinces - By Striving You Shall Conquer

RE: cftransaction cftry order

The first one, so you can rollback the transaction in the CFCATCH block: cftransaction action=begin cftry cfquery cfquery cfquery !--- this is optional --- cftransaction action=commit / cfcatch !--- something happened, roll it back --- cftransaction

RE: cftransaction cftry order

Thanks. -Original Message- From: Donnie Bachan [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 3:07 PM To: CF-Talk Subject: Re: cftransaction cftry order I would go with: cftry cftransaction /cftransaction cfcatch /cfcatch /cftry Since you want to catch the error

RE: cftransaction cftry order

:49 PM To: CF-Talk Subject: RE: cftransaction cftry order The first one, so you can rollback the transaction in the CFCATCH block: cftransaction action=begin cftry cfquery cfquery cfquery !--- this is optional --- cftransaction action=commit / cfcatch !--- something

RE: cftransaction cftry order

-Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 3:49 PM To: CF-Talk Subject: RE: cftransaction cftry order The first one, so you can rollback the transaction in the CFCATCH block: cftransaction action=begin cftry cfquery cfquery

RE: cftransaction cftry order

PROTECTED] Sent: Wednesday, May 28, 2003 1:49 PM To: CF-Talk Subject: RE: cftransaction cftry order The first one, so you can rollback the transaction in the CFCATCH block: cftransaction action=begin cftry cfquery cfquery cfquery !--- this is optional --- cftransaction