How do you know which number gets which format? Is there some clue in
another db field, or is it based on how many digits after the decimal point,
or what?
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 1:55 PM
To: CF-Talk
Subject: RE: Numberformat question.
I've been playing with a few different masks, but anytime I set up a decimal
mask it's forcing all the places, so for example, if I have the mask set at
",9$999999.9999", the numbers get formatted (using the examples I cited
originally) $45.9000, $9.9900, $2.8950 and $0.4585.
What I need is $45.90, $9.99, $2.985 and $0.4585.
Hatton
> -----Original Message-----
> From: Tumy, Brad [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 12:27 PM
> To: CF-Talk
> Subject: RE: Numberformat question.
>
>
> can't you output like this:
>
> $#numberformat(number,mask)#
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 11:36 AM
> To: CF-Talk
> Subject: Numberformat question.
>
>
> I have a situation where I need to display a price with either 2, 3 or 4
> digits after the decimal place. The database is storing the information
> properly, but I need to format the display to "trim" the output.
>
> For example, I have three prices for four items:
>
> Item 1 has a price of 45.9
> Item 2 has a price of 9.99
> Item 3 has a price of 2.985
> Item 4 has a price of 0.4585
>
> I need the price to display as $45.90 for Item 1, $9.99 for Item 2, $2.985
> for item 3 and $0.4585 for item 4. I know I can't use DollarFormat, since
> it trims at two decimal places. The question is, how do I set up the
> NumberFormat to show the pricing properly when possible top-ends are up to
> $999,999,999.9999?
>
> TIA
> Hatton
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
