empty field in recordset - null value

[Bastien]

Hi guys,
how do I deal with empty fields in a recordset...the server.htmlEncode function can not produce an empty field i.e. ""
How can I get around this to fix this up...

if HTMLEncode (objRS(x))="" then
Response.Write &quot;No Result</td></tr>&quot;
else %>
<%=objRS(x)%></td></tr>
<%
end if

thank
bastien

 

[OrWolf]

I believe the correct syntax you are looking for is:

if HTMLEncode objRS.EOF = True Then

 

[Geee]

I take it that the code you posted above does not work. You need to check if the field is null, rather than &quot;&quot;. If that makes sense! Null is a different state than containing nothing. So you code should be...

if HTMLEncode IsNull(ObjRS(x)) then
Response.Write &quot;No Result</td></tr>&quot;
else %>
<%=objRS(x)%></td></tr>
<%
end if


Hope this helps...
Gee

-GTM Solutions, Home of USITE-
-=

http://www.gtmsolutions.com=-