SQLite Query not returning any records

Question

I'm executing an SQLite query:

String selectQuery = "SELECT hotel.cityName, hotel.hotelName, hotel.roomName, hotel.roomCode, hotel.roomType, hotel.maxPax FROM hotel WHERE ( hotel.cityName = 'Adelaide' OR hotel.cityName = 'Brisbane' OR hotel.cityName = 'Canberra' ) AND hotel.maxPax < 200 AND hotel.maxPax >= 100 AND ( hotel.roomType = 'Boardroom' )"

against a database table called "hotel" created from XML, with the following headings (according to DDMS):

id (INT)
cityName (TEXT)
hotelName (TEXT)
roomCode (TEXT)
roomName (TEXT)
roomType (TEXT)
maxPax (INT)

Each time I run the query:

    SQLiteDatabase db = this.getWritableDatabase ( );
    Cursor cursor = db.rawQuery ( selectQuery, null );

cursor.getCount() returns 0.

I have checked the actual data, and this query should definitely return data. Why does cursor.getCount() return 0?

kenny_k · Accepted Answer · 2016-03-15 09:34:52Z

1

Your Java code looks fine, I am guessing the problem is with your SQL. When I have such problems, I often re-create the DB contents in Firefox's SQLite Manager or SQLite Browser and then take the query and start removing things from the WHERE clase until I get results.

edited Mar 15, 2016 at 9:34

answered Apr 23, 2013 at 23:37

kenny_k

4,0005 gold badges34 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user2313303 Over a year ago

Thx for the help. Managed to get it working using Firefox's SQLite Manager (excellent resource!). It was a stupid typo on my part :(

viniciuskneves · Accepted Answer · 2013-04-23 23:34:57Z

0

Try to use the 'query' method (Android Developers)

db.query("hotel", null, "(cityName = ? OR cityName = ? OR cityName = ?) AND maxPax < 200 AND maxPax >= 100 AND roomType = ?", new String[] {"Adelaide", "Brisbane", "Canberra", "Boardroom"}, null, null, null);

If it doesn't work, extract the database and test the query.

answered Apr 23, 2013 at 23:34

viniciuskneves

801 silver badge8 bronze badges

Comments

StoneBird · Accepted Answer · 2013-04-23 23:48:50Z

0

Try assign your database variable to a SQLiteOpenHelper. I don't really know if a rather arbitrary this would have getWritableDatabase() method.

SQLiteOpenHelper helper = new SQLiteOpenHelper()
SQLiteDatabase db = helper.getWritableDatabase();

edited Apr 23, 2013 at 23:48

answered Apr 23, 2013 at 23:37

StoneBird

1,94013 silver badges12 bronze badges

2 Comments

user2313303 Over a year ago

Sorry, forgot to put the quotes around the String :( the actual selectQuery does have quotes around it, I'll amend the question.

StoneBird Over a year ago

@user2313303 changed my answer.

Collectives™ on Stack Overflow

SQLite Query not returning any records

3 Answers 3

1 Comment

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related