Thanks for the answer. But for your information the "item" is not a float nor a double. It is a reference to an integer defined like this:
"item REFERENCES tbl_items(_id));" where "_id" is the primary key of another table defined as: "_id INTEGER PRIMARY KEY AUTOINCREMENT," So I'll follow your tip and use version 2 in all my queries to prevent problems... On May 27, 2:31 pm, Nathan <[email protected]> wrote: > I have experienced the same thing. > > I'm guessing that item is a float or double, right? > > The SQLiteDatabase class doesn't handle floating point properly in > this call. I've had to resort to version 2 in all my calls. > > Although this doesn't work properly, I'm not sure it would be > considered a bug because of this: > > selectionArgs You may include ?s in selection, which will be replaced > by the values from selectionArgs, in order that they appear in the > selection. The values will be bound as *Strings*. > > Bound as strings probably means that item=46.9876 reverts to > item='46.9876' down in the depths of SQLite. It has a different > meaning and item will be compared as a string, not numerically. > > Unfortunately, I don't know an alternative to using option 2, unless a > new call were added that respected types, such as > > public Cursor query (String table, String[] columns, String selection, > Object[] selectionArgs, String groupBy, String having, String orderBy, > String limit) > > Nathan > > On May 27, 11:04 am, JMichel <[email protected]> wrote: > > > > > I was trying to figure out a problem with an SQLite query and I found > > that it was not working when I was using ? and a list of arguments. > > Could someone tell me why these two version of the code doesn't return > > the same thing: > > > public Cursor getTagCursor(int item) { > > SQLiteDatabase db = getWritableDatabase(); > > String [] col = {"_id", "type", "value", "item"}; > > > //VERSION 1 NOT WORKING > > String [] arg = {String.valueOf(item)}; > > Cursor cursor = db.query ("tbl_tags", col, "item=?", arg, > > null, > > null, "type ASC", null); > > > //VERSION 2 SUCCESSFUL > > String test = "item="+String.valueOf(item); > > Cursor cursor = db.query ("tbl_tags", col, test, null, > > null, null, > > "type ASC", null); > > > return cursor; > > > } > > > Thanks. -- 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
