Re: [android-developers] Re: Querying the max value of a column in SQLite For Android.

2011-07-15 Thread ilcredo
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 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

Re: [android-developers] Re: Querying the max value of a column in SQLite For Android.

2011-07-15 Thread ilcredo
No, i just execute a query. The result is an cursors which has the index -1.I think is due to a malformed query. Well i guess i should dig more in SQLite to find the answer. Thank you for reply. On Fri, Jul 15, 2011 at 3:26 PM, lbendlin wrote: > why are you asking for index -1? You should ask

[android-developers] Re: Querying the max value of a column in SQLite For Android.

2011-07-15 Thread lbendlin
why are you asking for index -1? You should ask for the first row which has the index of 0. -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this

[android-developers] Re: Querying the max value of a column in SQLite For Android.

2011-07-14 Thread gjs
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 wrote: > This is the method used in my database adapter : > >