android.database.sqlite.SQLiteException: no such column:

Question

Trying to get a query but doesn't seem to work.It gives out this error:

android.database.sqlite.SQLiteException: no such column: Gravity (code 1): , while compiling: SELECT club_id FROM Club WHERE club_name like Gravity

This is the code:

private String getClubCode(String clubName){
        open();
        Cursor mCursor = myDb.rawQuery("SELECT " + Table.Club.ID + " FROM " + Table.Club.TABLE_NAME + " WHERE " + Table.Club.NAME + " like " + clubName , null);
        close();

        return mCursor.getString(mCursor.getColumnIndex(Table.Club.ID));
    }

Dhaval Patel · Accepted Answer · 2015-11-15 18:26:35Z

1

Put Extra ' before and after clubName:

Cursor mCursor = myDb.rawQuery("SELECT " + Table.Club.ID + " FROM " + Table.Club.TABLE_NAME + " WHERE " + Table.Club.NAME + " like '"+ clubName + "'" , null);

answered Nov 15, 2015 at 18:26

Dhaval Patel

10.3k5 gold badges45 silver badges46 bronze badges

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

1 Comment

Phantômaxx Over a year ago

Even better, you could use a bound parameter.

Collectives™ on Stack Overflow

android.database.sqlite.SQLiteException: no such column:

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related