[web2py] SQL help

2011-06-06 Thread DJ
Is this query possible in web2py? SELECT * FROM `shirts` WHERE `color` IN ('red','white','blue') -Sebastian

Re: [web2py] SQL help

2011-06-06 Thread Marin Pranjic
Yes, it is. It should be something like db(db.shirts.color.belongs(['red', 'white', 'blue']).select() On Tue, Jun 7, 2011 at 2:18 AM, DJ sebastianjaya...@gmail.com wrote: Is this query possible in web2py? SELECT * FROM `shirts` WHERE `color` IN ('red','white','blue') -Sebastian

Re: [web2py] SQL help

2011-06-06 Thread DJ
Thank you! This works!