Andreas Schildbach <[email protected]> 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 '?' 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).
Yes you are right. There's another class, SQLiteQuery, that is used internally by Cursor as a wrapper around a SQLite handle, and that has bindBlob method. But there doesn't seem to be any convenient way to get to it. There may be one backdoor though. You should be able to write a class that implements SQLiteDatabase.CursorFactory interface, and pass it to SQLiteDatabase.queryWithFactory or rawQueryWithFactory. The method will turn around and call newCursor on your factory, passing SQLiteQuery as a parameter. You should be able to set the query's parameters, then just create and return a new instance of SQLiteCursor (its constructor is public). -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
