On Fri, 16 Jul 2004 21:11:58 -0400, Stacy Young <[EMAIL PROTECTED]> wrote: > I've got a batch process that runs nightly on one system. It loads a > whack of orders in a particular state, constructs a batch file while > updating the status of each order. I'd like to safeguard the process so > that if there's a failure at any point, ALL db transactions are rolled > back. Will that actually happen if I'm feeding multiple calls thru my > DAO?
Yes. I have a system that does exactly this same thing. I have files containing multiple orders. I open the file, start a transaction and then call CFC methods for each order then end the transaction. If any order errors out, the entire batch is rolled back. Note that all DB operations must be on the same datasource for this to work. ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
