View Single Post
  #2 (permalink)  
Old January 5th, 2007, 04:01 PM
danastasio danastasio is offline
Authorized User
Join Date: Jan 2007
Location: , , .
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts

I'm pretty new to the ASP world, but found that using
<% response.write FormatNumber(rs("Overall_Rating"),2,-1) %>
will output my data from field "Overall_Rating" using connection 'rs' with the original formatting intact. The data is in a decimal (18,2) field in the SQL database.
I get '4.00' now, versus the '4' I was getting when I simply used
<% response.write rs("Overall_Rating") %>.
Hope this helps.