Mailing List Archive


Back to the month index Back to the list index
Atif Ahmad Khan (aak2@ra.msstate.edu)
Wed, 11 Sep 1996 06:49:32 -0500 (CDT) 

From: Atif Ahmad Khan <aak2@ra.msstate.edu>
Message-Id: <199609111149.GAA11911@Isis.MsState.Edu>
Subject: [mSQL] Record locking using web forms ?
Date: Wed, 11 Sep 1996 06:49:32 -0500 (CDT)

I have been assigned to find a solution to this problem. We are developing
an application that will let employees access certain databases over the web
using standard forms. Our problem is that if 2 users accessed the data using
web based forms and changed it, the one that commits it last will overwrite
the changes made by the other guy.

Is there a solution to this problem ? Obviously we cant lock a row using a
web based form.

So far I have thought of 2 possibilities :

1. Feed the browser all the requested information in a form *as well as*
as hidden data. And when the user modifies the data have a script check
the hidden data against the current data and if no data has changes then
allow new data to be entered and if the data has changed then allow the user
to see it and decide if they want to ovewrite it. (This can get a little
complicated if we have too many forms.)

2. Every row be assigned a serial number that is incremented by 1 everytime
it is updated. Then that serial number is forwarded to the user as hidden
field like in the above example. If the user wants to update it then the
2 serial numbers are compared. (This sound like a little less complicated
in theory).

Is there any other solution ?

Thanks.

Atif Khan
aak2@ra.msstate.edu
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!