Would you update status manualy or automatically?
Richard
On Mon, Sep 27, 2010 at 11:12 AM, mart <msenecal...@gmail.com> wrote:
> Hi
>
> so, I have this table:
>
> db.define_table('p4users',
> SQLField('p4_user'),format='%(p4_user)s')
>
> which gives me a nice dropdown :)
>
>
> then I have this one, where I want to update the Status field.
>
> db.define_table('p4users_all',
> SQLField('Name', db.auth_user, default=auth.user_id),
> # SQLField('User',db.p4users),
> SQLField('User_id',requires=IS_IN_DB(db,db.p4users.id,'%
> (p4_user)s')),
> SQLField('Status',db.p4Status),
> SQLField('License',db.license))
>
>
> in the controller, I have something like this (i know a little messy,
> but I am in a rush ... I have been grasping at this point ;) )
>
> def display_form():
> # record = db.p4users_all(request.args(0))
> row = db.p4users_all[request.args(0)]
> form = SQLFORM(db.p4users_all, row, deletable=True)
> form.vars.id = request.vars.id
> if form.accepts(request.vars, session):
>
> response.flash = 'form accepted'
> elif form.errors:
> response.flash = 'form has errors'
> return dict(form=form)
>
> Any help, would REALLY be appreciated! :)
>
> Thahnnks,
> Mart :)
>
> How do I make so it doesn't create a new record every time I want to
> update a user's status?
>
>
