mercredi 30 décembre 2015

How do I combine these two SQLite queries?

How do I combine these two queries into a single query to get the last 10 messages, using the LIMIT keyword?

Cursor cursor0 = db.query(Chat_MESSAGE, messagecolumns, senderid + "=? AND " + receiverid + "=?", new String[] {
            sender_id, receiver_id }, null, null, null, null);

Cursor cursor1 = db.query(Chat_MESSAGE, messagecolumns, senderid + "=? AND " + receiverid + "=?", new String[] {
            receiver_id, sender_id }, null, null, null, null);

Aucun commentaire:

Enregistrer un commentaire