But this in itself implies that you are using BEGIN TRAN in your SP's which is not always the case with users and SP's.
For CF and non SP-ers it is far easier to do it via cftransaction. -----Original Message----- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: 20 January 2006 12:51 To: CF-Talk Subject: Re: Where should the cftransaction tags go when using CFC's? Since Barney's covered all the CF intricacies, I'll just point out that often you can eliminate the need for a transaction in CF by moving your processing to the database and just calling a stored procedure from CF. On 1/19/06, Stan Winchester <[EMAIL PROTECTED]> wrote: > > Where should cftransaction tags go when using cfc's? For example: If the > cftransaction tags should be in the cfc, what if the cfc method calls > another method that also has cftransaction tags that should cause an error > to be thrown. Since cftransaction tags cannot be nested, should they go in > the action page as a wrapper around all methods using cftransaction tags? > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230081 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
