> By now, i'm using
>
> db.select('mailing_mails', where="list IN ("+','.join(i.lists)+")"
>
> where i = web.input(lists=[])
>
> Because if i use something like
>
> db.select('mailing_mails',
> where="list IN ($lists)", vars={'lists': ','.join(i.lists)})
You can do this:
>>> db.select('table', where='id in $ids', vars={'ids': [1, 2]}, _test=True)
<sql: 'SELECT * FROM table WHERE id in (1, 2)'>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web.py" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [email protected]
For more options, visit this group at http://groups.google.com/group/webpy?hl=en
-~----------~----~----~----~------~----~------~--~---
