ansaurus

Question

SQLServer 2008: Showing the Information with Money DataType in Classic ASP

Answer 1

+1 A:

Personally, I'd consider returning the value as-is unformatted from the database and formatting it for display in the UI instead - leave the formatting up to the front end. After all, the db doesn't know for what use the data it returns is being used for - e.g. something else that runs the query may want the full accuracy returned so would save having multiple different versions.

AdaTheDev 2010-10-22 07:46:11

Thanks for reply. I forgot to mention my webpage is to print and I use view there, from the print bridge form I just send record Id. Then I select from view. So How can I format in HTML? Print form is simple HTML.

RedsDevils 2010-10-22 07:52:30

Presumably, the query is being run from classic ASP which then iterates round the recordset, writing the data out to the client - so in that loop, you'd format the value from that column before writing it out. e.g. something like (bit rusty with classic ASP!):Response.Write(FormatNumber(rs.Fields("Unit_Price"), 2))

AdaTheDev 2010-10-22 08:01:23

Thanks you alot!

RedsDevils 2010-10-22 08:29:09

ansaurus

tags:

views:

answers:

SQLServer 2008: Showing the Information with Money DataType in Classic ASP

related questions