Ooops, replied to the wrong message. This was in reply to Bud's question about CFTransaction and MySQL. (http://www.houseoffusion.com/lists.cfm?link=m:4:25355:127593) Sorry.
cheers Jordan -----Original Message----- From: Jordan Thomas [mailto:[EMAIL PROTECTED] Sent: Wednesday, 9 July 2003 3:45 PM To: CF-Talk Subject: RE: cftransaction quick question Yes, but if you want it to work then make sure to use either InnoDB or one of the other transaction safe tables. You will need to configure this manually. There is a good amound of docs on how to do this on www.mysql.com cheers Jordan -----Original Message----- From: Lofback, Chris [mailto:[EMAIL PROTECTED] Sent: Wednesday, 9 July 2003 3:37 PM To: CF-Talk Subject: RE: cftransaction quick question > - 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
