only show field if data

[RFH Reseller: Space Cowboy]

Hi, I have this piece of ASP code which displays data from the database

<tr><td>
<strong>Organisation: <%= rstemp.Fields("Organisation").Value %></strong></td></tr>

now I only want it to display this row (within the table) if there is data in the field.
So I need a sort of 'if' statement to wrap around the table row.

Im a ASP newbiw please be kind!

[RFH Reseller: Rappie]

Something like this?

<%
StrOrg = rstemp.Fields("Organisation").Value 
 
If StrOrg <> "" then
%>
<tr><td>
<strong>Organisation: <%= rstemp.Fields("Organisation").Value %></strong></td></tr>
<%
End If
%>

Just from the top of my mind, not tested the code.

[RFH Reseller: askjim]

Also test the code works when the value returned is null

[Staff: Warren Ashcroft]

Here is another way of doing it (note: its better performance wise to check the length of variables rather than compare it to an empty string).

<%
Function CanShowField(ByRef Field)
    If Not IsNull(Field) Then
        If Not Len(Field) = 0 Then
            CanShowField = True
        End If
    End If
End Function
%>

<% If CanShowField(rstemp("Organisation")) Then %>
<tr><td><strong>Organisation: <%=rstemp("Organisation")%></strong></td></tr>
<% End If %>