Now your best bet might just be to lock it on the database...
Wrap it up in a stored proc and manually set the transaction isolation
level... This is from the SQL Server BOL ...
SET TRANSACTION ISOLATION LEVEL
{ READ COMMITTED
| READ UNCOMMITTED
| REPEATABLE READ
| SERIALIZABLE
}
I believe that serializable is the most stringent of the isloation blocks
and should restrict updates or inserts while the transaction is occuring.
Good luck,
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 10:09 AM
To: CF-Talk
Subject: RE: Does this lock look right?
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
>
>
>
>
______________________________________________________________________
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
