How to hide HTML output when recordset field value is null? 2

[PSchubert]

Hi all,

I know from prior posts that you people know just what to say to help a brother out, so here goes:

What I want to do is just what the subject says, and here's what I've got that doesn't work:

<%
    [COLOR=green]'...[i]all this code in green works great[/i]

blah blah blah blah

    Response.Write("<TABLE Align='left' BORDER='0' CELLPADDING='20' CELLSPACING='2'><TBODY><TR><TD style='vertical-align:top'><FONT FACE=""ARIAL"" SIZE=""2"">" & rs("MyFieldName") & "<br>" & rs("MyFieldName2")) [/color]

[COLOR=red]If Not rs.EOF Or Not rs.BOF Then
		If Not IsNull rs("nfldFDimHeight") Then
			Response.Write("<br> &#160;&#160;framed " & rs("nfldFDimHeight") & " x " & rs("nfldFDimWidth") & " x " & rs("nfldFDimDepth") & " cm")
		End If
	End If[/color]

[COLOR=green]	Response.Write("<br> &#160;&#160;...more stuff here...</font></TD>")[/color]
%>

The problem is with the code in red. What I want is, if the field "nfldFDimHeight" is null, then don't display anything until the next Response.Write.

Thanks for your help!

 

[guitarzan]

You should report what error you get. Try the line below:

If Not IsNull(rs("nfldFDimHeight")) Then

 

[AzizKamal]

If the above solution does not work, then also try this one:

If Not (rs.BOF and rs.EOF) Then        
     If Not IsNull(rs("nfldFDimHeight")) Then            
         Response.Write
     End If    
End If

 

[PSchubert]

See? That, right there, is why I post my questions here.

"Thank you," & (guitarzan) & (AzizKamal) & ", very much!"

Here is the final result, for anyone interested:

If Not (rs.EOF Or Not rs.BOF) Then
	If (rs("nfldFDimHeight") > "0") Then
		Response.Write("<br> &#160;&#160;" & rs("nfldFDimHeight") & " x " & rs("nfldFDimWidth") & " x " & rs("nfldFDimDepth") & " cm framed")
	End If
End If

I changed my table to record a zero instead of a null, but the extra parentheses work in either case. Actually, if it doesn't work without them, then I guess they're not really extra, are they?