Collapse
Submit a Service Request
Contact Information for Technical Support
My Service Notifications
CCOM v1.3 the type of data used in ROQL query must match in the WHERE clause for ID field
Answer ID 10529 |
Last Review Date 12/17/2018
Why could I use WHERE ID='5' in CCOM v1.2 but in v1.3 must use WHERE ID=5 instead?
Environment:
ROQL
Resolution:
In CCOM version 1.2, the type of data used to specify the ID in the WHERE clause was not required to match. In other words, it could be with single quotes (string), or without (int), even though ID is an integer. This works in both 16.8 and 16.11. However, in v1.3, the type of data used must match in the WHERE clause. Therefore ID = '5' would not be allowed because '5' is a string, and ID is an integer.
