> - No need for cftransaction on a single SQL query True, but I would always use a CFCATCH to trap any errors.
> - cftansaction is good practice for a single stored procedure call in > case the stored procedure is doing multiple SQL queries I don't know if you read my previous post, but I don't think this is true. CFTRANSACTION cannot "talk" to the code inside a SP. You must write the transaction handling *within* the SP. So if the SP does 10 mods to the database, each mod within the SP must be checked for success/failure and then rolledback/committed by the SP code itself. CFTRANSACTION cannot be used to do this. Chris ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4