lundi 27 juillet 2015

sqlite rawquery not working correctly

I have two table profile and messages. I want to get profile data and last message related by profileId.

profiles

  • profileId(INTEGER)
  • profileName(TEXT)
  • profileImgPath(TEXT)

messages

  • messageId (INTEGER)
  • profileId (INTEGER)
  • messageContent (INTEGER)
  • messageType (INTEGER)
  • messageStatus(INTEGER)
  • messageTime(TEXT)

data examples

table contents

enter image description here

my query

SQLiteDatabase db = this.getReadableDatabase();


     String selectQuery = "select " +
     "profiles.profileId," +
     "profiles.profileName," +
     "profiles.profileImgPath," +
     "profiles.profileStatus," +
     "messages.messageContent," +
     "messages.messageTime " +
     "from profiles left join messages on profiles.profileId=messages.profileId " +
     "group by profiles.profileId " +
     "order by messages.messageId DESC;";
          Cursor c = db.rawQuery(selectQuery, null);
    Log.i("query",selectQuery);
    if (c.moveToFirst()) {
        do {

            Log.i("gokberksql", c.getString(1) + "x" + c.getString(4));
            } while (c.moveToNext());
    }

results

gokberksql﹕ sinanxKanka naber

But need to return

gokberksql﹕ sinanxIyi senden naber

In addition this query working well in my computer editors but android results not correctly.

Aucun commentaire:

Enregistrer un commentaire