SQLiteException when querying in Android

Question

I receive this exception "bind or column index out of range" in this line:

Cursor cursor = db.query(TABLE_NAME, null, ID, new String[] { id }, null, null, null);

I want to check if the given id exists in the database, but always the query throw this exception and I don't know what is wrong. I tried with this and the exception it's the same:

Cursor cursor = db.query(TABLE_NAME, null, ID+" = ?", new String[] { id }, null, null, null);

This is the method I've programmed. If there is something wrong here, please, tell me:

public boolean existsAcc(String id)
    {
        //Check the parameters
        if (id == null)
        {
            throw new IllegalArgumentException(
                    "The id parameter cannot be null");
        }
        SQLiteDatabase db = getReadableDatabase();

        Cursor cursor = db.query(TABLE_NAME, null, ID, new String[] { id }, null, null, null);

        if (!cursor.moveToFirst())
        {
            cursor.close();
            return false;
        }

        cursor.close();

        return true;
    }

here id is string or integer ?

Chirag
– Chirag

2011-03-09 11:42:10 +00:00
Commented Mar 9, 2011 at 11:42 — Chirag
– Chirag, Commented Mar 9, 2011 at 11:42

Adrian · Accepted Answer · 2011-04-04 11:15:44Z

2

I don't know why Chirag deleted his answer, but he was rigth. Changing

Cursor cursor = db.query(TABLE_NAME, null, ID, new String[] { id }, null, null, null);

to

Cursor cursor = db.query(TABLE_NAME, null, ID + " = '" + id + "'", null, null, null, null);

does the trick.

edited Apr 4, 2011 at 11:15

answered Mar 9, 2011 at 13:16

Adrian

7192 gold badges11 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

SQLiteException when querying in Android

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related