<div>
Empty is different than null. Are you sure that rs(&quot;OrgPhoneTTY&quot;) is returning null and not just an empty string? What you can probably do is change it to this:<br />
<br />
&lt;% IF (NOT rs(&quot;OrgPhoneTTY&quot;) &lt;&gt;&nbsp;&quot;&quot; ) THEN %&gt;<br />
&lt;div&gt;TTY &nbsp;&lt;%=rs(&quot;OrgPhoneTTY&quot;)%&gt;&lt;/di<wbr />v&gt;<br />
&lt;% end if %&gt;<br />

</div>


Empty is different than null. Are you sure that rs("OrgPhoneTTY") is returning null and not just an empty string? What you can probably do is change it to this:

<% IF (NOT rs("OrgPhoneTTY") <> "" ) THEN %>
<div>TTY  <%=rs("OrgPhoneTTY")%></div>
<% end if %>


<div>
Both previous expert comments could be correct. &nbsp;if you go with amit's then you should do it all in 1 IF statement:<br />
<br />
&lt;% If Not isNull(rs(&quot;OrgPhoneTTY&quot;)) OR rs(&quot;OrgPhoneTTY&quot;)&lt;&gt;&quot;&quot; Then %&gt;<br />
&lt;div&gt;TTY &nbsp;&lt;%=rs(&quot;OrgPhoneTTY&quot;)%&gt;&lt;/di<wbr />v&gt;<br />
&lt;% End If %&gt;<br />
<br />
~ MastaLlama ~
</div>


Both previous expert comments could be correct.  if you go with amit's then you should do it all in 1 IF statement:

<% If Not isNull(rs("OrgPhoneTTY")) OR rs("OrgPhoneTTY")<>"" Then %>
<div>TTY  <%=rs("OrgPhoneTTY")%></div>
<% End If %>

~ MastaLlama ~

<div>
<div class="content wysiwyg-content">
I want to skip over a record if it is null so it does not print the section of the data <br />
<br />
currently I have this which does not work<br />
<br />
&lt;% IF (NOT ISNULL (rs(&quot;OrgPhoneTTY&quot;))) THEN %&gt;<br />
&lt;div&gt;TTY &nbsp;&lt;%=rs(&quot;OrgPhoneTTY&quot;)%&gt;&lt;/di<wbr />v&gt;<br />
&lt;% end if %&gt;<br />
<br />
but it still prints the TTY if its empty
</div>
</div>


I want to skip over a record if it is null so it does not print the section of the data 

currently I have this which does not work

<% IF (NOT ISNULL (rs("OrgPhoneTTY"))) THEN %>
<div>TTY  <%=rs("OrgPhoneTTY")%></div>
<% end if %>

but it still prints the TTY if its empty

sql vbscript     if record null then

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.