How do you tell if a value is NULL in ASP Classic and show a message?
In this short but very powerful code, we will check to see if the Value is NULL or if it has data.

strValue = "Something is here." <%if IsNull(strValue)="True" then%> There is no data available for this query. Please try another query. <%else%> <%=strValue%> <%end if%>
In this code, we will check if the data exists; if it does, we will show the data; if it does not, we will display a notice to the user.