select query in sqlite android

Question

String temp_address="nothing";
    try
    {
        String selectQuery = "SELECT lastchapter FROM Bookdetails INTO"+temp_address+"WHERE bookpath=?";
        db.execSQL(selectQuery, new String[] { fileName });
        System.out.println(temp_address+" result of select Query");
    }

    catch(Exception e)
    {
        System.out.println(e+" is the error here");

    }
    finally
    {
        db.close();
    }

Logcat

android.database.sqlite.SQLiteException: near "bookpath": syntax error: , while compiling: SELECT lastchapter FROM Bookdetails INTOnothingWHERE bookpath=?

i just want to take the result of the above query so that the string stored in lastchapter is available in temp_address please help

i am new to android sqlite database please help

now this error android.database.sqlite.SQLiteException: near "INTO": syntax error: , while compiling: SELECT lastchapter FROM Bookdetails INTO nothing WHERE bookpath=? — Mukund
– Mukund, Commented Mar 4, 2014 at 11:06
your query should be: String selectQuery = "SELECT lastchapter FROM Bookdetails INTO "+temp_address+" WHERE bookpath=?"; — Yogendra
– Yogendra, Commented Mar 4, 2014 at 11:27
For any query, this helped me stackoverflow.com/a/5498403/2542175 — Dev Gurung
– Dev Gurung, Commented Mar 25, 2015 at 10:58

laalto · Accepted Answer · 2014-03-04 11:13:21Z

20

There are SQL syntax problems and you'll need to use a Cursor to retrieve query results, for example with rawQuery():

String selectQuery = "SELECT lastchapter FROM Bookdetails WHERE bookpath=?";
Cursor c = db.rawQuery(selectQuery, new String[] { fileName });
if (c.moveToFirst()) {
    temp_address = c.getString(c.getColumnIndex("lastchapter"));
}
c.close();

answered Mar 4, 2014 at 11:13

laalto

153k68 gold badges293 silver badges306 bronze badges

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

Comments

nikis · Accepted Answer · 2014-03-04 11:40:47Z

3

The logcat said it all, you've forgot spaces. To get data into the string:

String temp_address="nothing";
String[] args = new String[] { fileName };
Cursor cursor = sqLiteDatabase.rawQuery("SELECT lastchapter FROM Bookdetails WHERE bookpath=?", args);
if (cursor.moveToFirst()){
    temp_address = cursor.getString(cursor.getColumnIndex("lastchapter"));
}
cursor.close();

edited Mar 4, 2014 at 11:40

answered Mar 4, 2014 at 10:48

nikis

11.3k2 gold badges37 silver badges45 bronze badges

1 Comment

Mukund Over a year ago

thanks for the help, the first error is solved but now android.database.sqlite.SQLiteException: near "INTO": syntax error: , while compiling: SELECT lastchapter FROM Bookdetails INTO nothing WHERE bookpath=? i think there is a syntax error in my select query, i just want to get the value in temp_address

M D · Accepted Answer · 2014-03-04 11:46:03Z

3

Correct your query with below: add space at WHERE Cause

String selectQuery = "SELECT lastchapter FROM Bookdetails WHERE bookpath=? ";

Update: go with rawQuery() becoz it's return Cursor with results

 String selectQuery = "SELECT lastchapter FROM Bookdetails WHERE bookpath=? ";
 Cursor c = db.rawQuery(selectQuery, new String[] { fileName });
 if (c.moveToFirst()) {
 temp_address = c.getString(0);
 }
  c.close();

And for more information go to this: http://www.higherpass.com/android/tutorials/accessing-data-with-android-cursors/

edited Mar 4, 2014 at 11:46

answered Mar 4, 2014 at 10:47

M D

47.9k9 gold badges96 silver badges116 bronze badges

Collectives™ on Stack Overflow

select query in sqlite android

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related