Coldfusion Rounding Issue
I had a very strange problem recently with my production server rounding numbers for only one of my sites. For example, it was displaying $35.67 as $36.00. The problem, I think, was that I was inserting sums into a table, using cf_sql_numeric. This is the first time I've encountered the need to use a table to store sums, so I haven't run into this problem before. Luckily, after much thought, I checked the list of available cf_sql datatypes and found this one: cf_sql_money. I made the change in my code and the problem disappeared.

Archives