I recently saw someone suggest using a fixed number of '?' for the max number of allowed values and fill the unused positions with 'null'. Sounds plausible, but I don't know what the performance implications would be.
On Sun, Jul 20, 2014 at 5:07 PM, Donald Shepherd <donald.sheph...@gmail.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? > > Thanks for any help, > Donald Shepherd. > _______________________________________________ > 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
