format(a, "#0.00") - can it really be that hard?

[Sonnich]

Yes it can.

All I want is a number formated as:

1234567,89 - plain numbers and a comma as decimal marker.

formatnumber returns the number in american style, which is of no use.
The format command does not exist.

And the help for ASP really sucks, when compared to php.org. Is there
such a place for asp?
That would save me for a lot of time, I spend too much time on simple
things like this when working with ASP.
Odd that a simple question has to end here after 4 hrs of trying.

S

 

[Daniel Crichton]

Sonnich wrote on 2 Aug 2006 04:16:32 -0700:

Yes it can.

All I want is a number formated as:

1234567,89 - plain numbers and a comma as decimal marker.

formatnumber returns the number in american style, which is of no use.

Formatnumber uses the regional setting for the IIS account. The server you
are running this ASP on doesn't have the appropriate regional setting. Try this:

Replace(FormatNumber(a,2),".",",")

This will format is to 2 decimal places, and replace the . with a ,

The format command does not exist.

It's not a VB script command.

And the help for ASP really sucks, when compared to php.org. Is there
such a place for asp?

Many sites have hints and tips, such as www.aspfaq.com . Searching on Google
for asp will bring up plenty of information.

That would save me for a lot of time, I spend too much time on simple
things like this when working with ASP.
Odd that a simple question has to end here after 4 hrs of trying.

Dan

 

[Aaron Bertrand [SQL Server MVP]]

ASP functionality in terms of dates and numbers are dictated by the regional
settings on the server. If you want commas as decimal markers, then change
the regional settings for decimal markers from periods to commas.

Or take the simple approach.

replace(formatnumber(...), ".", ",")

 

[Sonnich]

Sonnich wrote on 2 Aug 2006 04:16:32 -0700:


Formatnumber uses the regional setting for the IIS account. The server you
are running this ASP on doesn't have the appropriate regional setting. Try this:

Replace(FormatNumber(a,2),".",",")

This will format is to 2 decimal places, and replace the . with a ,

The current server will return - 123,456.798 (yanke format). So with a
little change this works:

replace( replace( formatNumber(rs.fields(fieldnumber), 2), ",",""),
".",",")

which will give 123456,80.

But is there a server-setting-independent way of doing this?

S

 

[Aaron Bertrand [SQL Server MVP]]

But is there a server-setting-independent way of doing this?

Yes, create your own function!

 

[MikeR]

And the help for ASP really sucks, when compared to php.org. Is there
such a place for asp?

ASP is NOT a language, but a technology. Here is a link to a pretty good
vbscript reference. I try not to use javascript, so I have no reference to it.
HTH.
Mike

 

[MikeR]

Sorry, I left out the link.
http://www.microsoft.com/technet/scriptcenter/guide/sas_vbs_dcot.mspx?mfr=true

 

[Sonnich]

Yes, create your own function!

I was about to do that, but then I found how complicated it is to get
the local settings etc.

I ended up with something simpler. Enetually I might try to make a
format( function and share it here though.

Sonnich

 

[Bob Barrows [MVP]]

I was about to do that, but then I found how complicated it is to get
the local settings etc.

I ended up with something simpler. Enetually I might try to make a
format( function and share it here though.

There's one at the end of this article:
http://www.aspfaq.com/show.asp?id=2313