[Q] Cannot get a android sqlite select statement to work ! - Android Q&A, Help & Troubleshooting

Hi guys,
I'm trying to select the items that have a expiration date >= that an selected date.
I'm using the format yyyy-mm-dd, and this is my sql statement:
String sql = "SELECT _id, item, value, finalDate FROM "+DATABASE_TABLE+" WHERE date(finalDate) >= date("+selectedDate+")";
This query always result a "full select" in my database, as if there were no conditions.
Some useful information:
selectDate is a String which have a date in yyyy-mm-dd format
I'm executing the query like this:
return db.rawQuery(sql,null);

---

I think it has to do with the quotes
Try:
String sql = "SELECT _id, item, value, finalDate FROM "+DATABASE_TABLE+" WHERE date(finalDate) >= date('" +selectedDate+ "')";
OR
String sql = "SELECT _id, item, value, finalDate FROM "+DATABASE_TABLE+" WHERE date('finalDate') >= date('" +selectedDate+ "')";
I am not 100% sure that will work but my code looks like this ( that works )
public Cursor fetchMedicineEventByDate(String date) {
return mDb.query(DATABASE_MEDICINEEVENT_TABLE,
new String[] { DATABASE_MEDICINEEVENT_ID,
DATABASE_MEDICINEEVENT_AMOUNT,
DATABASE_MEDICINEEVENT_MEDICINETYPEID,
DATABASE_MEDICINEEVENT_TIMESTAMP,
DATABASE_MEDICINEEVENT_USERID }, "date("
+ DATABASE_MEDICINEEVENT_TIMESTAMP + ") " + " = "
+ "date('" + date + "')", null, null, null, null);
}
This give me all items from the given date ( i use the query method but im sure it will work with rawquery to )
If it works please say so and press thanks

---

I was missing the quotes, like you said ! Thanks a lot !
gkenny1991 said:
I think it has to do with the quotes
Try:
String sql = "SELECT _id, item, value, finalDate FROM "+DATABASE_TABLE+" WHERE date(finalDate) >= date('" +selectedDate+ "')";
OR
String sql = "SELECT _id, item, value, finalDate FROM "+DATABASE_TABLE+" WHERE date('finalDate') >= date('" +selectedDate+ "')";
I am not 100% sure that will work but my code looks like this ( that works )
public Cursor fetchMedicineEventByDate(String date) {
return mDb.query(DATABASE_MEDICINEEVENT_TABLE,
new String[] { DATABASE_MEDICINEEVENT_ID,
DATABASE_MEDICINEEVENT_AMOUNT,
DATABASE_MEDICINEEVENT_MEDICINETYPEID,
DATABASE_MEDICINEEVENT_TIMESTAMP,
DATABASE_MEDICINEEVENT_USERID }, "date("
+ DATABASE_MEDICINEEVENT_TIMESTAMP + ") " + " = "
+ "date('" + date + "')", null, null, null, null);
}
This give me all items from the given date ( i use the query method but im sure it will work with rawquery to )
If it works please say so and press thanks
Click to expand...
Click to collapse

---

no problem this can be locked now