Thank you, i'll try it. I'll just do a study of SQLite and see. On Fri, Jul 15, 2011 at 7:04 AM, gjs <[email protected]> wrote:
> 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 -- 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

