SQLiteException: no such column: (code 1)

Question

I have the below method that when executed gives the error:

11-09 12:11:17.578: E/AndroidRuntime(21018): Caused by: android.database.sqlite.SQLiteException: no such column: happy (code 1): , while compiling: select * from Bank where english = happy

The method is:

public boolean BankHas(Word currentWord) {
        openDataBase();
        Cursor cursor = myDataBase.rawQuery("select * from Bank where english = " + currentWord.english, null); 
        return cursor.moveToFirst();
    }

My table scheme:

CREATE TABLE `Bank` (
    `english`   TEXT
);

Giru Bhai · Accepted Answer · 2014-11-09 12:27:02Z

8

you missed single quote,so change

"select * from Bank where english = " + currentWord.english

to

"select * from Bank where english ='" + currentWord.english + "'"

Or recommended solution is to use parameterized query as

Cursor cursor = myDataBase.rawQuery("select * from Bank where english =? ", new String [] {currentWord.english});

And change your create table from

CREATE TABLE `Bank` (
    `english`   TEXT
);

to

CREATE TABLE Bank (
    english TEXT
);

edited Nov 9, 2014 at 12:27

answered Nov 9, 2014 at 12:19

Giru Bhai

14.4k5 gold badges50 silver badges74 bronze badges

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

Collectives™ on Stack Overflow

SQLiteException: no such column: (code 1)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related