the leading
spaces.
NumberFormat(cost_price, "___.00")
or
LTrim(NumberFormat(cost_price, "___.00"))
Jim
- Original Message -
From: "Cameron" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, March 20, 2001 9:21 PM
Subject: Fightin
Laszlo Nadai wrote:
I have a cfgrid on a cfquery.
How can I dynamically change let's say the numberformat.
In other words, for certain rows I want 2 after decimals, for other ones
I want 4.
Thanks,
laszlo
~~
Structure your ColdFusion
Sorry for the confusing subject, I want to manipulate both the color and
the format
laszlo
Laszlo Nadai wrote:
I have a cfgrid on a cfquery.
How can I dynamically change let's say the numberformat.
In other words, for certain rows I want 2 after decimals, for other ones
I want 4.
Thanks
Hi guys
Probably a no-brainer, this one, but I can't seem to work it out:
what numberformat mask should I use to output a number so that it a)
has a leading zero if it is less than one and b) formats correctly if
it is ten or more?
I've tried:
0.99 - doesn't work for numbers of 10 or more
PROTECTED]]
Sent: Wednesday, January 03, 2001 11:33 AM
To: CF-Talk
Subject: numberformat()
Hi guys
Probably a no-brainer, this one, but I can't seem to work it out:
what numberformat mask should I use to output a number so that it a)
has a leading zero if it is less than one and b) formats
What is the proper syntax for setting the NumberFormat attribute in
CFGRIDCOLUM? What I have is an integer field that I want to add a comma for
thousands and millions.
CFGRIDCOLUMN NAME="mailpieces" HEADER="Mailpieces"
HEADERALIGN="LEFT" DATAALIGN=&qu
NumberFormat in CFGRIDCOLUMN
What is the proper syntax for setting the NumberFormat attribute in
CFGRIDCOLUM? What I have is an integer field that I want to add a
comma for
thousands and millions.
CFGRIDCOLUMN NAME="mailpieces" HEADER="Mailpieces"
HEADERALIGN="LEFT"
And the result isn't a number! Try this . . .
cfset x1 = 0
cfloop from="1" to="20" index="i"
cfset x2 = numberformat("#i#,000")
cfoutputi - #x2# - #evaluate(x2 - x1)#br/cfoutput
cfset x1 = x2
/cfloop
It bombs on the evaluate(x2
To: CF-Talk
Subject: RE: NOT A MATH QUESTION, NumberFormat
Not so fast
Hex 0x4000 = 16384.
Octal 4000 2048.
36617 in bin = 10001001 which does not look at all like a 4000 in
any numerical system.
With more tests, 4,000, 4,00 4,0 and 4, return the same number.
But 3,0 returns 36586
Maybe like Al Gore Allaire is practicing "Fuzy Number Formatting". =)
Mark
-Original Message-
From: Dan Haley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 05, 2000 5:06 PM
To: CF-Talk
Subject: RE: NOT A MATH QUESTION, NumberFormat
And the result isn't a nu
To: CF-Talk
Subject: RE: NOT A MATH QUESTION, NumberFormat
Maybe like Al Gore Allaire is practicing "Fuzy Number Formatting". =)
Mark
-Original Message-
From: Dan Haley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 05, 2000 5:06 PM
To: CF-Talk
Subject: RE:
="24"
cfset j = i + 1
cfset d1= i",1"
cfset d2= j",1"
cfset nf=NumberFormat("#d1#")
cfset nf2=NumberFormat("#d2#")
cfset diff=ListGetAt(nf2,2) - ListGetAt(nf,2)
#d1#==#nf# nbsp;(#diff#)br
/CFLOOP
/CFOUTPUT
gives
1,1==36,526 (31)
2,1
Please, somebody kill me or I'll keep doing this forever! :-)
Jaime/
-Original Message-
From: Dan Haley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 05, 2000 9:18 AM
To: CF-Talk
Subject: RE: NOT A MATH QUESTION, NumberFormat
Ahhh, I know what it is. :)
Take a look at the differenc
Well, after further playing around, it sort of is. Numberformat is seeing
the string "4,1" as a date. That is why you can't do "4,0", and the reason
the difference between "1,1" and "2,1" is 31, etc. Numberformat is assuming
that the date is
ailto:[EMAIL PROTECTED]]
Sent: Thursday, October 05, 2000 9:59 AM
To: CF-Talk
Subject: RE: NOT A MATH QUESTION, NumberFormat
*I'm* not trying to do this. A fellow developer here at Volt is and *I'm*
trying to help him find a reason why it does this. Interesting that it's
not a number
He actually subscribes to the list so I'm sure when the next digest comes
out he'll get it.
--K
-Original Message-
From: Jaime Garza [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 05, 2000 10:51 AM
To: CF-Talk
Subject: RE: NOT A MATH QUESTION, NumberFormat
The "36,&q
My hat goes off to you guys...
-- Original Message --
From: Dan Haley [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date: Thu, 5 Oct 2000 10:39:18 -0700
Well, after further playing around, it sort of is. Numberformat is seeing
the string "4,1"
MM,
Here's a question for y'all. It's not math. It's cf.
What will cfoutput#NumberFormat("4,000")#/cfoutput give you?
Try to answer before you test it.
BB,
--K
---
Thank you,
Katrina Chapman
ColdFusion Web Developer
System D
-4,000
Just guessing
-Mark :o)
- Original Message -
From: Chapman, Katrina [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, October 04, 2000 3:49 PM
Subject: NOT A MATH QUESTION, NumberFormat
MM,
Here's a question for y'all. It's not math. It's cf.
What
Nope.
-Original Message-
From: Mark Adams [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 04, 2000 3:44 PM
To: CF-Talk
Subject: Re: NOT A MATH QUESTION, NumberFormat
-4,000
Just guessing
-Mark :o)
- Original Message -
From: Chapman, Katrina [EMAIL
can i look now?
- Original Message -
From: Chapman, Katrina [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, October 04, 2000 3:59 PM
Subject: RE: NOT A MATH QUESTION, NumberFormat
Nope.
-Original Message-
From: Mark Adams [mailto:[EMAIL PROTECTED
I'm assuming it is 4? val("4,000") does the same thing.
Dan
-Original Message-
From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 04, 2000 3:59 PM
To: CF-Talk
Subject: RE: NOT A MATH QUESTION, NumberFormat
Nope.
-Original Message-
From:
because there is no mask I would guess it would be blank.
Mark
-Original Message-
From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 04, 2000 11:59 PM
To: CF-Talk
Subject: RE: NOT A MATH QUESTION, NumberFormat
Nope.
-Original Message-
From: Mark
I would imagine that for the sake of internalization 4,000 is the same as
4.000, so my guess is 4.
Jaime/
-Original Message-
From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 04, 2000 3:50 PM
To: CF-Talk
Subject: NOT A MATH QUESTION, NumberFormat
MM
Ok, I can't find reference to the " in NumberFormat what does that do?
- Original Message -
From: Mark Adams [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, October 04, 2000 3:55 PM
Subject: Re: NOT A MATH QUESTION, NumberFormat
can i look now?
- Ori
MM,
The " say's this is a string.
It comes out at, at least on my machine, 36,617. Any ideas why?
BB,
--K
-Original Message-
From: Mark Adams [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 04, 2000 4:32 PM
To: CF-Talk
Subject: Re: NOT A MATH QUESTION, NumberF
Here's my guess.
Since NumberFormat requires a number to be passed and Cold Fusion sees
"4,000" as a string ("4000" would be a number) the result would be a WSOD,
also know as a Cold Fusion error.
Russel
Not yet!
- Original Message -
From: Chapman, Katrina [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, October 04, 2000 5:01 PM
Subject: RE: NOT A MATH QUESTION, NumberFormat
MM,
The " say's this is a string.
It comes out at, at least on my machine, 36,617.
.
-Original Message-
From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 04, 2000 19:01
To: CF-Talk
Subject: RE: NOT A MATH QUESTION, NumberFormat
MM,
The " say's this is a string.
It comes out at, at least on my machine, 36,617. Any ideas why?
BB
ber 04, 2000 5:01 PM
To: CF-Talk
Subject: RE: NOT A MATH QUESTION, NumberFormat
MM,
The " say's this is a string.
It comes out at, at least on my machine, 36,617. Any ideas why?
BB,
--K
-Original Message-
From: Mark Adams [mailto:[EMAIL PROTECTED]]
Sent: Wednesday,
NOT A MATH QUESTION, NumberFormat
It is the comma. I get the same result on my box.
Maybe one of the CF Gurus. hint hint, Dave Watts or Ben
Forta. can
give us an explanation.
When I take out the comma, I get the right number. What I think is
happening is that the sting is
Wednesday, October 04, 2000 19:28
To: CF-Talk
Subject: RE: NOT A MATH QUESTION, NumberFormat
Not so fast
Hex 0x4000 = 16384.
Octal 4000 2048.
36617 in bin = 10001001 which does not look at all like a 4000 in
any numerical system.
With more tests, 4,000, 4,00 4,0 and 4, return the s
Administrator
Softitler Net, Inc.
www.softitler.com
[EMAIL PROTECTED]
- Original Message -
From: "Jaime Garza" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, October 04, 2000 5:28 PM
Subject: RE: NOT A MATH QUESTION, NumberFormat
Not so fast
Hex 0x4000
feature/bug:-)
regards
Andrew Scott
ANZ eCommerce Centre
* Ph 9273 0693
* [EMAIL PROTECTED]
-Original Message-
From: Russel Madere [mailto:[EMAIL PROTECTED]]
Sent: 05 October 2000 11:56
To: CF-Talk
Subject: RE: NOT A MATH QUESTION, NumberFormat
Interesting point.
But I wasn't thinking
I need help with the NumberFormat function. I need to format 3 dollar sign
values so that they are right aligned. The numbers vary in length for ex:
$199.99
$15.99
$5.99
Is there a way to specify the number of digits to display at all times?
Just to throw a spanner
I need help with the NumberFormat function. I need to format 3 dollar sign
values so that they are right aligned. The numbers vary in length for ex:
$199.99
$15.99
$5.99
Is there a way to specify the number of digits to display at all times?
Thanks for your help
Take a look at the RJustify tag. It will do what you want it to. If you
need some code samples please let me know.
Bill
-Original Message-
From: LM [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 26, 2000 1:22 PM
To: [EMAIL PROTECTED]
Subject: Numberformat
I need help
To: [EMAIL PROTECTED]
Subject: Numberformat
I need help with the NumberFormat function. I need to format 3 dollar sign
values so that they are right aligned. The numbers vary in length for ex:
$199.99
$15.99
$5.99
Is there a way to specify the number of digits to display
]
Subject: Re: [RE: Numberformat]
Thanks Mark.
I have tried the following format: #NumberFormat(myprice,'_$.99')#
and still the numbers are not aligned. I tried also replacing the
9s with _
and it didn't do anything.
Could you give me any additional assistance?
Thanks
"Mark Warrick&qu
Anyone know why I would get a value of 0 in an input text
field when I do this against a numeric column which has a
null in the database?
input type="text" name="testval" value="#NumberFormat("#varname#")"
ColdFusion doesn't recognize null as a val
Hi,
Anyone know why I would get a value of 0 in an input text field when I do
this against a numeric column which has a null in the database?
input type="text" name="testval" value="#NumberFormat("#varname#")"
Chris
oldFusion Discussion List
Subject: NumberFormat question
Hi,
Anyone know why I would get a value of 0 in an input text field when I do
this against a numeric column which has a null in the database?
input type="text" name="testval" va
I am having problems with NumberFormat.
The #NumberFormat('.28',
'.99')# is giving
2003764205190119424.00 as result.
Is there any limit on the number parameter.
Thanks
Kumar
replace the nines after the comma with underscores.
i.e:
#NumberFormat('.28','___
_.__')#
Oh any reason you felt the need to submit the question 5 times, or did your
mail server just screw up??
- Original Message -
From: "Manam S
I think mail server is screwed up; I've been receiving multiple copies of
messages as well.
-Original Message-
From: Fred Sanders [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 25, 2000 10:46 AM
To: [EMAIL PROTECTED]
Subject: Re: NumberFormat
replace the nines after the comma
101 - 145 of 145 matches
Mail list logo
