I just want to inject my $.05. As for me, binding an array or table is very well aligns with a syntax of WITH clause.
<http://www.sqlite.org/lang_with.html> So example query might look like: WITH array(x) AS ?001 SELECT x FROM array Or WITH my_table(x, y, z) AS ?001 SELECT * FROM my_table Then with a bind interface, we could be allowed to bind individual colunms of this temporary (virtual?) table as an array of all kind of values that we now can bind to single '?'. WITH clause is very neat because of the reason that we are forced define table columns, so the query parser will have some usefull information aboud what is expected in following bind. Paul _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users