ColdFusion changing INT datatypes to REAL datatypes in select query

[happyb]

Hi,

I am selecting 'product_id' and 'product_name' from a products table in my SQL7 database.

The datatype for 'product_id' is int(4) in the sql database.

Now, when I tell a coldfusion page to do a select query to display the 'product_name' and 'product_id', the product_id seems to change the datatype to a real or double. For example. If my product_id were;

983 or 1392

they would come out as...

983.00 and 1,392.00

Now I can't for the life of me find out why CF is doing this. I can do a select qry on my sql server and get the correct int format, but not when I do this through coldfusion. Has anyone else had this problem? Is it a ColdFusion setting that I may have to change?

Thanks for any help,

happyb