I have a id column in a table that is a bigint. When querying this table with this code:
a = '2148124530'; q = new query() .setsql('select * from mytable where id=:id') .addparam(name='id', value=a, sqltype="CF_SQL_BIGINT") .execute().getresult(); dump(q);
The conversion to bigint fails, it sets to 2147483647, the max integer value.
The workaround it’s to convert myself the string to bigint, but I think there has to be a better solution.