WHERE and IN clauses combined in android SqLite

Asked Aug 03 '16 at 06:45

Active Aug 03 '16 at 08:08

Viewed 34 times

I was trying to retrieve data from sqlite. I want to get data from table 'tbl_expense', I have few conditions:

Date - Date filtering
Expense type(here frequencyID) may fall in multiple categories.

Cursor cursor = db.rawQuery("SELECT * FROM " + TABLE_OFFICE_EXPENSES + "WHERE " + DATE + " > ? AND (" + DATE + " < ? AND " + FREQUENCY_ID + " IN ?)" + " ORDER BY " + DATE + " ASC", new String[]{dateFrom, dateTo, frequencyString});

my frequency String : ('1', '2', '3')

my StackTrace: android.database.sqlite.SQLiteException: near "?": syntax error (Sqlite code 1): , while compiling: SELECT * FROM tbl_expense_office WHERE date_paid > ? AND (date_paid < ? AND frequency_id IN ? ) ORDER BY date_paid ASC, (OS error - 2:No such file or directory)

NB: I have referred this question before asking my question, My bad, I couldn't find anything helpful from that question. How do you relate my question to the linked question? @CL

edited May 23 '17 at 12:08

Community

asked Aug 03 '16 at 06:45

Blue_Alien

2,148
2
25
29

is `date` is column name in your table ? – M D Aug 03 '16 at 06:49
yes, date is a filed.. – Blue_Alien Aug 03 '16 at 06:50
use different Name then – M D Aug 03 '16 at 06:50
why you suggesting that? – Blue_Alien Aug 03 '16 at 06:52
becoz date is preserved word in sqlite – M D Aug 03 '16 at 06:52
ooh, thanks, But still same error pops! – Blue_Alien Aug 03 '16 at 06:56
check the white space is added properly – M D Aug 03 '16 at 06:57
am I using the IN clause correctly? – Blue_Alien Aug 03 '16 at 06:57
try this `SELECT * FROM " + TABLE_OFFICE_EXPENSES + " WHERE " + DATE + " BETWEEN ? AND ? AND " + FREQUENCY_ID + " IN ?" + " ORDER BY " + DATE + " ASC", new String[]{dateFrom, dateTo, frequencyString});` – M D Aug 03 '16 at 07:02
remains same after trying your code, am i using the IN cluase correctly? – Blue_Alien Aug 03 '16 at 07:20
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/118977/discussion-between-m-d-and-bachu). – M D Aug 03 '16 at 07:21

WHERE and IN clauses combined in android SqLite

0 Answers0