[pysqlite] binding arguments for 'in' operator
Alex Bogma <[email protected]> Sat, 31 Jan 2009 18:23:00 +0200
| Newsgroups | gmane.comp.python.db.pysqlite.user |
|---|---|
| Message-ID | <[email protected]> |
Hello,
Does anybody know how to bind argument for statement like this:
cur.execute('select id, title from table where id in (:args)', {
'args':[1,2,3,4,5] }).fetchall()
I got "Error binding parameter 0 - probably unsupported type."
Passing { 'args': '1,2,3,4,5' } don't work too (no errors,but no data,
it just tries to find a record with id='1,2,3,4,5')
If this is impossible, then tell me please, which function would be
'best practice' for string escaping.