• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 552
  • Last Modified:

Microsoft VBScript runtime error '800a000d'

Appreciate some help with this if possible -

I'm getting the following error -

Microsoft VBScript runtime error '800a000d'
Type mismatch
/order-detail.asp, line 176

Where line 176 is

<%If (RsOrderSummary.Fields.Item("OrderDeliveryCharge")) > 0.00 then %>

OrderDeliveryCharge on the table is -

[OrderDeliveryCharge] [decimal](10, 2) NOT NULL,

Thank you
0
garethtnash
Asked:
garethtnash
1 Solution
 
BardobraveCommented:
Probably your database stored value is not compatible with "0.00", try this:

<%If cFloat(RsOrderSummary.Fields.Item("OrderDeliveryCharge")) > 0.00 then %>
0
 
garethtnashAuthor Commented:
Umm that now gives me -

"Microsoft VBScript runtime error '800a000d'
Type mismatch: 'cFloat'
/order-detail.asp, line 176"

Thanks
0
 
pateljituCommented:
Please try cdbl:

<%If cdbl(RsOrderSummary.Fields.Item("OrderDeliveryCharge")) > 0.00 then %>

Article:
http://www.w3schools.com/vbscript/vbscript_ref_functions.asp
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Jesus RodriguezIT ManagerCommented:
<% If (RsOrderSummary.Fields.Item("OrderDeliveryCharge")) > 0.00 then %>

THEN do what?? Which will be the value that will be posted
for example

<%
Dim myNum
myNum = 23
If myNum = 6 Then
      Response.Write("Variable myNum = 6")
Else
      Response.Write("**Variable myNum = " & myNum)
End If
%>

0
 
BardobraveCommented:
You also can try to simplify it:

<%If (RsOrderSummary.Fields.Item("OrderDeliveryCharge")) > 0 then %>
0
 
garethtnashAuthor Commented:
thank you
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now