Grrrrrrrrr really?
Thanks for the quick response tho!
I'm already building it from source so I'll investigate!
Cheers,
Jono
On 12/02/2015 11:53 a.m., Peter Aronson wrote:
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
--
------------------------------
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
