Sign Up ›
  • tlaappdev1
  • NEWBIE
  • 0 Points
  • Member since 2007
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 9
    Replies
1 replies

getPicklist in the future?

is there any planning or future for the php toolkit to include support for picklist searching and updating?

I can't update a picklist field via the update command, unless im doing something wrong and if so can someone post some code snippits on howto accomplish this?
17 replies

PHP toolkit 1.1 queries not returning all COLUMNS from SELECT statement

I figured I would start a new thread since the previous one wasn't really about this issue

http://community.salesforce.com/sforce/board/message?board.id=PerlDevelopment&message.id=2660

The new field Always_Ship_UPS__c shows up in the describeSObject() result. I also successfully updated the field using $sforce->update().

But when I put it in the field list of a SELECT statement, I don't get an error, but it never shows up in my result, whether or not the field has a value in Salesforce. This is the same thing that happened previously when I tried querying a custom formula field.

Any ideas?

Message Edited by benv on 10-15-2007 04:21 PM

I have this problem exactly several feilds just can not be selected. I ahve the most current WSDL they appear as objects with a describeSObject() but no columns are returning. Hell, I even did a

SELECT Id,fieldname from Account where Id='basdfasd'

and it returned this

Code:
object(stdClass)#7 (4) {
  ["done"]=>
  bool(true)
  ["queryLocator"]=>
  NULL
  ["records"]=>
  array(1) {
    [0]=>
    object(stdClass)#12 (1) {
      ["Id"]=>
      string(18) "basdfasd"
    }
  }
  ["size"]=>
  int(1)
}

 


as you see no feildname field is listed here this totally sucks

Message Edited by Tran Man on 10-17-2007 01:11 PM

1 replies

Accessing dependent picklists

I have two custom picklists.  Product_Name__c and Product_Version__c.  I then use the Product Name as the controlling field of Product Version so that I can allocate different versions to different products.
 
Now, I'm trying to write a function in php that will return an array of versions when passed a product name.
 
I'm not getting very far with it.  I've managed to use the describeSObject to actually access the picklists, but I can't find how they are then linked.
 
Does anyone have any advice to offer?
 
Thanks
17 replies

PHP toolkit 1.1 queries not returning all COLUMNS from SELECT statement

I figured I would start a new thread since the previous one wasn't really about this issue

http://community.salesforce.com/sforce/board/message?board.id=PerlDevelopment&message.id=2660

The new field Always_Ship_UPS__c shows up in the describeSObject() result. I also successfully updated the field using $sforce->update().

But when I put it in the field list of a SELECT statement, I don't get an error, but it never shows up in my result, whether or not the field has a value in Salesforce. This is the same thing that happened previously when I tried querying a custom formula field.

Any ideas?

Message Edited by benv on 10-15-2007 04:21 PM

I have this problem exactly several feilds just can not be selected. I ahve the most current WSDL they appear as objects with a describeSObject() but no columns are returning. Hell, I even did a

SELECT Id,fieldname from Account where Id='basdfasd'

and it returned this

Code:
object(stdClass)#7 (4) {
  ["done"]=>
  bool(true)
  ["queryLocator"]=>
  NULL
  ["records"]=>
  array(1) {
    [0]=>
    object(stdClass)#12 (1) {
      ["Id"]=>
      string(18) "basdfasd"
    }
  }
  ["size"]=>
  int(1)
}

 


as you see no feildname field is listed here this totally sucks

Message Edited by Tran Man on 10-17-2007 01:11 PM

9 replies

Custom Formula field in SOQL query, describeSObject, PHP

I can't query a custom formula field in the product2 object. I don't get an error when I put it in the SOQL SELECT statement, but I can't select it. I can select it from the Excel Connector, so it must be possible. Code:
$query_all_products = "select Id, ProductCode, Quantity__c, Warehouse_Location__c, WeightOunces__c, Shipping_Weight_Formula__c from product2";
$result = $sforce->query(array("queryString" => $query_all_products));
$all_products=$result->result->records;
echo '<pre>'.print_r($all_products,true).'</pre>';

Warehouse_Location__c
doesn't show up in the resulting object.And when I try using describeSObject: 
$contact= $sforce->describeSObject("Contact");
print_r($contact);
I get this error: Fatal error: Uncaught SoapFault exception: [sf:INVALID_TYPE] INVALID_TYPE: sObject type cannot be null in (filename):3 Stack trace: #0 [internal function]: SoapClient->__call('describeSObject', Array) #1 (filename)(3): SoapClient->describeSObject('Contact') #2 {main} thrown in (filename) on line 3 Any ideas?
  • October 03, 2007
  • Like
  • 0
1 replies

cant get value to display but in query result

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????