WHERE clause contains mismatched data types in comparison
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?