p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Beginning ASP 3.0 (http://p2p.wrox.com/forumdisplay.php?f=27)
-   -   Chapter 15 - Changing Type of Currency (http://p2p.wrox.com/showthread.php?t=10739)

studentinpain March 19th, 2004 05:46 AM

Chapter 15 - Changing Type of Currency
 
Has any one got any ideas on how you can change the currency symbol from us dollars ($) to uk pounds (£)? I have changed the symbol in the access database however the problem still remains.

Many Thanks,


Imar March 19th, 2004 07:32 AM

Hi there,

How do you display the currency symbol?

Usually, the "locale" determines the currency symbol. You'll need to switch the locale so it uses a £ instead of the $.

Search Google for "Session.LCID" AND currency and you'll get plenty of info.

Personally, I prefer to store currencies as normal numbers, and add a currency column to my table to keep track of the currency. I am not too happy with letting ASP or the database determine the currency symbol.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

fizzbang May 7th, 2005 04:53 PM

:)You do have to set your local settings in Control Panel to English(United Kingdom) but I found that the tables in the database had a '$##:##' mask set on the format of the table. Click in any currency field in design view and change the mask to the word 'currency' from the pick list so that the default currency format £#.00 is used instead.


All times are GMT -4. The time now is 11:19 AM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.