Microsoft VBScript runtime error '800a000d'

Posted on 2011-10-23
Last Modified: 2012-05-12

I'm getting the following error -

Microsoft VBScript runtime error '800a000d'
Type mismatch
/detail.asp, line 101

For the following script -

<%If (RsProductDetail.Fields.Item("Price")) = 0.00 then %>
<%="Free of Charge"%>
&pound;<%=(RsProductDetail.Fields.Item("Price").Value)%> Ex VAT<%End if%>

Open in new window

RsProductDetail.Fields.Item("Price") is type deciml(10,2)

thank you
Question by:garethtnash
    LVL 92

    Accepted Solution

    You need to convert your field value to a numeric.  Try:

    <%If (CDbl(RsProductDetail.Fields.Item("Price"))) = 0.00 then %>

    Open in new window


    Author Closing Comment

    Thanks Matt

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
    If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
    In this tutorial viewers will learn how to position items using CSS's three positioning types Create a new HTML document with an internal stylesheet.: Create another div in CSS and name it Absolute : Type "position:absolute;" and "top:10px; left:50p…
    The viewer will the learn the benefit of plain text editors and code an HTML5 based template for use in further tutorials.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now