All, I'm just getting into SF/PHP integration, and I'm having an impossible time figuring out how to pull COUNT() values out of queries using the PHPToolKit results ... I don't even see the values if i print_r.

I saw one post online that said this functionality is not supported in toolkit 20.0 -- if true, that sucks! Any thoughts on workarounds or ways to get those counts? I just want to avoid unnecessary queries.

Thanks!

Dustin

Hi Dustin,

I've not seen a PHP Toolkit 20.0. Developerforce wiki only has PHP Toolkit 13.1 at the time of this posting.

Right now, here is the official way to query your objects:
PHP Toolkit 13.0 QueryOptions Sample (Partner) - developer.force.com

In my experience, depending on the object, you can only query around 500 - 2k records per API request.
So if you had a table with 4k records and you wanted to get a count of all records, you would really need between 2-8 API calls depending on your Object. We run 1k records safely.

Here are the help pages:
query - Executes a query against the specified object and returns data that matches the specified criteria. sample
queryMore - Retrieves the next batch of objects from a query. sample
queryOptions - Specifies the batch size for queries. sample

Regards,
Adam
Into Joomla! and SalesForce?
Check us out below at
miiWorks - Joomla Extensions, SalesForce Apps, Business Apps, Web Hosting, Domains