Oy, that almost merits being put into a custom tag with as many times as I'm
going to have to call it!
I had come to the conclusion that I could do something similar to this, but
was hoping that there was a way to do it dynamically within the numberformat
function. I guess there isn't.
Thanks!
Hatton
> -----Original Message-----
> From: Larry Juncker [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 1:44 PM
> To: CF-Talk
> Subject: RE: Numberformat question.
>
>
> This isn't pretty, however it does work.
>
> <CFIF Len(ListLast(Item,".")) EQ 1>
> #NumberFormat(Item, "$999,999.9")#
> <CFELSEIF Len(ListLast(Item,".")) EQ 2>
> #NumberFormat(Item, "$999,999.99")#
> <CFELSEIF Len(ListLast(Item,".")) EQ 3>
> #NumberFormat(Item, "$999,999.999")#
> <CFELSEIF Len(ListLast(Item,".")) EQ 4>
> #NumberFormat(Item, "$999,999.9999")#
> </CFIF>
>
>
> Larry Juncker
> Senior Cold Fusion Developer
> Heartland Communications Group, Inc.
>
>
> -----Original Message-----
> From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 10: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