No good.
It hides the field correctly but again after:
form.vars.uid = 2 # set the uid explicitly
the call
db.client.insert(**dict(form.vars))
complains that 'uid' is an invalid field name
It appears that SQLFORM is just not prepared to accept a field that
it didn't display.
Karl
On Jan 15, 9:18 am, mdipierro <[email protected]> wrote:
> You can change
>
> db.client.uid.readbale=True or False
>
> where you need it, for example in the action before form=.
>
> Massimo
>
> On Jan 15, 11:08 am, kbochert <[email protected]> wrote:
>
> > Is it possible to use SQLFORM to generate forms which show different
> > fields?
>
> > I.E. I have a model:
>
> > db.define_table('client',
> > Field('uid', auth_user),
> > Field('name', 'string'),
> > migrate = 'client.table'
> > )
>
> > I want a page which the client uses that hides the 'uid' field, which
> > gets filled in automatically by the controller.
> > A different page accessible to the superuser shows the field normally.
>
> > I tried:
> > db.define_table('client',
> > Field('uid', 'string', readable=False, writable=False),
> > Field('name', 'string'),
> > migrate = 'client.table'
> > )
>
> > with
> > form = SQLFORM(db.client, _id='profile_table')
> > if form.accepts(request.vars, session, dbio=False):
> > form.vars.uid = 2
> > form.vars.id = db.client.insert(**dict(form.vars))
>
> > and get the error
> > SyntaxError: invalid field names: ['uid']
>
> > The other approach I tried was to remove the 'readable' and 'writable'
> > from the model (But won't those prevent the superuser's page from
> > showing the 'uid' field??) and using the 'fields' parameter in the
> > SQLFORM call to explicitly set the fields I wanted to see. Same
> > result- the accepts() method rejects the added 'uid' var.
>
> > Finally I tried using the 'onvalidation' parameter. Same result.
>
> > Is there a way to do this??
> > Karl
--
You received this message because you are subscribed to the Google Groups
"web2py-users" 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/web2py?hl=en.
