Re: [sqlite] querying with BLOB in WHERE clause, possible?

2011-12-17 Thread Igor Tandetnik
Andreas Schildbach wrote: > On 12/17/2011 04:10 PM, Igor Tandetnik wrote: > >>> Using the Android API, I'd like to do something like SELECT * from >>> my_table WHERE my_blob=? >>> >>> My problem is, all of the query methods only take strings as a parameter >>> for the '?'

[sqlite] Cross Compiling sqlite 3 for Freescale coldfire (m68k)

2011-12-17 Thread Jayashankar K B
Hi, I am trying to cross compile the sqlite 3 for Freescale coldfire controller based on m68k architecture. I have used the CC, --target, --host etc options during configure and the configure script runs successfully. But during the make operation, I get an error related to translation of PC

Re: [sqlite] querying with BLOB in WHERE clause, possible?

2011-12-17 Thread Andreas Schildbach
On 12/17/2011 04:10 PM, Igor Tandetnik wrote: >> Using the Android API, I'd like to do something like SELECT * from >> my_table WHERE my_blob=? >> >> My problem is, all of the query methods only take strings as a parameter >> for the '?' placeholder. How am I supposed to pass in a byte array? >

Re: [sqlite] querying with BLOB in WHERE clause, possible?

2011-12-17 Thread Igor Tandetnik
Andreas Schildbach wrote: > Using the Android API, I'd like to do something like SELECT * from > my_table WHERE my_blob=? > > My problem is, all of the query methods only take strings as a parameter > for the '?' placeholder. How am I supposed to pass in a byte array?

Re: [sqlite] Procedure (Conditional statement) workaround

2011-12-17 Thread Abhishek Bhatnagar
One can essentially do a "if exists" on the column value they want to check, and recurse it many times. As an example, you could go select * from table where exists (select colName from table where colName = 7); If the nested select statement returns one or more rows, then it will return a

[sqlite] querying with BLOB in WHERE clause, possible?

2011-12-17 Thread Andreas Schildbach
Using the Android API, I'd like to do something like SELECT * from my_table WHERE my_blob=? My problem is, all of the query methods only take strings as a parameter for the '?' placeholder. How am I supposed to pass in a byte array? I already checked for a convert/cast function so I could use