No guys.... this isn't working ... nor that what Barney and Dave advised... does anyone has a working example of such scenario? I would be very thankful if someone provides me with a somewhat similar working example.... and yes... I am using using CFTRY/CFCATCH because I need to log the errors and get a notification if a database exception occurs without breaking the flow of my page.... is there any alternate to CFCATCH/CFTRY for this purpose?
-------------------------------------------------- From: "Jason Fisher" <ja...@wanax.com> Sent: Tuesday, July 28, 2009 10:50 PM To: "cf-talk" <cf-talk@houseoffusion.com> Subject: Re: CFTRANSACTION with MS Access Database > > Try putting your CFTRY / CFCATCH around the outside of the CFTRANSACTION > ... the error handler is not triggering your roll-back, I would guess. > > <cftry> > <!---//Starting Transaction -----------------------------------------> > <cftransaction> > <!---//QUERY1 Insert ----> > <cfquery name="insertDAP" datasource="#data2#"> > INSERT STATEMENT 1 > </cfquery> > > <!---//QUERY2 Insert --------> > <cfquery name="insertMW" datasource="#data2#"> > INSERT STATEMENT 2 > </cfquery> > </cftransaction> > > <!---//CFCATCH for Database errors ----------------------------------> > <!--- note, no rollback here, just let the transaction fail above if there > was an error ---> > <cfcatch type="database"> > <cflog text="Error Code: #cfcatch.ErrorCode#, > Error Message: #cfcatch.Message#, > Detail: #cfcatch.Detail#, > Extended Info: #cfcatch.ExtendedInfo#, > Root Cause: , > Type: #cfcatch.Type#, > Native Error Code: #cfcatch.NativeErrorCode#, > SQL State: #cfcatch.SQLState#, > SQL: #cfcatch.SQL#, > Querry Error: " > > type="Error" file="SI_ATP.log" application="yes"> > </cfcatch> > </cftry> > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325040 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4