I have several insert query statements that are CFIncluded as separate files inside a single CFCase statement. cfcase. cfinclude = "qry_insert1.cfm". cfinclude = "qry_insert2.cfm". cfinclude = "qry_insert3.cfm". cfinclude = "qry_insert4.cfm". /cfcase.
Can I put "cftry" and "cftransaction begin" in the first include and put the end tags /cftry /cftransaction in the last include? Would anyone have a way to manage multiple inserts such that they all rollback if anyone of them fails? Is the above the wrong approach? Greg M ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
