[android-developers] Re: multiple parameters with rawQuery in sqlite = BUG

2010-04-05 Thread FrankD
Sorry i missed out on your question No, i never did get it to work using multiple ? placeholders. What i ended up doing is taking the parameters i was trying to use in the selectionArgs String array and used string concatenation to create one big query string. Then I passed that new string

[android-developers] Re: multiple parameters with rawQuery in sqlite = BUG

2010-03-11 Thread Nathan
On Mar 10, 5:29 pm, Mark Murphy mmur...@commonsware.com wrote: I'm not aware of any. I'm not even sure it's Android that is doing the ? replacement -- the Ruby SQLite library has the same feature, so it might be handled by SQLite itself. It could certainly be in SQlite or its JDBC driver.

[android-developers] Re: multiple parameters with rawQuery in sqlite = BUG

2010-03-10 Thread Nathan
I don't know if you've solved this by now, but I see the same behavior with a completely different query that uses five parameters. The only thing in common, probably, is the use of floating point. I've had okay results using one parameter, or passing a fully populated string both in code and in

Re: [android-developers] Re: multiple parameters with rawQuery in sqlite = BUG

2010-03-10 Thread Mark Murphy
Nathan wrote: I don't know if you've solved this by now, but I see the same behavior with a completely different query that uses five parameters. The only thing in common, probably, is the use of floating point. I've had okay results using one parameter, or passing a fully populated string

[android-developers] Re: multiple parameters with rawQuery in sqlite = BUG

2010-03-10 Thread Nathan
On Mar 10, 3:56 pm, Mark Murphy mmur...@commonsware.com wrote: Create a project that demonstrates the problem, open an issue onhttp://b.android.com, and shoot me the issue number when you've done that. OK. First, though, is there a way to capture what SQL is actually being sent to the

Re: [android-developers] Re: multiple parameters with rawQuery in sqlite = BUG

2010-03-10 Thread Mark Murphy
Nathan wrote: On Mar 10, 3:56 pm, Mark Murphy mmur...@commonsware.com wrote: Create a project that demonstrates the problem, open an issue onhttp://b.android.com, and shoot me the issue number when you've done that. OK. First, though, is there a way to capture what SQL is actually being