Hiding blank record data

[james.shearer]

I want to display the contents of a field with a label if there is data

in that field. If there isn't then I don't want the label to appear.

I tried this:

<%If Venueinfo("email") = "" Then
Else%>Email: <a href="mailto:<%=Venueinfo("email")%>">Click to
email</a><br><%End If%>

But it doesn't seem to work. It seems to always display the label and
link even though there is no data in that field.

help?

this is ASP and mysql

 

[Evertjan.]

wrote on 24 nov 2005 in microsoft.public.inetserver.asp.general:

<%If Venueinfo("email") = "" Then
Else%>Email: <a href="mailto:<%=Venueinfo("email")%>">Click to
email</a><br><%End If%>

vbScript code is new-line sensitive:

<%
If Venueinfo("email") <> "" Then
%>
Email: <a href='mailto:<%=Venueinfo("email")%>'>
Click to email</a><br>
<%
End If
%>

While jscript is not:

<% If (Venueinfo('email')!='') { %>Email:
<a href='mailto:<%=Venueinfo('email')%>'>
Click to email</a><br><% }; %>