lundi 2 mai 2016

Quering a SQLite table to return rows with a specific ID

bellow is method that is suppose to take a long ID and return the row that matches the given id but something is wrong with my query and I cannot figure it out. any ideas? (the column containing the id values is called "ID")

public Cursor getAllData (long ID) {
            SQLiteDatabase db = this.getWritableDatabase();
            long thisID = ID ;
            Cursor result = db.rawQuery("select * from WHERE ID = "+thisID + DataTableName,null);
            return result;

        }

Aucun commentaire:

Enregistrer un commentaire