Contact lookup via Email field

Question

I am using Force.com Toolkit for PHP (Version 20.0) to integrate with Salesforce. I would like to look up some Contact via the email field and print in on page if the condition is met. Here is the query I used: SELECT Name, Email, npe01__HomeEmail__c, npe01__WorkEmail__c, npe01__AlternateEmail__c FROM Contact WHERE Email = "[email protected]" In Workbench everything works fine, however, when I use the same query in PHP I get the following error: 'MALFORMED_QUERY: npe01__AlternateEmail__c FROM Contact WHERE Email="[email protected]" ERROR at Row:1:Column:112 Bind variables only allowed in Apex code' What would be best practice to help me solve this problem? Thanks! Select the correct answer from above options

Answer 1

You can try the following queries: SELECT Name, Email, npe01__HomeEmail__c, npe01__WorkEmail__c, npe01__AlternateEmail__c FROM Contact WHERE Email = '[email protected]' For example: $donor_email = '[email protected]'; $query = 'SELECT Name, Email, npe01__HomeEmail__c, npe01__WorkEmail__c, npe01__AlternateEmail__c FROM Contact WHERE Email=\''.$donor_email.'\'';