I knew I forgot something. What is the best way to lock when it is load balanced on two servers?
> -----Original Message----- > From: Garza, Jeff [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 18, 2002 10:53 AM > To: CF-Talk > Subject: RE: Does this lock look right? > > I think you have to give it a name. Otherwise how will CF know which lock > not to disturb? > > Jeff Garza > Lead Developer/Webmaster > Spectrum Astro, Inc. > 480.892.8200 > [EMAIL PROTECTED] > http://www.spectrumastro.com > > > > -----Original Message----- > From: Phillip Broussard [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 18, 2002 9:53 AM > To: CF-Talk > Subject: Does this lock look right? > > > <cflock timeout="120" throwontimeout="No" type="EXCLUSIVE"> > > <cfquery name="remove_content" datasource="#application.datasource#"> > delete from builder where buildtime < '#cleardate#' > </cfquery> > > </cflock> > > I just want to make sure nobody triggers this once it has started. > > Thanks > > Phillip Broussard > Tracker Marine Group > 417-873-5957 > > > > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

