Does any one know of any good web hosting vendors that support PHP5 and connecting to Salesforce.com api with the PHP tool kit?

 

Thanks!

 

 

Do

Can any one tell me how to access Contact.Name form my code below, you can see I'm echo out a few different ways but nothing seems to work:

 

$strSQL = "SELECT Id,AssetId,AccountId, Contact.FirstName, ";
$strSQL .= "CaseNumber,Subject,Status,CreatedDate,What_is_your_acronym__c,Which_product__c ";
$strSQL .= "FROM Case ORDER BY Id DESC LIMIT 2 ";
 
   $Result = $mySforceConnection->query($strSQL);
 
 if ($Result->size == 0) {
  NoRecords(0);
 }else{
 
  $records = $Result->records;
  
  foreach ($records as $record) {
  
      $sObject = new SObject($record);
   
   echo $sObject->fields->CaseNumber.":: ";
   echo $sObject->fields->Contact->FirstName."<br>";
   echo $sObject->fields->FirstName;
  }
 }

When I query:

 

SELECT Field,OldValue, NewValue,  CreatedDate, CreatedById....

 

I can get all the field values but not the OldValue and Newvalue.

 

$sObject->fields->Field works perfect and then on the next line i have $sObject->fields->OldValue and I cant get the value, it prints out blank, but I know there is a value. I can see it in my results:

 

stdClass Object ( [done] => 1 [queryLocator] => [records] => Array ( [0] => stdClass Object ( [type] => CaseHistory [Id] => [any] => Array ( [0] => Status [1] => New [2] => Closed [3] => 2007-06-08T14:25:39.000Z00530000000j2ppAAA ) ) [1] => stdClass Object ( [type] => CaseHistory [Id] => [any] => Array ( [0] => Subject [1] => Password Reset [2] => Password Reset 2 [3] => 2007-06-08T14:01:10.000Z00530000000j2ppAAA ) ) [2] => stdClass Object ( [type] => CaseHistory [Id] => [any] => created2007-06-08T12:59:55.000Z00530000000j2ppAAA ) [3] => stdClass Object ( [type] => CaseHistory [Id] => [any] => Array ( [0] => ownerAssignment [1] => Jim Anderson [2] => Response Line Function [3] => 2007-06-08T12:59:55.000Z00530000000j2ppAAA ) ) [4] => stdClass Object ( [type] => CaseHistory [Id] => [any] => Array ( [0] => ownerAssignment [1] => 00530000000j2ppAAA [2] => 00G300000017HLWEA2 [3] => 2007-06-08T12:59:55.000Z00530000000j2ppAAA ) ) ) [size] => 5 )

 

 

Am I missing something????

 

 

I'm trying to query the Solutions Object like you can in the SelfServicePortal to get a ranked result..does anyone know if that is possible through the api?

 

Hi,

 

Is there a was to auto-assign a webToCase Case to contact that exists already?  Can I pass other info like salesforce contactID or something?

 

Thanks

Jim

We are going to be using PHP to access the API and I was wondering how others have gotten around the 5 connection limit to the API.  Are you using some kind of application pooling?

Do

Can any one tell me how to access Contact.Name form my code below, you can see I'm echo out a few different ways but nothing seems to work:

 

$strSQL = "SELECT Id,AssetId,AccountId, Contact.FirstName, ";
$strSQL .= "CaseNumber,Subject,Status,CreatedDate,What_is_your_acronym__c,Which_product__c ";
$strSQL .= "FROM Case ORDER BY Id DESC LIMIT 2 ";
 
   $Result = $mySforceConnection->query($strSQL);
 
 if ($Result->size == 0) {
  NoRecords(0);
 }else{
 
  $records = $Result->records;
  
  foreach ($records as $record) {
  
      $sObject = new SObject($record);
   
   echo $sObject->fields->CaseNumber.":: ";
   echo $sObject->fields->Contact->FirstName."<br>";
   echo $sObject->fields->FirstName;
  }
 }

I'm trying to query the Solutions Object like you can in the SelfServicePortal to get a ranked result..does anyone know if that is possible through the api?

 

We are going to be using PHP to access the API and I was wondering how others have gotten around the 5 connection limit to the API.  Are you using some kind of application pooling?