Re: [sqlite] Prepared Statement (select * from x where y in ());

2007-07-18 Thread Scott Hess
- Original Message ----- From: Bharath Booshan L <[EMAIL PROTECTED]> Date: Thursday, July 19, 2007 11:56 am Subject: Re: [sqlite] Prepared Statement (select * from x where y in ()); > > > > > 1)How can we prepare a SQliteStatement for the following type of > select,>

Re: [sqlite] Prepared Statement (select * from x where y in ());

2007-07-18 Thread RaghavendraK 70574
please notify the sender by phone or email immediately and delete it! * - Original Message - From: Bharath Booshan L <[EMAIL PROTECTED]> Date: Thursday, July 19, 2007 11:56 am Subject: Re: [sqlite] Prepared Statement (select * from x where y in ()); > >

Re: [sqlite] Prepared Statement (select * from x where y in ());

2007-07-18 Thread Bharath Booshan L
> 1)How can we prepare a SQliteStatement for the following type of select, > select * from tablename where column in (?); > ?: we don;t know the length of this string. Pass any value less than zero as 3rd parameter to sqlite3_prepare function, in which case, characters up to the first null

[sqlite] Prepared Statement (select * from x where y in ());

2007-07-18 Thread RaghavendraK 70574
HI, 1)How can we prepare a SQliteStatement for the following type of select, select * from tablename where column in (?); ?: we don;t know the length of this string. 2) Can we mix SqliteStatement and sqlite3_exec functions? regads ragha