> Well, I am not sure that is true...if you have 3 blocks of > SQL : an insert, and update and a delete in a transaction > like below and the delete fails then the system will not > rollback your first two blocks...you will have to explicitly > determine that as a developer and make the call.
In my experience, this has not been the case. By default, if any query fails within the CFTRANSACTION, all other queries using the same connection information (datasource, username, password, etc) will be rolled back. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185222 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
