RE: locking queries

[THORNTON, JASON A (SWBT)]

Title: RE: locking queries

Its an update statement.

 

Update DBX

SET X='X'

where X='y'

 

My concern is that there are multiple queries that update depending on the variables from my previous page. It takes a while so users are refreshing and adding invalid entries. Such as, add a 1 to a numeric column.

-----Original Message-----
From: Mozer, Matt [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 06, 2002 4:21 PM
To: '[EMAIL PROTECTED]'
Subject: RE: locking queries

what does your select statement look like?

Using Sql Server?

-----Original Message-----
From: THORNTON, JASON A (SWBT) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 06, 2002 4:11 PM
To: LUSTER, LARRY (SWBT); '[EMAIL PROTECTED]'
Cc: DEAN, JEREMY G (SBCSI)
Subject: locking queries

HI!
We are experiencing problems with users refreshing a page in the middle of
processing and adding multiple entries into SQL. Can this be fixed through a
<CFLOCK> tag around the query? Or does that just work to keep OTHER users
from using the data. I am not skilled in these slick city monkey ways, and
the reference materials only indicate exclusive use for this user.

"We can not become what we need to be
                          by remaining what we are!"
Jason Thornton
SBC DSL
Web Application Development Team
817 212-8491

-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com

-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org