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 ______________________________________________________________________ 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=coldfusiona 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
