The way the CFTransaction tag works is CF is putting the TRANSACTION statements in the T-SQL it sends to the server. So the rollback tag will rollback any transactions that haven't been committed. You could have 100's of queries running with Inserts/deletes/updates and everything will rollback. It's the same if you wrote a T-SQL and started it with BEGIN TRANSACTION and ended it with ROLLBACK TRANSACTION. This is great way to test stuff, because nothing gets committed, but all of the steps occur.
> Good catch - you're right; I would normally include a cfif to append > the return string and the "<br>" to allReturnMessages only if the > return string isn't empty. > > The stored proc was written by someone else, so I'm not 100% sure > what's happening with it, which is part of the problem. I suppose > what I should be asking is - is it even possible to do what I'm trying > to do? Which is, loop over a variable number of records to be saved or > updated, and after the loop has finished, test to see if ANY of them > have gotten a positive-length string back from the proc, and if so, > rol lback ALL of them? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329109 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
