Hey voltron,

I'll take a look at the library, it looks pretty cool.  David Turner,
makes some really good points and is really the main thing that I''ve
worried about.  My current site (the one that needs lots of work read I
don't like the way I did it) uses a database to keep the locks, which I
"unlock" when the user leaves the page (I'm using javascript thats
pretty buggy and doesn't alway work) so I'm left doing occational
cleanup on the Lock table.  Luckily for this project I have a pretty
limited set of users so when I delete locks I'm pretty sure I'm not
getting rid of an active lock, but I'm not really fond the the code. 
Like I said its pretty buggy.

What I really need is someway to know when a user leaves the website -
but I don't think thats really possible or reliable.
Jose

Jose



voltron wrote:
> This is the plugin I intend to use, it can effectively block user
> input if needed with notification:
>
> http://www.malsup.com/jquery/block/#page
>
>
>
> On Sep 6, 10:39 pm, voltron <[EMAIL PROTECTED]> wrote:
>   
>> Hi Jose!
>>
>> I am going to face the same problem with the application I am coding,
>> it is a sort of CMS. I have thought about adding a boolean field
>> called "lock" just as you have used in the past. When a user requests
>> a page to edit and the lock field is not set to true, she can edit the
>> page otherwise the user gets a javascript modal window using Jquery
>> and a plugin stating that the page can be viewed but not edited, the
>> textarea containing the editor is then set to editable = "no". When
>> the user sets the page as "published" and not just saved the page, the
>> lock field is reset and her editor is set also to editable="no"
>>
>> This is theoretical, as I am still having problems with the Javascript
>> library I am using and Xinha( editor) and cant test at the moment.
>>
>> On Sep 6, 10:07 pm, "Jose Galvez" <[EMAIL PROTECTED]> wrote:
>>
>>     
>>> Hi all, I'm hunting for advice.  I am looking for a way to "lock" a webpage
>>> so that only only one person at a time can edit database data.  Here is the
>>> scenario, I have a database with a limited number of users who have write
>>> access to the database, what I'd like to do is lock the editing page so that
>>> if one of my users is editing a page then the other users will not be able
>>> to edit the same page(data) at the same time.  I know that this is what
>>> transactions are for in a database, but what I want to avoid is two people
>>> looking at the same unedited data and then editing it.  I guess what I
>>> really want to is lock a database when I use starts editing the data.  The
>>> issues are:
>>> 1) How to make sure someone exits the edit mode nicely? what happens if they
>>> enter the edit page, do nothing and just close the browser, I don't what to
>>> leave the table locked
>>> 2) if the table is locked I would still like to let users view the data in
>>> real time, jut not edit it.
>>>       
>>> I've used a "lock" table for this in the past, but the issue that I've never
>>> figured out is how to make sure someone still needs the lock.  Again number
>>> (1) from above.
>>>       
>>> I hope that this makes sense, I'll be using sqlalchemy and postgres on the
>>> back end
>>>       
>>> thanks for any and all advice
>>> jose
>>>       
>
>
> >
>
>   

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"pylons-discuss" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/pylons-discuss?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to