How do I format a "DatabaseResultColumn" as a curre...

[Jalb_k]

I'm making my first foray into ASP creating a webpage for my hobby business
(www.webhedz.com.au). I'm able to get results from my Access database (using
MySQL) but I'm unable to get the 'Item_Price' column to format as currency,
or apply formatting to any of the columns for that matter. Is this a minor
task or do I need to learn more on the database/SQL side?

 

[Kathleen Anderson [MVP - FrontPage]]

http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#currency

 

[Jalb_k]

Thanks for the quick response Kathleen... I had actually already been through
your site after a Google on my question before posting here but, as an
ASP/SQL n00b I have no idea where to put the FORMAT statement. Perhaps I
should have phrased my question differently or tried an SQL Forum.

 

[Kathleen Anderson [MVP - FrontPage]]

You would make this change to your SQL statement. Open the page, switch to
Code View, and find the statement that starts with s-sql="SELECT and copy
and paste here.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx