Hi,

I have an odd problem with a SELECT string, trying to get data from Salesforce.

If I use "SELECT Unit_Price__c FROM Equipment_Data__c", it perfectly returns the Unit_Price__c

If I use "SELECT Deal_Type__c  FROM Equipment_Data__c", it perfect returns the Deal_Type__c

But if I use "SELECT Unit_Price__c, Deal_Type__c FROM Equipment_Data__c", it only receives the Deal_Type__c correct, but return a "null" value for Unit_Price__c

Unit_Price__c is a "Number(16,2)" and Deal_Type__c is a Picklist (single).

What is wrong?

Any help really appreciated.

Best regards,

Nicolai 

Hi, 

I'm getting this error - can anyone help me tp understand whay this simple SELEST QUERY doesn't work?

Query in Forice.Com Explorer:

SELECT Id FROM Account WHERE DateDiff(day, CreatedDate, GETDATE()) = 0

It return the follwing error:

MALFORMED_QUERY:
FROM Account WHERE DateDiff(day, CreatedDate, GETDATE()) = 0
^
ERROR at Row:1:Column:41
unexpected token: ','

Best regards,

Nicolai

Hi,

I have an odd problem with a SELECT string, trying to get data from Salesforce.

If I use "SELECT Unit_Price__c FROM Equipment_Data__c", it perfectly returns the Unit_Price__c

If I use "SELECT Deal_Type__c  FROM Equipment_Data__c", it perfect returns the Deal_Type__c

But if I use "SELECT Unit_Price__c, Deal_Type__c FROM Equipment_Data__c", it only receives the Deal_Type__c correct, but return a "null" value for Unit_Price__c

Unit_Price__c is a "Number(16,2)" and Deal_Type__c is a Picklist (single).

What is wrong?

Any help really appreciated.

Best regards,

Nicolai