Thanks all for the suggestions. They're a great help.
On 21 July 2014 11:06, Keith Medcalf <kmedc...@dessus.com> wrote: > > > >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 <columns ...> FROM <table> WHERE <column> IN <list-table> > > This assumes that your <list-table> 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 doubles 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
