-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 07/11/2010 06:42 PM, 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
There is no C api that allows for binding a list so you'll have to pick an alternative from the answers to your question. Another way of doing it is to put the values in a temporary table and then use ... WHERE tableId in (SELECT * from temptable). Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkw6hUEACgkQmOOfHg372QStyACdFAykKjV2CIcD1EhpbwZhpwZa 0FMAmQG168hlo5DuJT1wNOO51iZu46pn =sf/b -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users