Unable to get the proper result

Here is my function..

public Cursor fetchAllAlarmGreaterByDate(long appDate, int appTime) {

    return mDb.query(ALARM_TABLE, null, ALARM_DATE + ">" + appDate
            + " and " + ALARM_TIME + ">" + appTime, null, null, null,
            ALARM_DATE + " ASC" + " and " + ALARM_TIME + " ASC");

}

I am unabl开发者_如何学运维e to get result in asc on both column ALARM_DATE AND ALARM_TIME (it gives syntax error).

If I use only ALARM_DATE + " ASC" then it doesn't give any error but the problem is that it also doesn't give any result.

How to make it work properly?

---

Try this

public Cursor fetchAllAlarmGreaterByDate(long appDate, int appTime) {return mDb.query(ALARM_TABLE, null, ALARM_DATE + ">" + appDate  + " and " + ALARM_TIME + ">" + appTime, null, null, null,             ALARM_DATE + " ASC" + " , " + ALARM_TIME + " ASC");  } 

just replace the"AND" in your query with "," for ASC

---

return mDb.query(ALARM_TABLE, null, ALARM_DATE + " > " + appDate
            + " and " + ALARM_TIME + " > " + appTime, null, null, null,
            ALARM_DATE + ", " + ALARM_TIME + " ASC");

}

Try the above. This should solve the syntax error. What are the types of the ALARM_DATE and ALARM_TIME columns in your table?