[sqlite] A list as an SQL paramater

Hello everyone, I have a question which I'm hoping someone who knows a bit about SQlite's internals can answer easily. I have a query such as this: SELECT * FROM local INNER JOIN foreign ON local.foreign_id = foreign.id WHERE foreign.id IN (4, 3, 6, 7) ORDER BY local.name; Here the list of

Re: [sqlite] A list as an SQL paramater

Hi Igor, Thanks for your reply. On Wed, Jan 14, 2009 at 4:16 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > Sam Thursfield <sss...@gmail.com> wrote: >> I have a query such as this: >> >> SELECT * FROM local INNER JOIN foreign ON local.foreign_id = >> for

Re: [sqlite] A list as an SQL paramater

On Wed, Jan 14, 2009 at 4:38 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > Sam Thursfield <sss...@gmail.com> wrote: >>>> - binding text results in SELECT * ... WHERE foreign.id IN ("4. 3, >>>> 6, 7") ...; which of course doesn't work. >

Re: [sqlite] A list as an SQL paramater

issues :) Thanks for all the input in this thread I have at least learned a bit about sqlite! PS. if anyone is interested, the (shabby) code I used to find these numbers is here: http://dl.getdropbox.com/u/407072/junk/sqlite-test.c Sam. On Wed, Jan 14, 2009 at 9:26 PM, Sam Thursfield <