I query a database that returns an address for a pdf I want to link to. My
field in the database has the address, and my database results page takes
that generated info and makes it a hyperlink. This works fine as long as
there is something in the field in the database. If the field is empty,
there is no address there but it has a one charachter wide section of
underline like there is still a link. When you click this it gives a
database results error page like it is trying to reprocess the form or
something.

The field containing the address in my database is empty, I double checked
that. If I remove the "make hyperlink" property from the field in my
database results page, it is fine nothing is returned. My thinking is that
once it is made a hyperlink in the database results page it has to return
something since a hyperlink cannot be empty.

I wonder if there is a way around this? Thanks

I solve this issue by having a Yes/No file in the database related to the hyperlink field, then in
my page I do the following:

<% If objRS("LinkYN") = Yes Then %>
<a href="<%=objRS("LinkURL")%>"><%=objRS("LinkTitle")%></a>
<% Else %>
&nbsp;
<% End If %>

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Jed" <(E-Mail Removed)> wrote in message
news:821F346C-E7B4-4D39-8B4C-(E-Mail Removed)...
>I query a database that returns an address for a pdf I want to link to. My
> field in the database has the address, and my database results page takes
> that generated info and makes it a hyperlink. This works fine as long as
> there is something in the field in the database. If the field is empty,
> there is no address there but it has a one charachter wide section of
> underline like there is still a link. When you click this it gives a
> database results error page like it is trying to reprocess the form or
> something.
>
> The field containing the address in my database is empty, I double checked
> that. If I remove the "make hyperlink" property from the field in my
> database results page, it is fine nothing is returned. My thinking is that
> once it is made a hyperlink in the database results page it has to return
> something since a hyperlink cannot be empty.
>
> I wonder if there is a way around this? Thanks

I solve this issue this way:
http://www.spiderwebwoman.com/resour...asp#hyperlinks
:-)

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx



"Jed" <(E-Mail Removed)> wrote in message
news:821F346C-E7B4-4D39-8B4C-(E-Mail Removed)...
>I query a database that returns an address for a pdf I want to link to. My
> field in the database has the address, and my database results page takes
> that generated info and makes it a hyperlink. This works fine as long as
> there is something in the field in the database. If the field is empty,
> there is no address there but it has a one charachter wide section of
> underline like there is still a link. When you click this it gives a
> database results error page like it is trying to reprocess the form or
> something.
>
> The field containing the address in my database is empty, I double checked
> that. If I remove the "make hyperlink" property from the field in my
> database results page, it is fine nothing is returned. My thinking is
> that
> once it is made a hyperlink in the database results page it has to return
> something since a hyperlink cannot be empty.
>
> I wonder if there is a way around this? Thanks