Thanks Dominique, Much appreciated. I can now stop pulling out my hair. I will do something with sprintf.
Best regards, Simon On 11/30/2018 10:37 PM, Dominique Devienne wrote: > On Fri, Nov 30, 2018 at 2:10 PM Simon Walter <si...@gikaku.com> wrote: > >> How does one use WHERE x IN (?) with a prepared statement? What is the >> correct way to do this? >> > > You cannot do it. Must use WHERE x IN (?, ?, ?), i.e. an explicit and > known in advance > number of bind placeholders. Or not use binding at all, and "paste" your > text value before > preparing the statements. --DD > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
