Alex,
Note, also that with belongs you should ever make sure you pass it a list,
because you will have problem with it if there is only one item .belongs(1)
This is true when your belongs creteria is a subquery for instance and it
not return many items.
So, think to always surround you belongs items with brackets
.belongs([item1, item2, ...])
Richard
On Thu, Jan 22, 2015 at 9:05 AM, Anthony <abasta...@gmail.com> wrote:
> 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 web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
--
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
