android sqlite: cursor from database query returns empty but shouldn't

Question

I'm trying to filter a listview on buttonclick but my database query returns an empty cursor. I can't find where the problem is. Does someone know why the cursor returns empty?

Here is my code:

private void initSearch() {
    searchText = (EditText) findViewById(R.id.search_edit_text);

    ImageButton searchEntry = (ImageButton) findViewById(R.id.button_search_entry);
    searchEntry.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View view) {
            view.startAnimation(buttonAnimation);
            String catchword = searchText.toString();
            if (catchword.equals("")) {
                Toast.makeText(SearchActivity.this, noCatchword, Toast.LENGTH_LONG).show();
            } else {
                Cursor match = myDb.getWordMatches(catchword); //cursor is empty

                cursorAdapter.swapCursor(match);
                cursorAdapter.notifyDataSetChanged();
            }
        }
    });
}

Here is the database method:

public Cursor getWordMatches(String query) {
    //Cursor c = database.rawQuery("SELECT * FROM "+TABLE_NAME+ " WHERE "+COL_HEAD+ " = '%" +query+"%' OR " +COL_TEXT+ " = '%"+query+"%'", null);
    Cursor c = database.rawQuery("SELECT * FROM " + TABLE_NAME+ " WHERE "+COL_HEAD+ " LIKE ? OR "+COL_TEXT+ " LIKE ?", new String[]{query});
    if(c != null){
        c.moveToFirst();
    }
    return c;
}

I've tried both queries as you can see but both return an empty cursor. The rows are correctly inserted in my database as everything else works fine, so this can not be the reason for my problem.

Thanks in advance!

have you tried manually executing your SQL statement directly into your DB's command interface? — user1506104
– user1506104, Commented Sep 28, 2016 at 9:24
Try this Cursor c = database.rawQuery("SELECT * FROM " + TABLE_NAME+ " WHERE "+COL_HEAD+ " LIKE ? OR "+COL_TEXT+ " LIKE ?", new String[]{query,query}); — Ankita Shah
– Ankita Shah, Commented Sep 28, 2016 at 9:29

Zozinski · Accepted Answer · 2016-09-28 12:33:22Z

1

You might want to try using getText().toString();. As in this line:

String catchword = searchText.getText().toString();

edited Sep 28, 2016 at 12:33

answered Sep 28, 2016 at 12:28

Zozinski

939 bronze badges

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

2 Comments

Kerstin M. Over a year ago

Thank you soo much! That was the problem. Now the cursor is returned with the right content. :)

Zozinski Over a year ago

Glad I could help :D

Collectives™ on Stack Overflow

android sqlite: cursor from database query returns empty but shouldn't

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related