I need to do this type of query, and provide list argument:
SELECT * FROM table WHERE id IN (value1, value2, value3)
result = list(db.select('table', dict(values=sqllist(values)),
where="id in ($values)"))
The only way i managed to do it was using sqllist( values ), and
values should be of string type.
Shouldn't it be supported by default?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
