Re: using array as execute parameter in dbapi

This is a really neat trick. Thank you very much. -- http://mail.python.org/mailman/listinfo/python-list

using array as execute parameter in dbapi

Is it possible to send an array as a parameter for an execute method in dbapi2 module? I'm using adodbapi and try to perfrom the following SQL query: select * from item where storeid in ('01', '02') When I use direct string formating it works: a=('01','02') cur.execute('select * from