Quoting Phillip Broussard <[EMAIL PROTECTED]>: > <cflock timeout="120" throwontimeout="No" type="EXCLUSIVE"> > > <cfquery name="remove_content" > datasource="#application.datasource#"> > delete from builder where buildtime < '#cleardate#' > </cfquery> > > </cflock>
You need to supply a NAME or a SCOPE attribute. It looks like you need to use scope="Application", but in that case it could lock up your application for a long time. You might want to reconsider doing it this way, or even needing it since databases tend to have good concurrency handling anyway. ______________________________________________________________________ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
