> The problem is that each Server has to read and THEN write > before the next one reads. Any ideas?
If you have multiple queries that need to be treated as a single transaction, then you can use CFTRANSACTION to group those queries, or write transactional logic in a stored procedure and call that procedure. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists