I've written my SQL lookup and tested it and it works great. I'm having issues checking and displaying text that might be null.
Can anyone help me with this?
This is what I've written and does not work at all
<%
While (Not rsUP.EOF)
%>
<h3 class="name">
<%
If Not IsNull(rsUP("Name_Title")) Then
Repsonse.Write(rsUP("Name_Title") + " ")
EndIf
Repsonse.Write(rsUP("Name_First"))
If Not IsNull(rsUP("Name_Middle")) Then
Repsonse.Write(" " + rsUP("Name_Middle"))
EndIf
Repsonse.Write(" " + rsUP("Name_Last"))
If Not IsNUll(rsUP("Name_Suffix")) Then
Repsonse.Write(" " + rsUP("Name_Suffix"))
EndIf
%>
</h3>
<%
rsUP.MoveNext
Wend
Set rsUP = Nothing
%>