Thanks a lot Dave, Barney and Jason ... it seems my code was perfectly fine .. it was a bug in Railo :) it has been removed in the server updates and now everything works fi9 Alhamdulillah ... :)
Regards, Arsalan -------------------------------------------------- From: "Arsalan Tariq Keen" <arsalk...@hotmail.com> Sent: Wednesday, July 29, 2009 1:00 AM To: "cf-talk" <cf-talk@houseoffusion.com> Subject: Re: CFTRANSACTION with MS Access Database > > hey Dave... can you provide me with some literature or example code on > this > topic ... specially in regard to MS Access...? > > -------------------------------------------------- > From: "Dave Watts" <dwa...@figleaf.com> > Sent: Wednesday, July 29, 2009 12:34 AM > To: "cf-talk" <cf-talk@houseoffusion.com> > Subject: Re: CFTRANSACTION with MS Access Database > >> >>> 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? >> >> You should be able to wrap the CFTRANSACTION itself in CFTRY/CFCATCH, >> or use CFERROR with the page; if the transaction fails, you should get >> an exception. >> >> That said, I've never had any problems with CFTRANSACTION around two >> queries using MS Access. It's actually covered in an exercise within >> the official Adobe course curriculum. >> >> Dave Watts, CTO, Fig Leaf Software >> http://www.figleaf.com/ >> >> Fig Leaf Software provides the highest caliber vendor-authorized >> instruction at our training centers in Washington DC, Atlanta, >> Chicago, Baltimore, Northern Virginia, or on-site at your location. >> Visit http://training.figleaf.com/ for more information! >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:325055 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4