type mismatch retrieving result set

[eddie wang]

The following statement will give me type mismatch error.
interest = rs("CURR_WORKING_INTEREST")
if interest<>0 then ...

But, the following statement will not give me type mismatch error.
interest = round(rs("CURR_WORKING_INTEREST"))
if interest<>0 then ...


I can't use round all the time because result set will be null value.

How to handle this? Thanks.

 

[Curt_C [MVP]]

are you sure that rs("CURR_WORKING_INTEREST") isnt null?
What datatype is it?
Have you tried a CInt() CDbl() etc?

 

[Ray at]

Dim interest
interest = rs.Fields.Item("CURR_WORKING_INTEREST").Value
If IsNull(interest) Then
interest = 0 ''or whatever value you'd like
Else
interest = Round(interest)
End If

Also read here: http://www.aspfaq.com/show.asp?id=2073

Ray at work

 

[eddie wang]

Thanks for the logic. It works great!