Cold Fusion Page not returning INT datatypes

[happyb]

Hi,

I am having trouble with CFServer 4.5

Everytimme that I run a query that has an int as the datatype in one of the table fields, it returns the int as a different datatype, for instance, if I where to select 1 from my product id table, cold fusion would display it as 1.0

Or even worse, if my product id where 1234 CF would display it as 1,234.00 and NOT process it.

Can someone please help me, I am very dissapointed with the allaire support and I need to get this resolved before I go crazy!

Thanks in advance,

notso happyb

 

[mokaplanjr]

Will it help if your output was formatted like:

#NumberFormat(Fieldname, "9999&quot#

That will set the format to integer with no decimal.