- General Development
- Schema Development
- Apex Code Development
- Visualforce Development
- Formulas & Validation Rules
- Force.com Sites & Site.com
- Chatter Development
- Java Development
- .NET Development
- Perl, PHP, Python & Ruby
- Desktop Integration
- APIs and Integrations
- Visual Workflow
- Apple, Mac and OS X
- VB and Office Development
- AppExchange Directory & Packaging
- Salesforce Labs & Open Source Projects
- Other Salesforce Applications
- Jobs Board
10-25-2012 02:30 PM
Hey Guys, I'm pretty new to Salesforce development, and I'm running into a problem that I just don't understand.
I'm trying to do something really simple: Find out if there's a primary contact associated with an account ID that I specify in the code.
$results = $mySforceConnection->query("SELECT ContactId FROM AccountContactRole WHERE AccountId='001A000000Bi7jyIAB AND IsPrimary=TRUE'");
But no matter what I do, I can't get any data back from this table. Even if I do something like:
$results = $mySforceConnection->query("SELECT ContactId FROM AccountContactRole");
As I understand it, that should pull all contact ID's from AccountContactRole.
I know it's something stupd and small, but what am I missing?