IF in Hyperlink

22 Mar 2009 2:02 PM

John P.

I have a Data Results table and some records have a field with a pdf
document hyperlinked, but not all.records have one.

Is there a way where on the hyperlink I can say show PDF link only if the
field is populated?

As at resent I have people clicking on the links (empty ones) and getting
nothing.

Thanks
John P.

22 Mar 2009 2:57 PM

Kathleen Anderson

You could wrap the code in a script that tests whether or not there is
anything in that field:

here's an example:

<% If fp_rs("Municipality") > " " then %>

<li>Municipality: <%=FP_FieldVal(fp_rs,"Municipality")%></li>

<% End If %>

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
Expression Web Wiki: http://expression-web-wiki.com/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

Show quoteHide quote

"John P." <park***@gmail.com> wrote in message
news:e9pqGbvqJHA.3992@TK2MSFTNGP04.phx.gbl...
>I have a Data Results table and some records have a field with a pdf
>document hyperlinked, but not all.records have one.
>
> Is there a way where on the hyperlink I can say show PDF link only if the
> field is populated?
>
> As at resent I have people clicking on the links (empty ones) and getting
> nothing.
>
> Thanks
> John P.
>

23 Mar 2009 8:29 AM

Stefan B Rusynko

PS
- the test you posted only checks if the field is greater than a space " "
<% If fp_rs("Municipality") > " " then %>

Better to use a test for an empty record as

<% If fp_rs("Municipality")<> "" Then %>

Or

<% If Len(fp_rs("Municipality")>0 Then %>

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________

Show quoteHide quote