Clickable Hyperlinks in Database

lakedesign · Jun 18, 2007

I followed Spiderwebwoman's instructions on creating clickable email
addresses in the DRW, but it gives me a page not found. Any suggestions? (I
use FP2003)

Also, with her instructions to make the hyperlinks open in a new window - I
can't get my FP to accept the added code.

When I highlight the website column, this is the code for it:

<%="<a href=""" & FP_FieldLink(fp_rs,"Website") & """>" &
FP_Field(fp_rs,"Website") & "</a>"%>

Anyone have suggestions for these two things?
A appreciate the help

Kathleen Anderson [MVP - FrontPage] · Jun 18, 2007

Inline.

--

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

lakedesign said:
I followed Spiderwebwoman's instructions on creating clickable email
addresses in the DRW, but it gives me a page not found. Any suggestions?
(I
use FP2003)

What are you using as your default email client on your computer?

Also, with her instructions to make the hyperlinks open in a new window -
I
can't get my FP to accept the added code.

It *should* accept it, although it may give you a warning message about
modifying the code.

lakedesign · Jun 18, 2007

Kathleen,
Thank you for your reply.
I'm using Outlook Express.

It did give me a warning when trying to insert code for new window, but
ignored what I typed and went back to original version.

Kathleen Anderson [MVP - FrontPage] · Jun 18, 2007

Inline (again).

--

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

lakedesign said:
Kathleen,
Thank you for your reply.
I'm using Outlook Express.

The only thing I can suggest is to make sure you are following the
instructions for FP2003 - there are also instructions for FP2002 & FP2000 on
that page and they are different.

It did give me a warning when trying to insert code for new window, but
ignored what I typed and went back to original version.

Instead of typing, try copying and pasting the code from my web page and
change your field name to match what's in your database.

Kathleen Anderson [MVP - FrontPage] · Jun 18, 2007

On this page: http://www.easthamptonct.org/ehbiz/display.asp the code to
open the link in a new window looks like this:

Web Site: <%="<a target='_blank' href=""" &
FP_FieldLink(fp_rs,"website") & """>" & FP_FieldVal(fp_rs,"website") &
"</a>"%>

HTH,

--

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

lakedesign · Jun 19, 2007

Kathleen
Sorry about the delay in getting back to you. I don't kow what I'm doing
wrong.
If I paste the code without the grayed out code, then it doesn't work. The
grayed out code is a webbot - does that have anything to do with it? I also
tried the instructions for earlier versions of FP, but the when I right-click
on the column, hyperlink is not an option. I've tried pasting the code in
notepad, inserting the target blank code and repasting into FP - it still
gives me an erorr and reverts back to the orginal code.

Here is the code for both the email and website columns. If you can see
what is wrong with it, I'd appreciate the help. (currently, I don't have the
email column hyperlinked since it doesn't work.)

<td>Email Address:</td>
Email:><td>

<%=FP_FieldVal(fp_rs,"Email Address")%>

</td>
</tr>
<tr>
<td>Website:</td>
<td>

<%="<a href=""" & FP_FieldLink(fp_rs,"Website") & """>" &
FP_FieldVal(fp_rs,"Website") & "</a>"%>
</td>

Kathleen Anderson [MVP - FrontPage] · Jun 19, 2007

For the hyperlink, I don't think you are removing enough code before you
replace it with the code from my site.

You need to remove:

<%=FP_FieldVal(fp_rs,"weblink")%>

and replace it with

<%="<a target='_blank' href=""" & FP_FieldLink(fp_rs,"weblink") & """>" &
FP_FieldVal(fp_rs,"weblink") & "</a>"%>

--

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

lakedesign · Jun 20, 2007

Thank you - that worked!

Now for the email issue - any ideas as to why it doesn't work?

Kathleen Anderson [MVP - FrontPage] · Jun 20, 2007

Phew!

I *think* the clickable email is not working because your field name has a
space in it - you can either try enclosing it in brackets, like this [Email
Address]

--

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

lakedesign · Jun 20, 2007

I changed the field name for Email Addresses and eliminated the space, but it
still doesn't work.
Should code be eliminated as well for this to work? If so, how would that
be written?

I really appreciate th time you've spent helping me work through these issues.

Kathleen Anderson said:
Phew!

I *think* the clickable email is not working because your field name has a
space in it - you can either try enclosing it in brackets, like this [Email
Address]

--

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

lakedesign said:

Thank you - that worked!

Now for the email issue - any ideas as to why it doesn't work?

Click to expand...

Kathleen Anderson [MVP - FrontPage] · Jun 20, 2007

I just went through the instructions for FP2003
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#email with a
field name of emailaddress. It produced the following:

<td>
<a href="mailto:<%=FP_FieldLink(fp_rs,"emailaddress")%>">
<%=FP_FieldVal(fp_rs,"emailaddress")%></a>
</td>

What do you get when you do this?

--

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

lakedesign said:
I changed the field name for Email Addresses and eliminated the space, but
it
still doesn't work.
Should code be eliminated as well for this to work? If so, how would that
be written?

I really appreciate th time you've spent helping me work through these
issues.

Kathleen Anderson said:

Phew!

I *think* the clickable email is not working because your field name has
a
space in it - you can either try enclosing it in brackets, like this
[Email
Address]

--

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

lakedesign said:

Thank you - that worked!

Now for the email issue - any ideas as to why it doesn't work?

:

For the hyperlink, I don't think you are removing enough code before
you
replace it with the code from my site.

You need to remove:

<%=FP_FieldVal(fp_rs,"weblink")%>

and replace it with

<%="<a target='_blank' href=""" & FP_FieldLink(fp_rs,"weblink") &
""">" &
FP_FieldVal(fp_rs,"weblink") & "</a>"%>

--

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

Kathleen
Sorry about the delay in getting back to you. I don't kow what I'm
doing
wrong.
If I paste the code without the grayed out code, then it doesn't
work.
The
grayed out code is a webbot - does that have anything to do with it?
I
also
tried the instructions for earlier versions of FP, but the when I
right-click
on the column, hyperlink is not an option. I've tried pasting the
code
in
notepad, inserting the target blank code and repasting into FP - it
still
gives me an erorr and reverts back to the orginal code.

Here is the code for both the email and website columns. If you can
see
what is wrong with it, I'd appreciate the help. (currently, I don't
have
the
email column hyperlinked since it doesn't work.)

<td>Email Address:</td>
Email:><td>

<%=FP_FieldVal(fp_rs,"Email Address")%>

</td>
</tr>
<tr>
<td>Website:</td>
<td>

<%="<a href=""" & FP_FieldLink(fp_rs,"Website") & """>"
&
FP_FieldVal(fp_rs,"Website") & "</a>"%>
</td>

:

On this page: http://www.easthamptonct.org/ehbiz/display.asp the
code
to
open the link in a new window looks like this:

Web Site: <%="<a target='_blank' href=""" &
FP_FieldLink(fp_rs,"website") & """>" &
FP_FieldVal(fp_rs,"website") &
"</a>"%>

HTH,

--

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

message
Kathleen,
Thank you for your reply.
I'm using Outlook Express.

It did give me a warning when trying to insert code for new
window,
but
ignored what I typed and went back to original version.

:

Inline.

--

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

message
I followed Spiderwebwoman's instructions on creating clickable
email
addresses in the DRW, but it gives me a page not found. Any
suggestions?
(I
use FP2003)

What are you using as your default email client on your
computer?

Also, with her instructions to make the hyperlinks open in a
new
window -
I
can't get my FP to accept the added code.

It *should* accept it, although it may give you a warning
message
about
modifying the code.

Click to expand...

Click to expand...

lakedesign · Jun 20, 2007

It works!!!! Yes!!!
I am very happy and really appreciate your assistance!

Kathleen Anderson said:
I just went through the instructions for FP2003
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#email with a
field name of emailaddress. It produced the following:

<td>
<a href="mailto:<%=FP_FieldLink(fp_rs,"emailaddress")%>">
<%=FP_FieldVal(fp_rs,"emailaddress")%></a>
</td>

What do you get when you do this?

--

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

lakedesign said:

I changed the field name for Email Addresses and eliminated the space, but
it
still doesn't work.
Should code be eliminated as well for this to work? If so, how would that
be written?

I really appreciate th time you've spent helping me work through these
issues.

Kathleen Anderson said:

Phew!

I *think* the clickable email is not working because your field name has
a
space in it - you can either try enclosing it in brackets, like this
[Email
Address]

--

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

Thank you - that worked!

Now for the email issue - any ideas as to why it doesn't work?

:

For the hyperlink, I don't think you are removing enough code before
you
replace it with the code from my site.

You need to remove:

<%=FP_FieldVal(fp_rs,"weblink")%>

and replace it with

<%="<a target='_blank' href=""" & FP_FieldLink(fp_rs,"weblink") &
""">" &
FP_FieldVal(fp_rs,"weblink") & "</a>"%>

--

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

Kathleen
Sorry about the delay in getting back to you. I don't kow what I'm
doing
wrong.
If I paste the code without the grayed out code, then it doesn't
work.
The
grayed out code is a webbot - does that have anything to do with it?
I
also
tried the instructions for earlier versions of FP, but the when I
right-click
on the column, hyperlink is not an option. I've tried pasting the
code
in
notepad, inserting the target blank code and repasting into FP - it
still
gives me an erorr and reverts back to the orginal code.

Here is the code for both the email and website columns. If you can
see
what is wrong with it, I'd appreciate the help. (currently, I don't
have
the
email column hyperlinked since it doesn't work.)

<td>Email Address:</td>
Email:><td>

<%=FP_FieldVal(fp_rs,"Email Address")%>

</td>
</tr>
<tr>
<td>Website:</td>
<td>

<%="<a href=""" & FP_FieldLink(fp_rs,"Website") & """>"
&
FP_FieldVal(fp_rs,"Website") & "</a>"%>
</td>

:

On this page: http://www.easthamptonct.org/ehbiz/display.asp the
code
to
open the link in a new window looks like this:

Web Site: <%="<a target='_blank' href=""" &
FP_FieldLink(fp_rs,"website") & """>" &
FP_FieldVal(fp_rs,"website") &
"</a>"%>

HTH,

--

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

message
Kathleen,
Thank you for your reply.
I'm using Outlook Express.

It did give me a warning when trying to insert code for new
window,
but
ignored what I typed and went back to original version.

:

Inline.

--

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

message
I followed Spiderwebwoman's instructions on creating clickable
email
addresses in the DRW, but it gives me a page not found. Any
suggestions?
(I
use FP2003)

What are you using as your default email client on your
computer?

Also, with her instructions to make the hyperlinks open in a
new
window -
I
can't get my FP to accept the added code.

It *should* accept it, although it may give you a warning
message
about
modifying the code.

Click to expand...

Click to expand...

Kathleen Anderson [MVP - FrontPage] · Jun 20, 2007

That's great - glad I could help.

--

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

lakedesign said:
It works!!!! Yes!!!
I am very happy and really appreciate your assistance!

Kathleen Anderson said:

I just went through the instructions for FP2003
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#email with
a
field name of emailaddress. It produced the following:

<td>
<a href="mailto:<%=FP_FieldLink(fp_rs,"emailaddress")%>">
<%=FP_FieldVal(fp_rs,"emailaddress")%></a>
</td>

What do you get when you do this?

--

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

lakedesign said:

I changed the field name for Email Addresses and eliminated the space,
but
it
still doesn't work.
Should code be eliminated as well for this to work? If so, how would
that
be written?

I really appreciate th time you've spent helping me work through these
issues.

:

Phew!

I *think* the clickable email is not working because your field name
has
a
space in it - you can either try enclosing it in brackets, like this
[Email
Address]

--

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

Thank you - that worked!

Now for the email issue - any ideas as to why it doesn't work?

:

For the hyperlink, I don't think you are removing enough code
before
you
replace it with the code from my site.

You need to remove:

<%=FP_FieldVal(fp_rs,"weblink")%>

and replace it with

<%="<a target='_blank' href=""" & FP_FieldLink(fp_rs,"weblink") &
""">" &
FP_FieldVal(fp_rs,"weblink") & "</a>"%>

--

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

message
Kathleen
Sorry about the delay in getting back to you. I don't kow what
I'm
doing
wrong.
If I paste the code without the grayed out code, then it doesn't
work.
The
grayed out code is a webbot - does that have anything to do with
it?
I
also
tried the instructions for earlier versions of FP, but the when I
right-click
on the column, hyperlink is not an option. I've tried pasting
the
code
in
notepad, inserting the target blank code and repasting into FP -
it
still
gives me an erorr and reverts back to the orginal code.

Here is the code for both the email and website columns. If you
can
see
what is wrong with it, I'd appreciate the help. (currently, I
don't
have
the
email column hyperlinked since it doesn't work.)

<td>Email Address:</td>
Email:><td>

<%=FP_FieldVal(fp_rs,"Email Address")%>

</td>
</tr>
<tr>
<td>Website:</td>
<td>

<%="<a href=""" & FP_FieldLink(fp_rs,"Website") &
""">"
&
FP_FieldVal(fp_rs,"Website") & "</a>"%>
</td>

:

On this page: http://www.easthamptonct.org/ehbiz/display.asp the
code
to
open the link in a new window looks like this:

Web Site: <%="<a target='_blank' href=""" &
FP_FieldLink(fp_rs,"website") & """>" &
FP_FieldVal(fp_rs,"website") &
"</a>"%>

HTH,

--

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

message
Kathleen,
Thank you for your reply.
I'm using Outlook Express.

It did give me a warning when trying to insert code for new
window,
but
ignored what I typed and went back to original version.

:

Inline.

--

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

message
I followed Spiderwebwoman's instructions on creating
clickable
email
addresses in the DRW, but it gives me a page not found.
Any
suggestions?
(I
use FP2003)

What are you using as your default email client on your
computer?

Also, with her instructions to make the hyperlinks open in
a
new
window -
I
can't get my FP to accept the added code.

It *should* accept it, although it may give you a warning
message
about
modifying the code.

Click to expand...

Click to expand...

bullet list extra spacing	2	Jan 18, 2009
Database Results Wizard Error - FrontPage 2003	5	Mar 3, 2006
I am trying to understand this code...	3	Jul 26, 2008
FP2003 SQL ignoring values passed through hyperlink	2	Apr 24, 2005
Database Results Error	2	Nov 24, 2004
Parameter passing within a ASP page	2	Oct 27, 2004
Parameter passing query	4	Oct 27, 2004
any ideas why I can update one table in my database but not the other?	2	Sep 22, 2006

Clickable Hyperlinks in Database

lakedesign

Kathleen Anderson [MVP - FrontPage]

lakedesign

Kathleen Anderson [MVP - FrontPage]

Kathleen Anderson [MVP - FrontPage]

lakedesign

Kathleen Anderson [MVP - FrontPage]

lakedesign

Kathleen Anderson [MVP - FrontPage]

lakedesign

Kathleen Anderson [MVP - FrontPage]

lakedesign

Kathleen Anderson [MVP - FrontPage]

Ask a Question

Similar Threads