I am writing a CF application that queries a Centura SQLBase DB--not my DB of choice, its an interface partner's DB! Some of the fields in the SQLBase DB are of type FLOAT, which for some reason CF is returning in scientific notation (i.e. 1.23653E7) rather than as a whole number. Additionally, CF is losing precision, so I can't even run a function against the result to convert it back to the original number.
Any ideas on how I can make CF not convert the number to scientific notation, or at least preserve the original precision?