>>is equivalent to this:
>> <cftransaction>
... queries ...
>> </cftransaction>
>>If any of the queries fail, the transaction will be rolled back.
That's >>what transactions do. For some reason, I see this kind of code
a lot, and >>I really don't know where the idea came from that you need
to use >>try/catch logic with this. If you were to do something outside
the >>database, and you wanted to roll back the transaction if that
operation >>failed, then yes, you'd use try/catch.
Dave, I read this in "Cold Fusion MX Bible" book. According to the
author and I quote, "In our tests, ColdFusion MX slows to a crawl if
CFTRANSACTION tags are not explicitly coded with BEGIN, COMMIT, and
ROLLBACK commands"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232399
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=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
