hi rob, > i have teachers collarbrating online however some of them click the > close button before submitting. > > I have got a script going so when the teacher goes to the update form > the activity becomes disabled in the db so other teachers cant modify > the same for at once however i am relying on the fact that they hit the > submit form to ensure the activity becomes active to the next person to > modify it. > > how can i control close button at the top of the browser sooo...
I have a similiar system in place. the only way I found to make this work was use a datetime stamp on the lock when written to the db. then i use a stored procedure that runs at regular intervals to release locks on the db. I use a js function on the form page to reload the form and rewrite the db lock - it also retains any data written to the form page up to that point so the users do not loose any data that has been entered. if the user closes the browser the stored proc will release the lock. I run the stored proc every 20 minutes with the js function firing every 15 minutes. but timing will depend on complexity and time taken to fill out the form page. hth Rod --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
