On 12 Jul 2010, at 2:42am, Sam Carleton wrote: > Is there any way to bind to this query? > > SELECT * FROM table WHERE tableId IN ( ? ); > > Where ? should be 1,2,3,4
I think the simplest way to do that would be to use GLOB. Not very elegant but it should work. http://www.sqlite.org/lang_expr.html#like If your tableId numbers are always contiguous then you could use BETWEEN: http://www.sqlite.org/lang_expr.html#between Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
