[web2py] Re: Can i do this select db(db.table1.id in [1,2,3]).select() ?

[Anthony]

http://web2py.com/books/default/chapter/29/06#belongs

On Tuesday, January 8, 2013 6:44:28 AM UTC-5, Ramos wrote:
> Can i do this  select db(db.table1.id in [1,2,3]).select() ?
> 
> 
> thank you
> António

-- 

[web2py] Re: Can i do this select db(db.table1.id in [1,2,3]).select() ?

[villas]

Try:
db(db.table1.id.belongs([1,2,3])).select() 

You can always print the SQL to your console so you can check it is what 
you expect...
db(db.table1.id.belongs([1,2,3]))._select() 

(Note the underline:  _select)


On Tuesday, January 8, 2013 11:44:28 AM UTC, Ramos wrote:
>
> Can i do this  select db(db.table1.id in [1,2,3]).select() ?
>
> thank you
> António
>

--