Hello, colisters ^_^
I want to use this query:
SELECT * FROM mailing_mails WHERE list IN (6,7,8)
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)})
The db backend fails executing this wrong query:
SELECT * FROM mailing_mails WHERE list IN (u'6,7,8')
Any ideas on how can i do it using vars= syntax?
Thank you all!
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
