<div>
BTW, if for some reason this data can be a zero length string, yet not be Null, use this:<br />
<br />
&lt;%if IsNull(rs.Fields(&quot;ProgTitl<wbr />e&quot;)) then Response.Write(&quot; &quot;) else Response.Write(rs.Fields(&quot;<wbr />ProgTitle&quot;<wbr />)) end if%&gt;<br />
<br />
But chances are, the first post is what you want.<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />

</div>


BTW, if for some reason this data can be a zero length string, yet not be Null, use this:

<%if IsNull(rs.Fields("ProgTitle")) then Response.Write(" ") else Response.Write(rs.Fields("ProgTitle")) end if%>

But chances are, the first post is what you want.









<div>
Thanks for the post. &nbsp;I'll try this tonight when I get home from work and report findings back here.
</div>


Thanks for the post.  I'll try this tonight when I get home from work and report findings back here.

<div>
Sorry for the delay. &nbsp;Had to go out-of-town unexpectedly.<br />
<br />
This works great. &nbsp;Thanks for the help.
</div>


Sorry for the delay.  Had to go out-of-town unexpectedly.

This works great.  Thanks for the help.

<div>
<div class="content wysiwyg-content">
I've got this line:<br />
&lt;TD BORDERCOLOR=<a href="#c0" rel="ugc">#c0</a>c0c0 width=&quot;645&quot; &gt;&lt;font color=&quot;#000000&quot; face=&quot;Verdana&quot; size=&quot;1&quot;&gt;&lt;%=Server.HTMLEnc<wbr />ode(rs.Fie<wbr />lds(&quot;ProgT<wbr />itle&quot;).Val<wbr />ue)%&gt;&lt;/fon<wbr />t&gt;&lt;/TD&gt; <br />
<br />
I need to add an IIf in there that says, &quot;if the Value of the field is Null, then make it equal to &quot;&nbsp;&quot;, else make it equal to the Value.&quot;<br />

</div>
</div>


I've got this line:
<TD BORDERCOLOR=#c0c0c0 width="645" ><font color="#000000" face="Verdana" size="1"><%=Server.HTMLEncode(rs.Fields("ProgTitle").Value)%></font></TD> 

I need to add an IIf in there that says, "if the Value of the field is Null, then make it equal to " ", else make it equal to the Value."


Using IIf with Server.Encode

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.