Microsoft VBScript runtime error '800a000d'

Discussion in 'C#' started by angkorboy, Oct 25, 2010.

0
  1. #1
    Can somebody help? I have error in my Asp Page as below:

    Microsoft VBScript runtime error '800a000d'

    Type mismatch: 'FormatNumber'

    /down_blogpost.asp, line 114

    my code

    

MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/db/Blog.mdb")

rs.Source = "SELECT BlogID, BlogTitle, BlogPosted, (Blog_Rates/Blog_Rates_No) as Rating, BlogLoginID, Blog_Rates, Blog_Rates_No FROM Blog Where BlogLive=0 AND BlogID="&id&""


<b>Rating:</b> <span id="star<%=(rs("BlogID").Value)%>"><img src="starimages/<%=FormatNumber((rs("RATING").Value), 1, -2, -2, -2) %>.gif" weight="57" height="12" style="vertical-align: middle; border: 0;"  alt="<%=(rs("BlogTitle").Value)%> Link has been Rated <%= FormatNumber((rs("RATING").Value), 1, -2, -2, -2) %> stars"></span> <span class="cyel" id="tv<%=(rs("BlogID").Value)%>"><%=FormatNumber((rs("RATING").Value), 1, -2, -2, -2) %></span> -
    Code (markup):
     
    Last edited by a moderator: Oct 25, 2010
    angkorboy, Oct 25, 2010 IP
  2. camjohnson95

    camjohnson95 Active Member

    Messages:
    737
    Likes Received:
    17
    Best Answers:
    0
    Trophy Points:
    60
    #2
    Maybe try changing:
    (rs("RATING").Value)
    to
    Int(rs("RATING").Value)
    or
    Val(rs("RATING").Value)
     
    camjohnson95, Oct 25, 2010 IP