With three servers you might have to write your own queueing function using a common memory space (i.e. the database) as the queue. I don't know of any other methods to achieve atomicity with three servers. I'm sure most people on the list know more about db than I do.
- Matt Small -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 26, 2002 10:13 AM To: CF-Talk Subject: RE: will cftransactoin work? The problem is that each Server has to read and THEN write before the next one reads. Any ideas? BJ = = = Original message = = = > I have 3 computers accessing a SQL-server at the same time. I > need the DB to be locked so they can't read/write the data at > the same time. How do I get the servers to "get in line" and > wait for each other? Almost all databases provide that functionality automatically. If one database client is writing to the data, other database clients won't be able to read or write that data until the first one is done. If one database client is reading the data, other database clients won't be able to write that data until the first one is done. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ___________________________________________________________ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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