showing db fields

[help120]

I'm trying to call on info from my data base except If the information is blank or = to NA then I want it to display an error message/url. If it's not blank or not = to NA then I want it to display the information in the db.

This is my code so fare..

<%
if trim(rs(&quot;pstarted&quot) = &quot;&quot; or IsNull(rs(&quot;pstarted&quot)then Err_Msg = Err_Msg & &quot;upgrade now&quot;
end if
%>

Now this code works but if the info is some thing other then a blank field thin it shows nothing. Like if I've &quot;1/1/2002&quot; it comes up blank.

 

[minoad]

Depending on how you wanted it displayed you would put it into an else statement.
<%
if trim(rs(&quot;pstarted&quot) = &quot;&quot; or IsNull(rs(&quot;pstarted&quot)then Err_Msg = Err_Msg & &quot;upgrade now&quot;
else
%>
<td>
<%=rs(&quot;pstarted&quot%>
</td>
<%
end if
%>

 

[help120]

perfect thanks