That would work, but the thing I'm after here is speed. And I can't imagine
what you're suggesting would be very fast. Am I mistaken?
> To: [email protected]
> From: [email protected]
> Date: Thu, 18 Nov 2010 08:08:51 -0500
> Subject: Re: [sqlite] select where value in
>
> Joseph Garry <[email protected]> wrote:
> > I'd like to set up a compiled sqllite (sqlite3_prepare_v2) statement with a
> > query like
> > 'select tabid, col1, col2 from table where tabid in (?)'
> > But how do I bind in the parameter here? An example would be welcome, of
> > course.
>
> You can't do that directly. One way is to create a temp table, like this:
>
> create temp table TabIdList (tabid integer);
>
> Now you can prepare this statement:
>
> select tabid, col1, col2 from myTable where tabid in (select tabid from
> TabIdList);
>
> Populate TabIdList with your list of IDs (you can use a prepared statement
> for this, too, along the lines of "insert into TabIdList(tabid) values (?);
> ").
> --
> Igor Tandetnik
>
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
