form.vars.id
On Aug 14, 7:56 pm, Jonathan Lundell <[email protected]> wrote:
> On Aug 14, 2009, at 4:31 PM, Jonathan Lundell wrote:
>
>
>
>
>
> > I've got a table with two fields, an account name and a user id.
> > They're both required.
>
> > I want something like this:
>
> > naform = SQLFORM(db.acct, fields=['acct_name'],
> > hidden=dict(user_id=auth.user.id))
> > if naform.accepts(request.vars, session):
> > response.flash = 'Account %s created' % request.vars.acct_name
> > elif naform.errors:
> > response.flash = 'Account not created'
>
> > where the user will fill in the account name, and the form will
> > provide the user id. But of course the logic doesn't see a hidden
> > input as a table field, so naform.accepts() fails because user_id is
> > missing.
>
> > OTOH, if I include user_id in fields, then it gets displayed, which is
> > not what I want either.
>
> OK, answering my own question (and asking another below)...
>
> Prepopulating user_id does the right thing. Good. This isn't 100%
> clear from the prepopulation section of the manual, but I gave it a
> shot anyway.
>
>
>
> > (Also, the missing field raises an exception; is that expected?)
>
> This was apparently because I had required=True, but no
> requires=IS_NOT_EMPTY().
>
> Does that mean that an exception handler is needed for required and
> other database/DAL-level validations? If so, the manual could be
> clearer on the subject, and perhaps give some examples.
>
> But my new question is: after a successful SQLFORM.accepts, where do I
> find the id of the newly inserted record?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
