Mark,
Depending on what database you're using <cftransaction> should do
exactly what you want.
<cftransaction>
<cfquery1>
<cfquery2>
<cfquery3>
<cfquery4>
</cftransaction>
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 functionality you're looking for I think
you'll find it with that tag.
t
**********************************************************************
Tyler M. Fitch
Certified Advanced ColdFusion 5 Developer
ISITE Design, Inc.
615 SW Broadway Ste. 200
Portland, OR 97205
503.221.9860 ext. 111
http://isitedesign.com
**********************************************************************
-----Original Message-----
From: mark kecko [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 04, 2002 11:41 AM
To: CF-Talk
Subject: Using CFTRY - CFCATCH to rollback database tranaction
Is there a way to use CFTRY - CFCATCH to rollback all database
tranactions within given block? In otherwords, If I'm running 4 update
queries and the first three are ok but the last one fails I want to roll
them all back. Is there a better way to do this than usign CFTRY -
CFCATCH?
Mark Kecko
Technology Director
MediaPost Communications
[EMAIL PROTECTED]
http://www.mediapost.com
(203)222-0330 ext309
______________________________________________________________________
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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
