Skip Navigation
Expand
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.

Available Languages for this Answer:

Notify Me
The page will refresh upon submission. Any pending input will be lost.