"select xxx...for update..." will allow for level of row locking
-----Original Message-----
From: John Dixon [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 09, 2000 7:46 AM
To: [EMAIL PROTECTED]
Subject: Database Record Locking
Hello,
Just trying to figure this out:
The App:
I have a JSP page that collects data from a database and displays it in
textfields. The user can change the data. click OK and the database is
updated.
The question: How do I lock the record in the database so that another
user
cannot change the data whilst this user is in the midst of changing the
data. Using MSSQLServer.
Many thanks!
JD
========================================================================
===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
