Get the value from the cursor in Android SQLite

Question

I used the below code to get the "place" value from the "place" column using a cursor. The value of the place in my database is a string,but It returns a number that I have no idea what it is.

here's my code:

meeting.setPlace(cursor.getString(cursor.getColumnIndex("place")));

`cursor.getString` always returns a string, not a number. Sounds like you inserted the data incorrectly into the database — OneCricketeer, Nov 08 '16 at 19:14
@cricket_007 first of all thanks for correcting my mistakes. I think I've inserted them correctly...here it is: contentValues.put("place",R.string.consert7_place); db.insert(TBL_MEETING,null,contentValues); — A. Arash Chitgar, Nov 08 '16 at 19:16

score 0 · Accepted Answer · edited May 23 '17 at 11:48

I think I've inserted them correctly... here it is:
contentValues.put("place",R.string.consert7_place);  
db.insert(TBL_MEETING,null,contentValues); 

R.string.consert7_place is an integer, not a String.

You need to use getResources().getString(R.string.consert7_place)

For more details, see Android: How do I get string from resources using its name?

Your cursor.getString usage is fine.

Get the value from the cursor in Android SQLite

1 Answers1