Re: [sqlite] sqlite3_bind_text() and WHERE x IN (?)

2018-11-30 Thread Simon Walter
On 11/30/2018 11:20 PM, Dominique Devienne wrote: > On Fri, Nov 30, 2018 at 3:03 PM Dominique Devienne > wrote: > >> On Fri, Nov 30, 2018 at 2:44 PM Richard Hipp wrote: >> >>> On 11/30/18, Simon Walter wrote: >>>> Thanks Dominique, >>>> >

Re: [sqlite] sqlite3_bind_text() and WHERE x IN (?)

2018-11-30 Thread Simon Walter
Thanks Dominique, Much appreciated. I can now stop pulling out my hair. I will do something with sprintf. Best regards, Simon On 11/30/2018 10:37 PM, Dominique Devienne wrote: > On Fri, Nov 30, 2018 at 2:10 PM Simon Walter wrote: > >> How does one use WHERE x IN (?) with a prepar

[sqlite] sqlite3_bind_text() and WHERE x IN (?)

2018-11-30 Thread Simon Walter
I am trying to make a prepared statement that has a parameter such as "1, 893, 121212". obviously it is text (a string) but it cannot be quoted or the result will be: SELECT id, data FROM val WHERE id IN ("1, 893, 121212"); I understand normally I would need the quotes, such as: SELECT id, name,