Android sqlite listview cursor problem?

Use this: String getdue = "SELECT _id, max(date) AS date FROM tb1 GROUP BY _id.

Sorry xandy I had pasted the incorrect query into the above code, please check for update. – brux Nov 23 '10 at 4:41 I am guessing that the returned column from the query is not "date", but I don't know what it could be since I never constructed the query myself due to lack of sql knowledge, but I have a book ordered! – brux Nov 23 '10 at 4:47 SQLite doesn't support Datetime data type.

Please refer to this: sqlite. Org/datatype3. Html#datetime – xandy Nov 23 '10 at 5:49 Problem may be coming from (date-21), it depends on your declaration of your field, (date-21) should not be understood by the system (or at least not what you would expected).

– xandy Nov 23 '10 at 5:51.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.