Re: [web2py] SELECT .... IN

Hi, you can do: array = [1,3,6] db(db.tablename.fieldname.belongs(array)).select(db.tablename.ALL) On Sun, Aug 7, 2011 at 3:05 PM, guruyaya wrote: > Hi guys. > Is there a way to use a SELECT... IN... syntax in dal? Something like > "SELECT * FROM auth_user WHERE id IN (1,3,6) > If not, I'll expl

[web2py] SELECT .... IN

Hi guys. Is there a way to use a SELECT... IN... syntax in dal? Something like "SELECT * FROM auth_user WHERE id IN (1,3,6) If not, I'll explain my use case, and hope to get your best answer. I have 2 dbs, one holds auth_user, the other holds some data (projects in this case), with the id of the u