?
Solved

Microsoft VBScript runtime error '800a000d'

Posted on 2011-10-23
2
Medium Priority
?
533 Views
Last Modified: 2012-05-12
Hello,

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"%>
<%Else%>
&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
0
Comment
Question by:garethtnash
2 Comments
 
LVL 93

Accepted Solution

by:
Patrick Matthews earned 2000 total points
ID: 37013881
You need to convert your field value to a numeric.  Try:

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

Open in new window

0
 

Author Closing Comment

by:garethtnash
ID: 37013915
Thanks Matt
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to write a Context Sensitive Help (an online help that is obtained from a specific point in state of software to provide help with that state) ,  first we need to make the file that contains all topics, which are given exclusive IDs. …
Originally, this post was published on Monitis Blog, you can check it here . Websites are getting bigger and more complicated by the day. Video, images and custom fonts are all great for showcasing your product or service. But the price to pay in…
In this tutorial viewers will learn how to position overlapping items using z-index in CSS. They will also learn the restrictions on the z-index property.  Create a new HTML document with an internal stylesheet.: Create a div in CSS and name it Red.…
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…
Suggested Courses

807 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