Ask a Question related to Coldfusion Database Access, Design and Development.
-
bburkettaz #1
SQL Server Locking
I have an application that allows users to select the next person in a table
based on a callback time and an InUse bit field. It is critical that the same
person in the table not be selected by 2 users at the same time. I have the
select statement and an update statement that changes the bit field to 1 inside
a transaction in a stored procedure. I thought that by putting it in a
transaction, the row would be locked, and only one person would be able to read
the row at a time. However, I've had a couple of occasions where 2 users
selected the same person from the table. How should I go about ensuring that
this doesn't happen again?
bburkettaz Guest
-
Tickets locking
I haven't tried this sort of thing before, so I'd appreciate some pointers in the right direction. I'm trying to create a low-key kind of event... -
SO Locking on Server
I am trying to understand how to lock and unlock sharedObjects on the server so I can factor the function calls appropriately between a master... -
Need Help with Locking
I need help with understanding about locking. I have my DSN created as Application Variable . I want to lock a transaction in one of the module to... -
DB2 locking UDF dll
Meg wrote: Which version of db2 are you using? For v8, try set KEEP_FENCED to no (db2 update dbm cfg using KEEP_FENCED NO). This way, the fenced... -
locking my computer
i run on xp home and there is supposed to be a 'lock your computer'option in the task manager - mine does not have one ---- can anyone help??? -
jdeline #2 Re: SQL Server Locking
Check out <CFTRANSACTION> at [url]http://livedocs.macromedia.com/coldfusion/5.0/CFML_Reference/Tags103.htm#1104164[/url]
jdeline Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
