This topic is locked
[SOLVED]

 Currency $$$

3/22/2003 11:42:09 PM
ASPRunnerPro General questions
M
mwill9872 author

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?

admin 3/23/2003

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


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 = FORMATCURRENCY and GetData<>""

then GetData = FormatCurrency(GetData,0)
This code explicitly says that no cents will be displayed.
Sergey Kornilov

M
mwill9872 author 3/23/2003

you 'da man! worked perfect! what a great product...... <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=87&image=1&table=forumreplies' class='bbc_emoticon' alt=':lol:' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=87&image=2&table=forumreplies' class='bbc_emoticon' alt=':P' />