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-To: [EMAIL PROTECTED] date: Mon, 4 Feb 2002 14:40:41 -0500 >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 th e >first three are ok but the last one fails I want to roll them all back. I s >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