Search code examples
androidsqliteandroid-contentprovider

Remove multiple rows from contentprovider


I tried to remove two rows from my content provider with no success. Here's the query;

int rowdelted = 
       con.getContentResolver().delete(CONTENT_URI, clausole, null);

where clausole is a string like "_ID = 100 AND _ID = 101 AND _ID = 102".

Is there anything wrong?

Thanks in advance


Solution

  • Each row has 1 ID, and to attempt to remove a single row with id of 100, and 101, and 102, would not work.

    You probably mean to be OR'ing the values.

    String clausole = "_ID = 100 OR _ID = 101 OR _ID = 102";