please do the check I suggested and print log or {{=row}} the value of
row. Is it None?
On Sep 27, 11:23 am, mart <msenecal...@gmail.com> wrote:
> Alright :) it may be "not good looking" right now, but I'll gladly
> post my novice web2py code :) Which parts would be useful?
>
> thanks,
> Mart :)
>
> On Sep 27, 12:10 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > This
>
> > row = db.p4users_all(request.args(0))
> > form = SQLFORM(db.p4users_all, row, deletable=True)
>
> > in your code should not create a new db.p4users_all unless row is
> > None. Check the value of row. If it is none you are passing something
> > wrong for request.args(0). Hard to tell without the rest of the code
> > and/or an example.
>
> > On Sep 27, 10: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?
>
>
