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 to rawQuery with null as the selectionArgs. For ex... String sql = "SELECT SUM(MIN(fp - " + firstParameter + ", ap)) FROM....."; rawQuery(sql, null); Don't know if this was a good way of doing it but it was the only way i could get it to work and i have experienced no problems with this method. Frank On Mar 11, 4:13 pm, Nathan <[email protected]> wrote: > On Mar 10, 5:29 pm, Mark Murphy <[email protected]> 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. .NET SQLite > provider worked with the exact same query string - but it had typed > parameters, not an array of strings. > > Given the nature of SQLite, I wouldn't be surprised if it is casting > the column to a string and doing a string comparison. > > If this is the case, to be fixed, I'd have to request a new signature > for rawQuery. > > rawQuery (String sql, Object... params) > > If I come up with a smaller case, I'll post it. It is 100% > reproducible with FLOAT columns and inequality in my code. > > Nathan -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en To unsubscribe, reply using "remove me" as the subject.
