No, I really need to lock out the possibility of refreshing all together.
The sheep, er, I mean, users have to have totally reliable data and refresh
is jeopardizing the integrity of the whole system.
"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
-----Original Message-----
From: S. Isaac Dealey [mailto:info@;turnkey.to]
Sent: Wednesday, November 06, 2002 5:01 PM
To: [EMAIL PROTECTED]
Subject: RE: locking queries
It's also possible to use <cfflush> and javascript to create a progress bar
for the users so they don't refresh the page under the assumption that it's
just not working. They might still refresh the page, but they would know
what they were doing in that case. If you'd like to see a code snippet let
me know and I'll shoot some of what I'm using over your direction.
Isaac
Certified Advanced ColdFusion 5 Developer
www.turnkey.to
954-776-0046
> 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:Matt_Mozer@;intuit.com]
> 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:jt0397@;sbc.com
> <mailto:jt0397@;sbc.com> ]
> 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
> <http://www.dfwcfug.org>
-------------------------------------------------------------------------
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
-------------------------------------------------------------------------
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
