You can't do that in standard SQLite -- you can only bind single values. However, if you download the full source package (as opposed to the amalgamation) of SQLite, there are a pair of files under src, test_intarray.c and test_intarray.h, which implement a virtual table that would let you do that, as long as the array you wanted to bind was made up of integers. Although it wouldn't be hard to make a version that worked on floats or strings.
Peter On Wednesday, February 11, 2015 3:46 PM, Jono Poff <jonathan.p...@taitradio.com> wrote: > > >Hi, > >I wonder if anybody could give me a simple example in C to bind an array >of values to a prepared statement? > >The effect I'm looking for is .... > >sqlite3_stmt* stmt = Compile(db, "select * in Things where thing1 in >( <what goes here?> );"); > >sqlite3_bind_???(stmt, 0 , <what goes here? an array?> ); > > >Cheers, >Jono > > > > >-- > >------------------------------ >This email, including any attachments, is only for the intended recipient. >It is subject to copyright, is confidential and may be the subject of legal >or other privilege, none of which is waived or lost by reason of this >transmission. >If you are not an intended recipient, you may not use, disseminate, >distribute or reproduce such email, any attachments, or any part thereof. >If you have received a message in error, please notify the sender >immediately and erase all copies of the message and any attachments. >Unfortunately, we cannot warrant that the email has not been altered or >corrupted during transmission nor can we guarantee that any email or any >attachments are free from computer viruses or other conditions which may >damage or interfere with recipient data, hardware or software. The >recipient relies upon its own procedures and assumes all risk of use and of >opening any attachments. >------------------------------ >_______________________________________________ >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
