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 for this year. Given that it is a date, numberformat
converts it to the numeric representation of that date - compare
numberformat("1,1") and numberformat("1/1/2000").
Now why is it NOT a number that can be used in evaluate? Well, numberformat
gives you a text representation of a number, in this case putting in a
comma. CF does not consider a string with a comma in it a number, but
instead thinks it is a list - the same reason Val("4,000") returns "4".
Follow that? :) I'm assuming that numberformat("300") will give you a
'number' that can be used in evaluate.
And stop blaming your co-workers Katrina. ;)
Dan
-----Original Message-----
From: Chapman, Katrina [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. Interesting that it's
not a number however.
--K
> -----Original Message-----
> From: Mark Johnson [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 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]]
> Sent: Thursday, October 05, 2000 5:06 PM
> To: CF-Talk
> Subject: RE: NOT A MATH QUESTION, NumberFormat
>
>
> And the result isn't a number! Try this . . .
>
> <cfset x1 = 0>
> <cfloop from="1" to="20" index="i">
> <cfset x2 = numberformat("#i#,000")>
> <cfoutput>i - #x2# - #evaluate(x2 - x1)#<br></cfoutput>
> <cfset x1 = x2>
> </cfloop>
>
> It bombs on the evaluate(x2 - x1) saying that 36,526 is not a
> number. Hmmm.
> Like the doctor says to the man who complains "it hurts when
> I do this",
> Katrina, don'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 => 1000111100001001 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
> And 2,0 returns 36557
> And 1,0 returns 36526
>
> 36,617 - 36586 = 31
> 36586 - 36557 = 29
> 36557 - 36526 = 31
>
>
> And it does not take "0,0"
>
> So there is no pattern... Interesting bug. Random is not.
>
> <Jaime/>
>
>
>
> > -----Original Message-----
> > From: Russel Madere [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, October 04, 2000 5:21 PM
> > To: CF-Talk
> > 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 number. What I think is
> > happening is that the sting is converted into binary by the
> > function. Then
> > it is formatted.
> >
> > Russel
> >
> > ============================================================
> > Russel Madere, Jr. Senior Web Developer
> > ICQ: 5446158 http://www.TurboSquid.com
> >
> > Some days you eat the bear; some days the bear eats you.
> > ============================================================
> >
> >
> > -----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,
> > --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, NumberFormat
> > >
> > >
> > > 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?
> > > >
> > > >
> > > > ----- 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]]
> > > > > > 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 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 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 Development
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> --------------------------------------------------------------
> > > > > > ------------
> > > > > > ----
> > > > > > > Archives:
> > > http://www.mail-archive.com/[email protected]/
> > > > > > > To Unsubscribe visit
> > > > > >
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
> > > > > s/cf_talk or
> > > > > send a message to [EMAIL PROTECTED] with
> > > 'unsubscribe'
> > > in
> > > > > the body.
> > > > > >
> > > > >
> > > >
> > > >
> > > --------------------------------------------------------------
> > > ------------
> > > > --
> > > > > --
> > > > > Archives:
> http://www.mail-archive.com/[email protected]/
> > > > > To Unsubscribe visit
> > > > >
> > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
> > s/cf_talk
> > or
> > > > send a message to [EMAIL PROTECTED]
> with 'unsubscribe'
> > in
> > > > the body.
> > >
> > >
> >
> --------------------------------------------------------------
> ------------
> > > ----
> > > > Archives: http://www.mail-archive.com/[email protected]/
> > > > To Unsubscribe visit
> > >
> >
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
> s/cf_talk or
> > > send a message to [EMAIL PROTECTED] with
> > 'unsubscribe' in
> > > the body.
> > > >
> > >
> > >
> >
> --------------------------------------------------------------
> ------------
> > ----
> > > Archives: http://www.mail-archive.com/[email protected]/
> > > To Unsubscribe visit
> >
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
> s/cf_talk or
> > send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in
> > the body.
> > >
> >
> > ------------------------------------------------------------------
> > ----------
> > --
> > Archives: http://www.mail-archive.com/[email protected]/
> > To Unsubscribe visit
> >
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
> s/cf_talk or
> > send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in
> > the body.
> > ------------------------------------------------------------------
> > ----------
> > --
> > Archives: http://www.mail-archive.com/[email protected]/
> > To Unsubscribe visit
> >
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> ------------------------------------------------------------------
> ------------
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
