Fomatting data as currency.

[mrdavid57]

How do I format data as currency using FrontPage 2000 as an editor while developing Active Server Pages(ASP) using an MS SQL database? When I was using an Access Database I used the "FORMAT" command. This does not work with MS SQL 7.0. Please advise.

 

[link9]

If you are wanting to output the value to the screen on your ASP page from a field in your database, then you can use the formatCurrency(number, numOfDigits) vbscript function --

If you're trying to take input from the user (as in from a text box) and then insert it into a 'money' field in SQL Server, then the cdbl(variable) should suffice in making it "insertable" for the database.

Is that what you were asking?


Paul Prewett

 

[mrdavid57]

Thanks!

I am wanting to output the value to the screen on your ASP page from a field in your database, then you can use the formatCurrency(number, numOfDigits) vbscript function.

Would you give me an example of the code? And will it work with FrontPage 2000?

 

[mrdavid57]

Thanks!

I am wanting to output the value to the screen on a ASP page from a field in my database.

Would you give me an example of the code? And will it work with FrontPage 2000?

 

[tlbroadbent]

Here is one solution.

Select '$' + str(CurrCol,8,2) AS CurrencyRslt
From table1

the parameters for the str function are:

1- Column or value to convert
2- Total number of digits to display
3- Number of digits after the decimal Terry

http://members.home.net/tlbroadbent/index.htm

 

[link9]

And if you had a number that came from the database in a variable, say... 'amount', and I wanted to output it with a precision of 2, you would say:

response.write(formatCurrency(amount, 2))

Which, if the value in 'amount' was 17.59, the output would be:

$17.59


Paul Prewett