Chris, I am surprised you haven't gotten a reply as of yet.
The way I understand it, and I haven't had a chance to look at it yet. But if I think it works the way it should then you could do something like this. <cftry> <cftransaction action="begin"> </cftransaction> <cfcatch> </cfcatch> <cftransaction action="commit" /> </cftry> Now the thing that I am not 100% sure on is a nested cftransaction action="commit" so it could look something like this. <cftry> <cftransaction action="begin"> <cftransaction action="commit"> ... Do the log transfer.... </cftransaction> </cftransaction> <cfcatch> </cfcatch> <cftransaction action="commit" /> </cftry> However, if it was me and I am not sure how you are doing this or what logic you have. But it sounds like a log is going to happen no matter if a transaction to the DB is successful or not. Which means this is your better bet. <cftry> <cftransaction action="begin"> .. do your sql logic here </cftransaction> <cfcatch> <cftransaction action="rollback" /> </cfcatch> </cftry> <cftransaction action="commit"> ... Do the log transfaction.... </cftransaction> This way the log is done no matter what, but both scenarios should work. Just never done it myself. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Velevitch Sent: Monday, 7 July 2008 11:28 AM To: [email protected] Subject: [cfaussie] How do I do concurrent database CRUD in the same application? How do you do application logging into the same database inside a transaction that might get rolled back? -- Chris -- Chris Velevitch Manager - Adobe Platform Users Group, Sydney m: 0415 469 095 www.apugs.org.au Adobe Platform Users Group, Sydney July meeting: Taming The Code Date: Mon 28th July 6pm for 6:30 start Details to follow. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
