"Sander Jansen" <[email protected]> wrote in message news:[email protected] > Is there a way to use a prepared statement and bind a (variable) array > of integers? > > Like in: > SELECT .... FROM table WHERE someinteger IN ( 2,18,19,340,1,72, 15 > ... )
No. Create a temporary table, populate it with your values (via a prepared INSERT statement), then rewrite your SELECT as a join. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
