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.
Thanks