>- see footer for list info -< "If the first query didn't find any matching records to delete (i.e. not on the table), would this count as 'not successful'"
No, it will take something going wrong for the transaction to rollback unless you do it programmatically. Ade -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Allan Cliff Sent: 17 May 2005 11:26 To: Richard Lovelock; Coldfusion Development Subject: RE: [CF-Dev] CFTRANSACTION and DELETEs >- see footer for list info -< That is true although there are different levels of Isolation. Not only do you have that file doing a delete and insert there maybe another thread also doing it at the same time. Keep that in mind Allan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard Lovelock Sent: 17 May 2005 12:19 To: cfdev Subject: [CF-Dev] CFTRANSACTION and DELETEs >- see footer for list info -< I have a block of code that needs to delete a record from a table and insert an action audit trail of the deletion in to a different table. Something like: Delete from X where ID = 1 Insert into Y Values 1, deleted Is this a good place to use CFTRANSACTION around the whole block of two queries? As I understand - the cftransaction will not perform the second query if the first is not successful. If the first query didn't find any matching records to delete (i.e. not on the table), would this count as 'not successful' and therefore skip the bottom query? Hope that's clear!? -- Richard Lovelock -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.11 - Release Date: 16/05/2005 _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
