Empty DB fields not recognised as null

jim b · Joined: 12 May 2006 Posts: 14

I wonder if anyone has the solution to this problem. I am querying a DB using SQL in ASP. The field is empty when looking at it through MS access, but when I use code like

<%
' DB Connection string

if RsTable1("A1") = "" Then
'do something
else
'do something else
end if
%>

I get the 'do something else lol.

Thanks

Pattons3rd · Joined: 28 Dec 2006 Posts: 1212 Location: Colorado

Maybe if you tried saying if it is == "" instead of = ""