I don't want to cloud this conversation but I have to say that in all my years of development, I've never had a database collision using ColdFusion. I put my multiple database calls into cftransaction and I use cflock when I'm trying to access a client's session or cookie. I've never put a single cflock around my cftransactions and I've been fine. Maybe, according to some theories on this thread, a better way to put it is that I've been lucky but I'm not so sure.
I allow the database to control this which is what my MS SQL Servers are designed for. Maybe other databases are problematic? Maybe my applications aren't as busy? I'm really trying to understand the logic behind the need to use cflock in place of or in addition to cftransaction. Vince Collins http://www.vincentcollins.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288368 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
