I am facing a problem in retrieving a set of strings:
Error Code : 1 (SQLITE_ERROR)
Caused By : SQL(query) error or missing database.
(no such column: recipe_name (code 1): , while compiling:
SELECT Main_ing_name FROM recipe_ingredients where recipe_name='Grilled Vegetables ')
Code :
public ArrayList<String> GetRecipeMain_Ing(String recipe) {
SQLiteDatabase db = this.getReadableDatabase();
Cursor cursorRecipeMain = db.rawQuery("SELECT " + RECIPE_MAIN_ING+ " FROM " + RECIPE_ING_TABLE_NAME + " where " + RECIPE_NAME+"='"+recipe+"'", null);
cursorRecipeMain.moveToFirst();
ArrayList<String> array_list_recipe_Ing = new ArrayList<String>();
while (cursorRecipeMain.isAfterLast() == false) {
array_list_recipe_Ing.add(cursorRecipeMain.getString(cursorRecipeMain.getColumnIndex(RECIPE_MAIN_ING)));
cursorRecipeMain.moveToNext();
}
return array_list_recipe_Ing;
}
Aucun commentaire:
Enregistrer un commentaire