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:325050 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4