Gerhard Häring wrote:
>> execute("""SELECT * FROM table WHERE num IN ?;""" ,
>> ((2,3,8,9),))...fail... [...]
>
> You cannot use parameter binding when the number of parameters is
> unknown in advance. So you'll have to create this part of the SQL query
> differently.
>
> For example:
>
>
yota.n...@gmail.com wrote:
> hello,
>
> I couldn't find how the dbapi2 planned to handle the sql IN statement.
>
> ex :
> SELECT * FROM table WHERE num IN (2,3,8,9);
>
> I'd be glad to take advantage of the ? mechanism, but what about
> tuples !
>
> execute("""SELECT * FROM table WHERE num IN ?
hello,
I couldn't find how the dbapi2 planned to handle the sql IN statement.
ex :
SELECT * FROM table WHERE num IN (2,3,8,9);
I'd be glad to take advantage of the ? mechanism, but what about
tuples !
execute("""SELECT * FROM table WHERE num IN ?;""" ,
((2,3,8,9),))...fail...
what would be
