Hi, I think you have the parameters wrong, you probably want the resulting query to be SELECT MAX(price) FROM spending. Then use that value for subsequent queries about the rows with the max price.
Regards On Jul 15, 2:17 am, ilcredo <[email protected]> wrote: > This is the method used in my database adapter : > > ------------------------------------------------------------------ > public Cursor getBiggestInTheColumn() { > return db.query(DATABASE_TABLE, null, > "MAX(price)", null, null, null, null);} > > ------------------------------------------------------------------ > > It should work but when i call the method : > --------------------------------------------------------------------- > cursor = dbadp.getBiggestInTheColumn(); > > -------------------------------------------------------------------- > > I Get a Runtime Error Like This(LogCat) : > > 07-14 12:38:51.852: ERROR/AndroidRuntime(276): Caused by: > android.database.sqlite.SQLiteException: misuse of aggregate function > MAX(): , while compiling: SELECT * FROM spendings WHERE MAX(price) > > Any ideas? I suspect this is due to the bad query, but this is the > best one that i can come up with. Other queries are working well. Also > the table has some data in it. I know i should look documentation but > i'm out of time. > > I've been given an advice to use rawQuery() instead, so i changed the > query to : > ------------------------------------------------------------------- > > db.rawQuery("SELECT MAX(price) FROM spendings", null); > > ------------------------------------------------------------------- > I guess it solved the problem but now it returns me this : > ERROR/AndroidRuntime(335): Caused by: > android.database.CursorIndexOutOfBoundsException: Index -1 requested, > with a size of 1 > > Thank you in advance. -- 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
