I would like to +1 the idea about virtual talbe. Using variable number of '?'s
is never the option. You must know that there is limit to how many '?'s can be
there. One day this approach will stab you in the back. The very day when you
will need to bind more elements than limit value. > >Is it possible to have a
variable number of parameters in an IN clause in > >a prepared statement, i.e.
"select * from Table where Col1 in > >(?,?,?,...);"? > > >Or do I need a
constant number of parameters in there to be able to re- > >use the prepared
statement? > > The closest solution would be to create a table/temporary table
and populate it with your value list. You can then use a statement like: > >
SELECT FROM WHERE IN > > This assumes that your has only one column, it is the
correct type. > > If your list is only integers take a look at test_intarray.c
in the full source. It implements a virtual table that maps from a C array to a
virtual table. With minimal changes this would work for doubl
es as well. Since it would be your own custom extension virtual table, you
could make it work with whatever weird data structure and data you required. >
> > > > _______________________________________________ > sqlite-users mailing
list > sqlite-users@sqlite.org >
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
