> I was wondering if anyone had any experience executing > cfstoredproc calls within cftransaction's. > > The livedocs for cftransaction focus on cfquery operations. > Though, using a MS Sql Server 2000 database, cftransaction > seems to fully support rollback of cfstoredproc calls. > > I know it would be ideal to combine my sql work into a single > stored proc and let the SQL server handle transactions. But > I'm working with pre-built DAO cfc's that I'd rather not hack > into if I can handle transactions efficiently in CF in the > business layer. > > Anyone know of any performance or compatibility issues with > doing this?
You should have no problems doing this. I haven't. 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! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251397 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
