Re: [sqlite] select where value in

2010-11-18 Thread Simon Slavin
On 18 Nov 2010, at 1:22pm, Joseph Garry wrote: >> From: itandet...@mvps.org >> Joseph Garry 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 h

Re: [sqlite] select where value in

2010-11-18 Thread Joseph Garry
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: sqlite-users@sqlite.org > From: itandet...@mvps.org > Date: Thu, 18 Nov 2010 08:08:51 -0500 > Subject: Re: [sqlite] select

Re: [sqlite] select where value in

2010-11-18 Thread Igor Tandetnik
Joseph Garry 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 t

[sqlite] select where value in

2010-11-18 Thread Joseph Garry
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. _