Solved

FormatCurrency

Posted on 2001-06-29
7
558 Views
Last Modified: 2007-12-19
I am running a site on 2 different servers.  One is Windows 2000 Server and the other is Windows 2000 Advanced Server. I have the currency set to Sterling Pounds # in Control Panel, Regional Options but both show Dollars $ when I use FormatCurrency.

Any ideas guys?

Cheers

Dave
0
Comment
Question by:daveamour
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 9

Expert Comment

by:TTom
ID: 6239370
Hmmm.  I wonder.  Is this being done on the server side or on the client side?  When I did this, I could make the results change, depending upon where the writing was being done.

Tom
0
 
LVL 19

Author Comment

by:daveamour
ID: 6239389
The writing is being done on the server using the VBScript FormatCurrency Function so its not a client side issue.  Besides I have tried this clientside in the UK and in Canada.

Cheers

Dave
0
 
LVL 9

Expert Comment

by:TTom
ID: 6239486
FWIW, I thought that might be the case, but I figured I would toss it out.

Have you tried the parameters of the FormatCurrency Function?  When I did this, I used

response.write FormatCurrency(1000,2,-2,-2,-2)

(I think the last parameter is "use regional settings", but I may be wrong.)

If I set my Regional Currency Symbol to something other than $, it worked just fine.  However, if I used client side script, the same page wrote differently on different machines.

Good luck!

Tom

0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
LVL 7

Expert Comment

by:weesiong
ID: 6240184
daveamour,

Using LCID()

original = SetLocale("de")
myvalue = CCur(GermanNumber.value)
original = SetLocale("en-gb")
USNumber.value = FormatCurrency(myvalue)

Regards,
Wee Siong
0
 
LVL 1

Accepted Solution

by:
rxolotl earned 25 total points
ID: 6244952
I think that you can make something like
fNum = FormatNumber(yourNum, 2)
fNum= "$" + fNum
0
 
LVL 19

Author Comment

by:daveamour
ID: 6250085
This seems to be the best workaround, couldn't get any of the others to work.

Thanks everyone

Dave
0
 
LVL 1

Expert Comment

by:rxolotl
ID: 6250357
Thanks =D
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now