Hi, I am currently designing a site for a local golf club and they would like a CMS built into it - not problem there then I use HTML Editor etc. However, they would like multiple people to edit the site and I was wondering if there is a way to lock down a page while it is being edited so that no-one else can edit at the same time - ideally a message would appear saying Mr Bloggs is currently editing this page, please come back later.

Is this possible or am I over complicating things?

Cheers.

Hi Dean

It is possible and can be tricky. Whenever you implement locking, you need to make sure you build in a mechanism for unlocking the locked records.

You could have an extra column in the db record you are editing to state whether the record is available for locking, updating the value to LOCKED when you are in edit mode, then resetting it when you have finished with the record. There will be times when the record is still in locked mode, so you need to build some kind of administration level unlock record functionality. Depending on the access levels this maybe redundant, becaue anyone with admin level could make a record available even when set to LOCKED. If you have multi admin level access you could do this

You could implement record level locking in your database while in edit mode, but again you need to have access to the databse to unlock records.

Hope this helps.

Sharing Knowledge Saves Valuable Time!!!
~ ~ ~ ~ ~ ~
<b>Lee Diggins</b> - <i>DMXzone Manager</i>
<font size="1">[ Studio MX/MX2004 | ASP -> VBScript/PerlScript/JavaScript | SQL | CSS ]</font>