Mysql question

Hello,

I am having a problem with a calculation in ASP where I am using data
from a
MySQL database. I have the fields Tax and BasePrice defined as DECIMAL
9,2
and I simply adding and multiplying some variables. My SQL select
statement looks ok as well.


If Request.Form("Shipping_Method") = "Selection1" then
 shipping2 = 7.49
Else
 shipping2 = 0
End If

 Payment_Total = (shipping2) +
(rsProducts.Fields.Item("BasePrice").Value) +
((rsProducts.Fields.Item("Tax").Value) *
(rsProducts.Fields.Item("BasePrice").Value))

Any ideas why the above line generates a Type mismatch error?

Thanks in advance,

Jeff P.

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA