Oracle & ASP: Types don't match

[cadbilbao]

Hi!

I'm attempting to make an arithmetic operation with two Oracle variables. Both of them are NUMBER type (inside Oracle).

But if I try (inside ASP):

asp1 = rs("var1&quot
asp2 = rs("var2&quot
result = asp1 * ( 1 - (asp2/100) )

I get "types don't match" error.

What I am doing wrong?

Reagars,

 

[icarix]

you might be able to get round this problem by converting the asp variables to int valuse by using

asp1 = CInt(asp1)
asp2 = CInt(asp2)

before you try to do the calculation

 

[cadbilbao]

But they are not Integers...

 

[delorfra]

Try CSng to convert variables into single real numbers or CDbl into double precision real numbers