Re: [sqlite] Building select+in queries from C

Thanks Igor, I'll give this a try. Cheers, Carl On Mon, May 18, 2009 at 2:27 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > "Carl Bretteville" > <cbrettevi...@gmail.com> wrote in message > news:24f328900905180515n3ef4bd72h96777

[sqlite] Building select+in queries from C

Hi, I'm trying to find the best and most efficient way to build a "select" query that uses "in" from C-code where the number of values in the list varies from query to query. The sql statement will look something like this: select * from table1 where name in (name1... nameX) I've found two