Android SQL query with two "Where" clauses

Question

Hello i have an SQL query and i want it to have two WHERE clause. I want it to query both Bid and Cid in my db and return it to a cursor there is my code

     public Cursor getSubCategoriesQuerybyCidandBid(String Cid, int Bid) {
        this.openDataBase();
        Cursor c;
         String[] asColumnsToReturn = new String[] {SECOND_COLUMN_ID, SECOND_COLUMN_IDENTITY, SECOND_COLUMN_SUBCATEGORIES};
         c =dbSqlite.query(false, TABLE_NAME, asColumnsToReturn, COLUMN_BID + "=" + Bid + COLUMN_CID + "=" + Cid , null, null, null, null, null);
         return c;
    }

This is how i want it to be but this is not working any ideas how to fix this?

Hauleth · Accepted Answer · 2012-04-29 15:39:40Z

7

Try COLUMN_BID + "=" + Bid + " AND " + COLUMN_CID + "=" + Cid.

answered Apr 29, 2012 at 15:39

Hauleth

23.7k4 gold badges67 silver badges117 bronze badges

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

Collectives™ on Stack Overflow

Android SQL query with two "Where" clauses

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