Android SQlite Cursor query error

Question

String Where = "SELECT FROM peopleTable WHERE _id BETWEEN " + i1+ " AND " + i2;

Where is the mistake? LogCAT:

12-18 16:47:54.497: E/SQLiteLog(2447): (1) near "SELECT": syntax error
12-18 16:47:54.757: E/AndroidRuntime(2447): FATAL EXCEPTION: main
12-18 16:47:54.757: E/AndroidRuntime(2447): android.database.sqlite.SQLiteException: near "SELECT": syntax error (code 1): , while compiling: SELECT _id, persons_name, persons_hotness FROM peopleTable WHERE SELECT FROM peopleTable WHERE _id BETWEEN 2 AND 4

You are using SELECT inside another SELECT thats why it is giving a Syntax error not because of BETWEEN CLAUSE. — VishalKale
– VishalKale, Commented Dec 18, 2013 at 18:48
So How it could be written Please tell me in brief. @VishalKale — mhtamun
– mhtamun, Commented Dec 18, 2013 at 19:11

VishalKale · Accepted Answer · 2013-12-18 19:25:30Z

1

Instead of

SELECT _id,
persons_name,
persons_hotness FROM
peopleTable WHERE SELECT
FROM peopleTable WHERE
_id BETWEEN 2 AND 4

Use this query

 SELECT _id,
persons_name,
persons_hotness FROM
peopleTable WHERE
_id BETWEEN 2 AND 4



 db.query("peopleTable",
 new String[] {_id, person_name,                person_hotness},
"WHERE _id BETWEEN 2 AND 4",        null, null, null, null);

edited Dec 18, 2013 at 19:25

answered Dec 18, 2013 at 18:53

VishalKale

7987 silver badges22 bronze badges

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

1 Comment

mhtamun Over a year ago

So How it could be written Please tell me in Programming Code. @VishalKale

Collectives™ on Stack Overflow

Android SQlite Cursor query error

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related