Specifying limit / offset for ContentProvider queries

android, android-contentprovider

Solution

I put the LIMIT clause in the sordOrder parameter, I've also seen the same thing done by others but not sure if its 100% correct:

final Cursor c = resolver.query(
        MyTable.CONTENT_URI,
        MyTable.PROJECTION,
        null,
        null,
        " limit 1 offset 2");

Problem

I'm trying to get my ContentResolver to run this query: ``` select * from myTable limit 1 offset 2 ``` The only query method in ContentResolver is: ``` resolver.query(uri, projection, selection, selectionArgs, sortOrder); ``` I've tried: ``` final Cursor c = resolver.query( MyTable.CONTENT_URI, MyTable.PROJECTION, " ? ?", new String[] {"1", "2"}, null); ``` Which just throws an IllegaLArgumentException. What is the correct way of achieving this?

Original source

Related problems