Question about cfQueryParam

dev
1

I have a database that contains 4 byte integer columns and a want to swap some of them to 2 byte or 1 byte integers.

Is it necessary to go through my code and change the data type from INTEGER to SMALLINT or TINYINT on my cfQueryParams?

Thanks PJ

2

I changed a database column to TINYINT (1 byte), and wanted to test what happens when the value passed to cfqueryparam is not in range. So I passed a value of 1000.

With the sqltype set to INTEGER, the database threw an error saying the value was too large.
With the sqltype set to TINYINT, there was no error, but the value that ended up in the database was -24

Wasn’t expecting that!