Getting currency (i.e. $12.57) to display correctly
Posted on 2000-02-22
I really, really need your help. I have been using cold fusion (learning it). I am a web page developer and have an account that CF would work with. I have tried and tried to get it to report my data in currency format and it just won't show up properly. I'm really frustrated. My manual is "Cold Fusion 4.0" by Ben Forta.
here is an example:
Stock Number Description In Stock Retail Category
16022.0 660 Int. 1999 TF 1st 1/64 5.0 $15.0000 T1
As you can see there are decimals that aren't wanted and 4 zeros after dollar amount. If you can tell me what I am doing wrong, please do so. I should also say that MS Access is my database and the cells are formatted as currency and it looks fine there.