Android SQLITE does not execute queries with arguments

Question

I fail queries with arguments, What am I doing wrong?

I need the following query:

cursor = bd.rawQuery("SELECT * FROM user WHERE user.name=?", new String[]{"%"+nombre+"%"});

I tried the following and they also fail:

cursor = bd.rawQuery("SELECT * FROM user WHERE name=?", new String[]{"%"+nombre+"%"});

cursor = bd.rawQuery("SELECT * FROM user WHERE user.name=?", new String[]{nombre});

This works:

cursor = bd.rawQuery("SELECT * FROM user ", null);

Thanks for your help

Answer 1

Please try this, List out users with name foo.

cursor = bd.rawQuery("SELECT * FROM user WHERE name = ?", new String[] {"foo"});

OR

cursor = bd.rawQuery("SELECT * FROM user WHERE name LIKE ?", new String[] {"foo"});

SQLiteDatabase rawQuery document reference