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

[MyndPhlyp]

<ja***********@gmail.com> wrote in message
news:11********************@z14g2000cwz.googlegrou ps.com...

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.

Is the field really "", or is it Empty, or is it Null?

"" <> Empty <> Null

To cover all the bases:

If Venueinfo("email") = "" Or IsNull(Venueinfo("email")) Or
IsEmpty(Venueinfo("email")) Then

[Bob Barrows [MVP]]

MyndPhlyp wrote:

To cover all the bases:

If Venueinfo("email") = "" Or IsNull(Venueinfo("email")) Or
IsEmpty(Venueinfo("email")) Then

A good hack to use is this:

if Venueinfo("email") & "" = "" then

Given the fact that operations involving Null are supposed to result in
Null, one would not expect this hack to work. However, in both VB and
vbscript, concatenation with Null does not result in Null, so the above hack
works.
Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[MyndPhlyp]

"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:e9*************@TK2MSFTNGP15.phx.gbl...

MyndPhlyp wrote:

To cover all the bases:

If Venueinfo("email") = "" Or IsNull(Venueinfo("email")) Or
IsEmpty(Venueinfo("email")) Then

A good hack to use is this:

if Venueinfo("email") & "" = "" then

I almost included that in my earlier reply. Definitely a slick and elegant
hack. I have been aware of it for quite some time but choose not to use it
for a couple of reasons: (a) it relies upon a quirk, and (b) it doesn't
document very well to the unenlightened developer.