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 Kachinske <cjk...@gmail.com>:
> 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
>>
>> "DELETE FROM table WHERE field1 IN (1,2,3,4,7) AND field2='3'"
>>
>> in web2py DAL?
>>
>> I come from PHP and I am really struggling with DAL in web2py.
>
> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
