[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.

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 where value in