Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Active Server Pages (ASP)
Expertise: Beginner
Sep 29, 1999

Display Currency Fields in ASP

Question:
I am querying an Oracle field that comes back in the format of 25.5. Because this is a currency field, I'd like to manipulate it so that it shows $25.50 before I publish it out to the Web. How can I do this?

Answer:

Use the FormatCurrency function in VBScript.

strVar = "25.5"
' -- the next line outputs $25.20, the 2 refers to
' -- the number of decimal places
response.write FormatCurrency(strVar, 2)

FormatCurrency returns an expression formatted as a currency value using the currency symbol defined in the system control panel.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap