android sqlite query with multiple where

Question

I am using sqlite in android where i am fetching result by passing multiple where clause, which gives me an error. Single where clause works fine for me problem is with multiple where clause. suggest me the changes or identify the mistake I am doing please

Error message with query

ERROR/AndroidRuntime(837): Caused by: android.database.sqlite.SQLiteException: 
no such column: Maharashtra:,while compiling: SELECT _id, r_shop FROM retailer 
WHERE r_state = Maharashtra AND r_city = Thane AND r_region = Checknaka

String selection = MySQLiteHelper.STATE + " = Maharashtra"  
                +" AND " + MySQLiteHelper.CITY + " = Thane"
                +" AND " + MySQLiteHelper.REGION + " = Checknaka";

        Cursor cursor = database.query(MySQLiteHelper.RETAILER_TABLE, 
                    new String[] {MySQLiteHelper.COLUMN_ID, MySQLiteHelper.SHOP }, selection, 
                    null, null, null, null);

Nermeen · Accepted Answer · 2012-07-13 08:34:02Z

10

String selection = MySQLiteHelper.STATE + " = 'Maharashtra'"  
            +" AND " + MySQLiteHelper.CITY + " = 'Thane'"
            +" AND " + MySQLiteHelper.REGION + " = 'Checknaka'";

    Cursor cursor = database.query(MySQLiteHelper.RETAILER_TABLE, 
                new String[] {MySQLiteHelper.COLUMN_ID, MySQLiteHelper.SHOP }, selection, 
                null, null, null, null);

May be the reason is that, you are refering to Strings without ''

edited Jul 13, 2012 at 8:34

answered Jul 13, 2012 at 7:42

Nermeen

16k5 gold badges62 silver badges73 bronze badges

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

4 Comments

Sumit Over a year ago

_Nunu I have 1 more problem that is The string that i am passing in where clause should also ignore the case sensitivity. what should i do for that

Nermeen Over a year ago

thanks, and check this: myandroidsolutions.blogspot.it/2012/04/…

Sumit Over a year ago

That was useful for raw query what if i am not using raw query

Nermeen Over a year ago

then try: itsgreatupnorth.blogspot.it/2011/10/…

Collectives™ on Stack Overflow

android sqlite query with multiple where

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related