Hi all,
I dunno if anyone has had this problem before, but I have been fighting with
NumberFormat for about an hour now...
I am getting a Cost Price for a product from a database which stores the
price as "Money".
So I am trying to keep things consistant & remove the extra z
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 deci
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 othe
: 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 correctly if
it is ten or more?
I've tried:
0.99 - doesn't w
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 number
>Subject: Setting 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.
>
> HEADERALIGN="LEFT" DATAALIGN=&qu
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.
If you have any questions or concerns, please feel free to call me at
407-658-3111.
Thank you,
> Issac Rosa
>
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 strin
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, Num
mailto:[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.
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 da
hing happens, same numbers.
Please, somebody kill me or I'll keep doing this forever! :-)
> -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
a leap year, except
for december.
What was on the developer's head?
> -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
October 05, 2000 1:22 AM
> 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]]
> S
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
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 365
7;t do this. :)
Dan
-Original Message-
From: Jaime Garza [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 04, 2000 5:28 PM
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
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 thi
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
>
Sent: 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, r
lk
> Subject: RE: 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
October 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-
.
-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
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 o
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
===
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 MA
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, NumberFor
I would imagine that for the sake of internalization 4,000 is the same as
4.000, so my guess is 4.
> -Original Message-
> From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 04, 2000 3:50 PM
> To: CF-Talk
> Subject: NOT A MATH QUESTION, Number
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
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-
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-
> > F
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)
>
>
>
-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
MM,
Here's a question for y'all. It's not math. It's cf.
What will #NumberFormat("4,000")# give you?
Try to answer before you test it.
BB,
--K
---
Thank you,
Katrina Chapman
ColdFusion We
> 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
[EMAIL PROTECTED]
> 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.
> Co
June 26, 2000 1:22 PM
> 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
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" <[EMAIL PRO
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
&g
ot;LM" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 26, 2000 1:21 PM
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
Yes, you can align the numbers so they line up properly. Search the CF Docs for
"numberformat" and you'll get all the formatting and masking possibilities.
---mark
--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax:
Try the RJUSTIFY function. It aligns a string to the right and pads
the rest with spaces.
Example: RJustify("3.99", 10) Looks like:
3.99
On 26 Jun 2000, at 11:21, LM wrote:
> I need help with the NumberFormat function. I need to format 3 dollar
> sign values so tha
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
> 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?
>
>
ColdFusion doesn't recognize null as a value, so it converts it to an empty
string. The NumberFormat function converts the
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?
Chris
--
Chris Lomvardias
[EMA
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?
Chris
--
Chris Lomvardias
[EMAIL PROTECTED]
Syscom, Inc.
400 E. Pratt Street, Suite 300
ith 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 ---
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
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 -
I am having problems with NumberFormat.
The #NumberFormat('.28',
'.99')# is giving
2003764205190119424.00 as result.
Is there any limit on the number para
101 - 150 of 150 matches
Mail list logo