Microsoft VBScript runtime error - Type mismatch

[makinha]

Hello,

I got a type mismatch error on my script when compare the null value collect from the sql server.

From the beginning, I code as below:

 <% If (rst_rs("Amount"))="" then %> 
Sorry the amount is 0
<%else%>
Amount : <%=rst_rs("Amount")%>
<% end if%>
 

And I found that the value nullable, and I have check that the value is NULL in the sql server, so I change my script to check if it is null value:

 <% If isnull(rst_rs("Amount"))=true then %> 
Sorry the amount is 0
<%else%>
Amount : <%=rst_rs("Amount")%>
<% end if%>
 

However, I still got the Type mismatch error, any idea??

[omerbutt]

Hello,

I got a type mismatch error on my script when compare the null value collect from the sql server.

From the beginning, I code as below:
<% If (rst_rs("Amount"))="" then %>
Sorry the amount is 0
<%else%>
Amount : <%=rst_rs("Amount")%>
<% end if%>

And I found that the value nullable, and I have check that the value is NULL in the sql server, so I change my script to check if it is null value:

<% If isnull(rst_rs("Amount"))=true then %>
Sorry the amount is 0
<%else%>
Amount : <%=rst_rs("Amount")%>
<% end if%>

However, I still got the Type mismatch error, any idea??

can you specify at which line