Re: [web2py] Re: How do I "SELECT * FROM table WHERE field IN (1,2,3,4,7)

In PHP you post SQL queries as strings to the DB backend. If you want you can do that like: db.executesql("SELECT * FROM table WHERE field IN (1,2,3,4,7) AND field2='3'") but you loose much of the benefits of using DAL, for instance query portability. mic 2014-04-07 4:20 GMT+02:00 Cliff Kachinsk

[web2py] Re: How do I "SELECT * FROM table WHERE field IN (1,2,3,4,7)

Kurt, I think the key is to realize that the WHERE clause comes first in DAL dialect, and the fields to be selected come after. On Saturday, April 5, 2014 11:49:28 PM UTC-4, Kurt Jensen wrote: > > How do I do : > > "SELECT * FROM table WHERE field IN (1,2,3,4,7) AND field2='3'"" > > AND / OR > >