Data storage

[djerole]

I have a report where a column is the summation of 2-3.2. In CF 5.0, I get
-1.2. Running the application in CF 7.0, I get -0.200000047684. I patched CF
7.0 with the 133MB update with the same results. I validated the values in the
database to make sure they were stored as 2 and 3.2. Any ideas?

Thanks,

[Dan Bracuk]

What do you get if you run the query outside of cold fusion?

Originally posted by: djerole
I have a report where a column is the summation of 2-3.2. In CF 5.0, I get
-1.2. Running the application in CF 7.0, I get -0.200000047684. I patched CF
7.0 with the 133MB update with the same results. I validated the values in the
database to make sure they were stored as 2 and 3.2. Any ideas?

Thanks,

[djerole]

If I save the report to Excel and use the =sum for these values, I get -1.2.

Thanks

[Dan Bracuk]

But what do you get when you run the query using your database software and
nothing else.?

Originally posted by: djerole
If I save the report to Excel and use the =sum for these values, I get -1.2.

Thanks

[SQLMenace]

Let me guess, they are stored as decimal in the DB table?

[djerole]

They are stored as decimal in Access with Auto or 1 decimal point