I'm trying to achieve pagination in a PHP application where I can query 20 rows at a time per page. The LIMIT keyword in the query is no use because there is no way to specify an offset (as you can with MySQL; LIMIT 0, 20).
I saw a few mentions of queryMore(), though with this, you are limited to a minimum of 200 rows, and you can't jump to a say the 3rd batch of results with this method. You have to iterate through all records, until you've called queryMore() the correct number of times.
$soql = 'SELECT Id, Name FROM Contact';
$sf->setQueryOptions(new QueryOptions(200));
$response = $sf->query($soql);
// 1st page of results
$queryResult = new QueryResult($response);
$response = $sf->queryMore($queryResult->queryLocator);
// 2nd page of results
$queryResult = new QueryResult($response);
$response = $sf->queryMore($queryResult->queryLocator);
// 3rd page of results etc etc...
$queryResult = new QueryResult($response);
Is there anyway to achieve pagination with results with a sensible limit? Of say 20 records?
