STRING in sqlite database query

Question

When i try to search in row POINTA (text data type in SQLite) and I compare it to a String the program stops. This is the code:

 public Cursor getpoints(String start,String end) throws SQLException {
   Cursor mCursor =  db.query(true, DATABASE_TABLE, new String[] {
                KEY_PRIM, 
                NAME,
                POINTA,
                POINTA_LANG,
                POINTA_LAT,
                POINTB,
                POINTB_LANG,
                POINTB_LAT
                },
                POINTA +"=" +start,//here is the problem 

                null,
                null, 
                null, 
                null, 
                null);
if (mCursor != null) {
    mCursor.moveToFirst();
}
...

Are you certain start is not null?

mah
– mah

2011-05-29 11:44:39 +00:00
Commented May 29, 2011 at 11:44 — mah
– mah, Commented May 29, 2011 at 11:44

Community · Accepted Answer · 2017-05-23 11:45:17Z

1

Same problem as this, you need single quotes around your start String, i.e.

     POINTA + "='" + start + "'",

edited May 23, 2017 at 11:45

CommunityBot

11 silver badge

answered May 29, 2011 at 17:53

dmon

30.2k8 gold badges90 silver badges96 bronze badges

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

Collectives™ on Stack Overflow

STRING in sqlite database query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related