>I need some help. What I�m trying to do is setup a transaction that�s >purpose is to move a record from table �A� to table �B� and if it is >successful delete it from �A.� If anything fails roll back and output >the error. Can anyone please offer some insight to either using >different code or patching what I have below? > >I'm running CF5 Enterprise.
Just wrap it all in a <cftransaction> and you'll be fine: <cftransaction> <cfquery...> INSERT INTO table2 ( columnName ) SELECT columnName FROM table1 </cfquery> <cfquery...> DELETE FROM table1 WHERE id = #yourID# </cfquery> </cftransaction> Regards, Dave. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
