SQLite select not working with Where clause

Question

I am trying to get data from my SQLite table, I am running this query:

SQLiteDatabase db = this.getWritableDatabase();
// int memberId = 1234
Cursor rs = db.rawQuery("select username, password from users where memberId = ? limit 1", new String[]{String.valueOf(memberId)});
System.err.println("Rows: " + rs.getCount());

The output is Rows: 0

But when I run this query:

Cursor rs = db.rawQuery("select username, password, memberId from users limit 1", new String[]{});
rs.moveToFirst();
System.err.println(rs.getString(0) + ":" + rs.getString(1) + ":" + rs.getString(2));

I get username:xxxx:1234

How come when I add a where clause this is breaking?

Perhaps your `memberId` that you are using as the query parameter does not exist in the table. — CommonsWare, Jun 23 '14 at 20:32
or your `new String...` business is producing a value which doesn't match what's in the db. — Marc B, Jun 23 '14 at 20:33
@MarcB the value in the database is an int, could that be an issue? — Get Off My Lawn, Jun 23 '14 at 20:39
My memory of cursors may be failing me, but would the fact that you call `rs.moveToFirst()` on the second example be the differing factor? — Brian, Jun 23 '14 at 20:42
I got it, it was because I didn't define a data type for that column — Get Off My Lawn, Jun 23 '14 at 20:43

score 1 · Answer 1 · edited May 23 '17 at 12:29

1

As @Ryan Naddy pointed out - the difference between exposition one and exposition 2 is that you call "moveToFirst()" - you need to do this as the cursor is positioned before the first entry.

See this article.

edited May 23 '17 at 12:29

Community

1
1

answered Jun 23 '14 at 23:17

Dave G

9,639
36
41

SQLite select not working with Where clause

1 Answers1