DataBase query with where

Question

I am new to mobile application design , I am trying to design an android , I use a database sqlite , my only problem is the query I have a table and I want to select all the names in this table whose id is 1

I'm tried this, but I know it's totaly false!

String selectQuery = "SELECT" +KEY_ARRET +" FROM " + TABLE_NAME + "where _idligne "  = ' " +1+ '";

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

Thank you for your help ! :)

TechnoBlahble · Accepted Answer · 2015-05-19 23:17:12Z

1

String selectQuery = "SELECT " + KEY_ARRET + " FROM " + TABLE_NAME + " WHERE _idligne = 1";

edited May 19, 2015 at 23:17

answered May 19, 2015 at 22:40

TechnoBlahble

6335 silver badges14 bronze badges

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

1 Comment

djinekitty Over a year ago

thank you very much for your answer, but it still does not work

Carlos Carrizales · Accepted Answer · 2015-05-19 23:07:10Z

0

try this way, less lines but is the same, without the mistake of course:

Cursor cursor = db.rawQuery("SELECT "+ KEY_ARRENT+" FROM "+TABLE_NAME+"WHERE _idligne = 1", null);

in case it dosen't works try this one:

cursor = db.rawQuery("select * from "+TABLE_NAME+" WHERE _idligne = 1", null);
String C1="";
        if (cursor.getCount() != 0) {//recorre todos los datos/campos
            if (cursor.moveToFirst()) {
                do {
                    C1 = cursor.getString(cursor
                            .getColumnIndex(KEY_ARRENT));
                } while (cursor.moveToNext());//pasa al sig dato /campo
            }
        }
        cursor.close();

edited May 19, 2015 at 23:07

answered May 19, 2015 at 23:01

Carlos Carrizales

2,3503 gold badges20 silver badges24 bronze badges

Collectives™ on Stack Overflow

DataBase query with where

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related