Hi Andrew,

the first argument of IS_IN_DB is really a set, passing db just uses
the whole database, so you can:

mixers=db(db.t_equipment.f_type=="mixer")
...requires=IS_IN_DB(mixers, ...)

This is mentioned in
http://web2py.com/book/default/chapter/07#Database-Validators
although not explicitly (see the second sample code under
IS_NOT_IN_DB).

Denes.

On Jan 24, 2:28 am, Andrew Pettit <[email protected]> wrote:
> Hi there. I'm making an application in which I need to use a SQLFORM.
> however, in a few of the fields I need
> to make use of the requires=IS_IN_DB. The catch is that I only want
> certain fields in the table that I'm searching
>
> eg: db.t_equipment.f_type=="mixer"
>
> I can't find any documentation on customizing an IS_IN_DB.
>
> Thanks in advance
> Andrew Pettit

Reply via email to