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 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 ______________________________________________________________________ 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=coldfusiona 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