barry have you been a bad boy again, and trying to help people without properly reading their emails?
bad bad boy... -----Original Message----- From: And;-)rew Scott [mailto:[EMAIL PROTECTED] Sent: Thursday, 29 July 2004 1:45 PM To: CFAu;-)ssie Mailing List Subject: [cfaussie] RE: CFTransaction and CFC's Bar;-)ry, But that;-) is what I am doing, did I not sa;-)y that in my fir;-)st email? <cftry> ...more logic re;-)moved <cftrans;-)action> <cfloop index="Count" from="1" to="3"> ..more logi;-)c removed <cfset Ins;-)ertData(stufftoinsert) /> </cfloop> </cft;-)ransaction> </cftry> <cfcatch> </cfcatch> I was well ;-)aware of not ;-)doing the old, commit, begin and ro;-)llback and wasn't even needing any adv;-)ice on that!! Gosh, I wish peop;-)le would actually read emails!! Regards And;-)rew Scott Technical Consultant NuSphere Pty Ltd Level 2/33 ;-)Bank Street South Melbourne, Victoria, 3205 Phone: 03 9686 0485 - Fax: 03 9699 7976 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Beattie Sent: Thursday, 29 July 2004 1:38 PM To: CFAussie Mailing List Subject: [cfaussie] RE: CFTransaction and CFC's >> the point is that I use the cftransaction because there is a loop of >> 3 inserts and if one fails they all need to fail from a thread I started on cfczone.org http://www.mail-archive.com/[EMAIL PROTECTED]/msg05876.html <snip> > Dave, I noticed (in a houseoffusion post) you shy away from try/catch > within a transaction. how come? It's usually not necessary, especially within the commonly used example that is posted over and over again, in which an exception is thrown and caught within the CFTRANSACTION. If you have multiple queries using the same database connection within a CFTRANSACTION, and one of them fails, there's no need to catch that failure and issue a rollback, as the CFTRANSACTION tag will do that for you </snip> hope that helps barry.b --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ Register now for the 3rd National Conference on Tourism Futures, being held in Townsville, North Queensland 4-7 August - www.tq.com.au/tfconf --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
