Hi, 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? ___________________________________ David Konopka Systems Programmer Wharton Computing and Information Technology E-mail: [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:251391 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
