Newbie here! I'm working on a simple form in ASP. When the form field is empty, I want the results to display "None Available" and when there's something entered, I want that to be displayed. Here's the code I came up with so far:
<%
If rsVids.Fields.Item("SampleVid").Value = "" Then
Response.Write("None Available")
Else
Response.Write(rsVids.Fields.Item("SampleVid").Value)
End If
%>
So far, when something is entered into the form it writes to the database and displays correctly on the results page. However, when there is nothing (NULL) in the form field, "None Available" does not show on the results page. What am I doing wrong?
<%
If IsNull(rsVids.Fields.Item("SampleVid").Value) Then
Response.Write("None Available")
Else
Response.Write(rsVids.Fields.Item("SampleVid").Value)
End If
%>
Topic Locked
Posted - 21 December 2007 : 12:20:56
I'm working on a simple form in ASP. When the form field is empty, I want the results to display "None Available" and when there's something entered, I want that to be displayed. Here's the code I came up with so far:
.
