i have this cell:

response.write("<td><a href=mailto:"&rs.fields("email")&">"& rs.fields("email") &"</a></td>")

the problem witht he code above is that it shows the email address and uses a lot of cell space.

modified version:

response.write("<td><a href=mailto:"&rs.fields("email")&">"& "email" &"</a></td>")

the above line shows "email" everywhere but I just need it when i have an email in the database.

I am going to test the code below, if some one can help me out to figure this out i would really appreciate it

Thankx!

response.write("<td><a href=mailto:"&rs.fields("email")&">"& "email" &"</a></td>")


...helmut

__________________
...helmut

sorry i didnt post the code i was working with:


response.write(" <td><a href=http://"&rs.fields("url")&" target=""_blank"">"& IF rs.fields("url") = true ("email") else ("") &"</td>")

...helmut

Hi there,

You can't concatenate the code like you have. Try something like this instead:
Dim Email
If rs.fields("url") = True Then
    Response.Write("<td><a href=http://" & rs.fields("url")& " target=""_blank"">" & rs.fields("email")& "</td>")
Else
    Response.Write("<td> </td>")
End If

I may have mixed the url and email fields, as I am not sure what you need ware, but I think you'll catch my drift.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Hi!

Thanks for your response, now the IF statements work! but they test false all the time :(

If rs.fields("email") = True Then
    response.write("<td><a href=mailto:"&rs.fields("email")&">"& rs.fields("email") &"</a></td>")
Else
    Response.Write("<td></td>")
End If
If rs.fields("url") = True Then
    response.write("<td><a href=http://"&rs.fields("url")&" target=""_blank"">"& rs.fields("url") &"</a></td>")
Else
    Response.Write("<td></td>")
End If

I tried
If rs.fields("url") = 1 Then...

but it gives me an error, is there any other way to test if fields have information in them?

Thank YOU!

...helmut

wait!

i need to declare the variables first

ahhh.. sorry i have been spoiled by flash :o(

...helmut