try looking in the cf-talk mailing list archives? I found this: http://www.mail-archive.com/cf-talk@houseoffusion.com/msg69138.html
> -----Original Message----- > From: Stephen Moretti [mailto:[EMAIL PROTECTED]] > Sent: 18 February 2002 17:07 > To: CF-Talk > Subject: Re: 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. > > > What do you want to lock? The use of the application > variable or the delete > query? > > If you're after locking the SQL then you need a CFTRANSACTION. > > You still need a lock around the use of the application > variable, but, rule > of thumb, never put a cflock around a query. Your lock will > be held until > the CFQUERY completes, locking other users out of the > application scope > (particularly EXCLUSIVE locks) until that time. > > Regards > > Stephen > ______________________________________________________________________ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists