On Thursday, January 22, 2015 at 1:04:32 AM UTC-5, Alex Glaros wrote:
>
> see anything wrong with "belongs" and IS_IN_DB off the top of your head,
> with this syntax?
>
> db.Role.roleType.requires = IS_IN_DB(db, db.RoleType.id.belongs(2, 3, 5, 7
> , 8, 9, 10, 17, 18, 19), '%(roleType)s',zero=T('choose one'))
>
Your belongs syntax is correct, but the second argument of IS_IN_DB cannot
be a query -- it must be a field (or field name). The first argument,
however, can be a *set* object (not a query):
db.Role.roleType.requires = IS_IN_DB(db(db.RoleType.id.belongs(2, 3, 5, 7,
8, 9, 10, 17, 18, 19)),
db.RoleType.roleType, '%(roleType)s',
zero=T('choose one'))
Anthony
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.