1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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