Yes, it seems so. Still, can this be done without knowing how many extensions there are on beforehand? what happens if I make a
SELECT * FROM Files WHERE extension IN (:ext1, :ext2, :ext3, :ext4) and only bind :ext1 but not the others? An error? Is it slow building a statement with sqlite3_prepare16_v2 before executing it? Best regards, Jonas On 3/28/07, Alan Barkway <[EMAIL PROTECTED]> wrote:
On Wed, 28 Mar 2007 08:38:55 +0100, Jonas Sandman <[EMAIL PROTECTED]> wrote: [...] > > SELECT * FROM Files WHERE extension IN (:extension) Just a guess here but might it be the case that you need to do this? SELECT * FROM Files WHERE extension IN (:ext1, :ext2, :ext3) ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
