Microsoft VBScript runtime error '800a000d'

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
garethtnashAsked:
Who is Participating?
 
Patrick MatthewsCommented:
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
 
garethtnashAuthor Commented:
Thanks Matt
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.