You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

WHERE clause contains mismatched data types in comparison

Accepted answer
6
Views
2
Comments
edited May 19, 2017 3:31PM in Integrations and APIs 2 comments

Content

So this is really bizarre.  When I run the following query in Connect Object Explorer in the Customer Portal, it runs fine.

SELECT A.ID AS OrderHistoryID, A.Job_Number AS OrderHistoryJob_Number, A.Status AS OrderHistoryStatus, A.PCID AS OrderHistoryPCID, A.PSID AS OrderHistoryPSID, A.Type AS OrderHistoryType, A.CreatedTime AS OrderHistoryCreatedTime FROM NS.OrderHistory A WHERE A.PSID = 123456789 and A.type in ('555', '563', '566') and A.status in ('OP','PE')

When running it through SOAP though with QueryCSV i get the following error...

500 - WHERE clause contains mismatched data types in comparison

Anyone have any idea what is going on?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!