function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
AdiviAdivi 

Unable to execute query

hi

    I am using Java 1.4.2_09 and Axis 1.1...  I am getting a MALFORMED_QUERY exception when I run the query

select email from user where short_Name__c in ('C. Morse', 'R. Tom').. The error that I got was

 

AxisFault
 faultCode: {urn:fault.enterprise.soap.sforce.com}MALFORMED_QUERY
 faultSubcode:
 faultString: MALFORMED_QUERY:
select email from User where short_Name__c in ('C. Morse', 'R.
                             ^
ERROR at Row:1:Column:30
unexpected token: short_Name__c
 faultActor:
 faultNode:
 faultDetail:
        {urn:fault.enterprise.soap.sforce.com}fault:
     <sf:exceptionCode>MALFORMED_QUERY</sf:exceptionCode>
     <sf:exceptionMessage>
select email from User where short_Name__c in ('C. Morse', 'R.

 

Can someone help me on this.. Thank you

AdiviAdivi
Dont worry about it... "IN" clause is not supported right now... use the "OR" clause instead like short_Name__c='C. Matthew' or short_Name_c='R. Tom'