A great site for oracle stuff  like this is :

http://asktom.oracle.com/

Theres a great search engine and Tom seems to spend a lot of his time
answering questions.


-----Original Message-----
From: Ryan Geesaman [mailto:[EMAIL PROTECTED]
Sent: 02 October 2003 04:46 PM
To: CF-Talk
Subject: Retaining Database Row Locks Across User Requests


We are using CFMX 6.1 and Oracle 9i.  How do we retain database row
locks from one request (query of information to display in a HTML form)
to the next (updating the information)?  Data integrity is the concern
of course...how to keep two users from updating the same record from the
database at the same time.

I've been trying to use SELECT...FOR UPDATE without any success.

Thanks,
Ryan A. Geesaman
Applications Developer
Penn State College of Medicine
Health Evaluation Sciences
  _____  

[ Todays  
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to