Long size used by CF for integers
A small correction for those who do not read comments. CF uses 32-bit signed integers , not Long (which has a much larger capacity). Since the error message indicates, the size limit here is the Integer capacity:
- Integer.MAX_VALUE =
2147483647 - Long.MAX_VALUE =
9223372036854775807
It is worth noting that although CF is relatively featureless, some Math and Date functions also have the same limitations. For example, although DateAdd technically supports milliseconds if you try to use a very large number:
// getTime() - returns number of milliseconds since January 1, 1970 currentDate = dateAdd("l", now().getTime(), createDate(1970,1,1));
... it will fail with the same error, because the parameter "number" must be an integer. Therefore, note if the documentation mentions "Integer". It does not just mean "number" or "numerical" ...
source share