sql/asp

[aaron lang]

I have a sql database with field name currency set as number. I am building a form in asp. I want to return that value currency as a value. For example in the database the values are 50.99, 40, .17,. I want to format them as 50.99, 40.00, and 0.17. How do I do this??? Do I have to change the database or can I use a function in asp. Do I use To_Num (5,2)? If so where does this go?

[John]

Hi Aaron,

You can format the data in your SQL statement (dbSQL in this case), or with the dbMagicCell property after the data is returned from the data source.

See the docs and/or examples for more details.

Thanks,
John


------------
aaron lang at 9/28/01 8:59:45 PM


I have a sql database with field name currency set as number. I am building a form in asp. I want to return that value currency as a value. For example in the database the values are 50.99, 40, .17,. I want to format them as 50.99, 40.00, and 0.17. How do I do this??? Do I have to change the database or can I use a function in asp. Do I use To_Num (5,2)? If so where does this go?