login / permission / locking / ....please help

[imstillatwork]

I have a group based security system written, and it works pretty good. users can be in more then one group, .cfm or folders can have more than one group accessing them...
here is my problem.... I have a helpdesk issue management application that I am writting in CF(almost finished) We have multiple HelpDesk Operators here. I dont want one person to open a task and make changes to it if another person has that taks opened also...Can this be done? I have thought of a 1/0 switch in the database, but if a browser is closed, or the go back button is used, the lock will remain, while the user is not in the task...

Is there a way one user can check the session variable of another? and see what task he is in? Any Ideas??

Thanks...



IF YOU DON'T KNOW HOW A TAG WORKS...
...DOWNLOAD THE CFML REFERENCE!

 

[srclara]

The way we got round this problem was to set an in-use date-time stampon the record, which is set when a visitor views a page for updating. If he updates it and properly navigates to another page, the stamp is set to zero, if he uses the back button, closes the brpwser or simply leaves the page on screen, the time stamp remain set.

When another user tries to update the page, it tests the time stamp. If it was set within a predetermined period, it doesn't allow the update and prints a message saying who is viewing the record.

The predetermined period should be the same as the session time out, so that if a visitor leaves the page on his screen, when he goes back to the system it will require him to log in again.

This is the best we can come up with for this.

SR