Problem with SoQL query in PHP

I have a query:

$query_cases = "SELECT CaseNumber FROM Case WHERE ContactId = '.........' AND (IsClosed = False AND (Status!='Closed' AND Status!='Solved'))";

That I can confirm returns no records using sforce explorer. However, when used in PHP always returns a size of either 43 or 49.

$result_cases = $client->query($query_cases);
$num_cases = $result_cases->{"size"};

Printing debug code to the error log:

reset($result_cases);

    while (list($key, $val) = each($result_cases)) {
     error_log("$key => $val");
    }

gives this:

[08-Nov-2006 15:52:28] done => true
[08-Nov-2006 15:52:28] queryLocator =>
[08-Nov-2006 15:52:28] records => Array
[08-Nov-2006 15:52:28] size => 49

Has anyone ever seen this or have a solution??

Thanks

Warren

benjasik
and in both systems you are logged in as the same userid?

warrenlester

Yes.

Warren Lester

Need an account? Sign Up

Have an account? Sign In