how about (tableId=? or tableId=? or tableId=? or tableId=?) just convert IN to or.
-------------------------------------------------- From: "Roger Binns" <rog...@rogerbinns.com> Sent: Monday, July 12, 2010 11:00 AM To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Subject: Re: [sqlite] binding an IN > -----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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
