No. CFLOCK (and all other tags) run locally on each server, and are not aware of other CFLOCKS on other CF servers.
If you want them to all wait in line, the best solution may be to use a CFTRANSACTION around your table check to block the other servers out of that DB table/row till your DB timestamp has been updated. -Cameron > I have 3 mirrored servers accessing the same SQL-Server DB. They > are all running an agent that retrieves news and weather. For > redundantcy, They are each running the agent. I have set up a > table that keeps track of the last time the agent ran and each > server will check the table first before trying to run the agent. > If the agent has ran in the last 30 min it will abort. > > These servers will all be synched up, and as such, they will > be trying to run these agents at the exact same time. So I thought > I would just put a cflock around the read and make the servers > get in line and the first one to the server wins. > > Heres the question: Will this work? Will this lock reads by other > servers? ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
