Multiply number with decimal point

[tyutghf]

I have a price with two decimal places in a database i.e. 2.00, output this to the page and it displays 2.00 fine, but when I multiply this price by the quantity i.e 3 x 2.00 it is coming out as 600, when it should be 6.

strProductTotal = rs("quantity") * cint(rs("productprice"))

response.write strProductTotal 
response.write rs("productprice")

The first response will give as the example above 600, the second will write 2.00, so it is clearly ignoring the decimal point.

Any ideas why? Thanks.

 

[tyutghf]

Scrap this post, seems to be working now?!?!?!?!? Sme wierd firefox issue going on there, used another browser and works fine, shut down FF, opened back up and is ok

 

[vicvirk]

strProductTotal = rs("quantity") * cint(rs("productprice"))

should use "cdbl" instead of "cint"

If the product price is $2.15, cint will think of it as "$2"




--------

GOOGLE is a great resource to find answers to questions like "how do i..."

http://www.google.com/webhp?complete=1&hl=en

--------