Forums: [SOLVED] Currency $$$ - Forums

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • This topic is locked

[SOLVED] Currency $$$ Help with Currency tag Rate Topic: -----

#1 User is offline   mwill9872 

  • Newbie
  • Pip
  • Group: Members
  • Posts: 9
  • Joined: 23-March 03

Post icon  Posted 23 March 2003 - 04:42 AM

Finally bought ASP runner today.... must say great product and excellent response time from Sergio....

I have connected, uploaded everything seem fine.....

My latest database contains billing numbers...so I would like to display the numbers as currency... when I get to the screen to format I click on the "formatting options" screen I click and nothing happens.... glitch???

Furthermore I would like to have the ability to display the numbers like: $12,500 not $12,500.00 dropping off the .00 is that possible?
0

#2 User is offline   admin 

  • Administrator
  • PipPipPip
  • Group: Admin
  • Posts: 15318
  • Joined: 03-February 03

Posted 23 March 2003 - 05:14 AM

Hi,


on the formatting page you should be able to see options like short date, long date, currencies etc.

Posted Image


By default ASP engine uses server regional settings when displaying currency values with cents or without it. If you like to explicitly display no cents open file /include/aspfunctions.asp and edit lines 56-57.
Here is how it should look like:

if Format = FORMAT_CURRENCY and GetData<>"" _
then GetData = FormatCurrency(GetData,0)

This code explicitly says that no cents will be displayed.

Sergey Kornilov
Best regards,
Sergey Kornilov
0

#3 User is offline   mwill9872 

  • Newbie
  • Pip
  • Group: Members
  • Posts: 9
  • Joined: 23-March 03

Post icon  Posted 23 March 2003 - 07:40 PM

you 'da man! worked perfect! what a great product...... :lol: :P
0

Page 1 of 1
  • You cannot start a new topic
  • This topic is locked