On Tue, 2007-06-05 at 19:21 +0200, Dieter Maurer wrote:
> Roger Doger wrote at 2007-6-4 09:46 -0500:
> >The following use of the API with MySQL works fine
> >
> >> items = [1, 2]
> >> execute('SELECT * from table1 WHERE field1 IN %s', (items,))
> >resultant query string: SELECT * from table1 WHERE field1 IN ('1', '2')
> >
> >By contrast, the following yields the message "error in your SQL syntax"
> >
> >> items = [1]
> >> execute('SELECT * from table1 WHERE field1 IN %s', (items,))
> >resulting query string: SELECT * from table1 WHERE field1 IN ('1',)
>
> A bug in your Python-database bridge. It should handle sequences correctly.
Says who? As Marc-Andre pointed out, parameter binding is only for
scalar values.
--
Carsten Haese
http://informixdb.sourceforge.net
_______________________________________________
DB-SIG maillist - DB-SIG@python.org
http://mail.python.org/mailman/listinfo/db-sig
