Posted on 2000-03-30
I've got a decimal field in an SQL database that I can't get to format the way I want on a CF page.
If the value shows 4.600 in the database, I want it to be "4.6" on the screen..
I thought #NumberFormat(fieldname, "9999.999")# would drop the trailing zeroes, but it leaves them on there. If I wanted the zeroes, I would use #NumberFormat(fieldname, "9999.000")#
I'm thinking it might have something to do with the datatype in the database, which I believe is Decimal(9,3)..I haven't had this problem before.