SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    May 2006
    Location
    Phnom Penh, Cambodia
    Posts
    19
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Microsoft VBScript runtime error

    I am new to Asp program, when writing code i got a problem below: I dont know how to solve it.


    Microsoft VBScript runtime error '800a000d'

    Type mismatch: 'FormatNumber'

    /down_blogpost.asp, line 114

    my code

    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<&#37;=(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> -

  2. #2
    SitePoint Guru
    Join Date
    Jun 2007
    Posts
    691
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    you need to verify that "rs("RATING").Value" is not null and is in fact a numerical type.

  3. #3
    SitePoint Member
    Join Date
    May 2006
    Location
    Phnom Penh, Cambodia
    Posts
    19
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by webber123456 View Post
    you need to verify that "rs("RATING").Value" is not null and is in fact a numerical type.
    hi, thank let me try with my rating system. and get back to you when i have problem.


Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •