Android: select query in android database

Question

I need to get the values of children column corresponding to key column as in the image. What would be the select statement for it in android sqlite.

Thanks

enter image description here

I am using following code for it:

 public Cursor fetchChildren(String KEY_){
            Cursor c = db.rawQuery("SELECT children FROM " + DATABASE_TABLE_NAVIGATION
                    + " WHERE key =" + KEY_+ "", null);
                       return c;

But it is giving me exception:

android.database.sqlite.SQLiteException: no such column: home: , while compiling: SELECT children FROM navigation WHERE key =home

           }

I don't know whether it is so simple or just something else then i understand your question as.Can not you use simple query method of SQLiteDatabase for fetching this column's value? — Hiral Vadodaria
– Hiral Vadodaria, Commented Nov 11, 2011 at 11:34
Yes i am already using that but givin g me following exception: android.database.sqlite.SQLiteException: no such column: home: , while compiling: SELECT children FROM navigation WHERE key =home — ekjyot
– ekjyot, Commented Nov 11, 2011 at 11:38

Graham Borland · Accepted Answer · 2011-11-11 11:56:04Z

6

As Andrey says, you need quotes around the key.

But it's better still to pass the key in separately as an argument to the query, rather than directly including it in the query. This allows SQLite to reuse the same cached query for every different key you might pass in, making it much more efficient.

public Cursor fetchChildren(String KEY_){
    Cursor c = db.rawQuery("SELECT children FROM " + DATABASE_TABLE_NAVIGATION
                           + " WHERE key = ?", new String[] {KEY_});
    return c;
}

answered Nov 11, 2011 at 11:56

Graham Borland

60.8k21 gold badges144 silver badges184 bronze badges

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

Comments

Andrey Atapin · Accepted Answer · 2011-11-11 11:44:24Z

3

I suspect you just missed quotes

SELECT children FROM navigation WHERE key='home'

answered Nov 11, 2011 at 11:44

Andrey Atapin

8,0153 gold badges31 silver badges34 bronze badges

Collectives™ on Stack Overflow

Android: select query in android database

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related