Original poster here...for the record I'm using MySQL 5. Update: I added the named lock and that squashed the problem completely.
In my case there is some additional code involved rather than just back-to-back database updates, PLUS the possibility of some shared scope issues, AND we are on a single server, so I think the named lock is the best option for me in this case. I will definitely keep cftransaction in mind, if I have a situation which seems to merit it more definitively. -- Josh ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:288199 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4