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? > > http://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#compileStatement(java.lang.String) > http://developer.android.com/reference/android/database/sqlite/SQLiteProgram.html#bindBlob(int, > byte[])
Thanks for your answer. However, AFAIK compiled statements cannot be used for queries (other than those returning only a single value). There is no way to aquire a cursor, or to aquire different fields after having executed the statement. If you think it should work, could you give a code example? _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
