data base hyperlinks

Guest · Mar 5, 2007

I have successfully created a small excel database and have frontpage reading
it and displaying on the web. I have hyperlinks in the DB to external sites
using http://www.externalsite.com.

I would like to display the "connect" instead of using the full URL. When I
display the word "connect" in excel and define the hyperlink in excel it
works fine but when the database reads it on the web, it trys to link to a
page in the website named "connect".

How can I get the hyperlink definition to make the trip from excel to FP to
the web?

David Berry · Mar 5, 2007

Do you mean you want to see the word "connect" with a hyperlink? Ex:

<a href="http://www.mysite.com">connect</a>

If so the you would modify your ASP code to show the hyperlink, then the
word connect. Ex:

<a href="<%=RS("HYPERLINK_FIELD")%>">connect</a>

It would be helpful to see your code to get a better understanding of what
you're trying to do.

Guest · Mar 5, 2007

Sure, here is the page:

http://www.bdmcdaytona.com/testdux/agentroster.asp

In the right hand column, you see web site urls which work just fine. You
also see the word "connect". On the excel spreadsheet that feeds this,
"connect" is the display word but when you click on it, you go to the target
URL.

Likewise you see e mail addresses in the next column. You also see the word
"email". On the excel sheet, that is the display word that hyperlinks to an
e mail address but it doesn't work on this page.

The objective is to not show each e-mail address and site url but use the
words "connect" and "email" to save space on the table.

David Berry · Mar 6, 2007

Ok. What I meant is that we need to see the actual code. Doing a View
Source on an ASP page won't show server-side scripting. Please switch to
Code View and copy and paste all the ASP code into a reply. (delete out your
database connection user name and password first).

Guest · Mar 6, 2007

You mean the HTML view tab in Front Page, all that code?

I don't see a database connection user name and password on that page so I'm
not sure I've got the right info for you.

David Berry · Mar 6, 2007

Yes. That code

Guest · Mar 6, 2007

Here is the code: If, in your review, you see a passcode, please tell me
where it is.

I took out as much irrelevant stuff like colors and back grounds:
<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not
Edit.
FP_LCID = 1033 %>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not
Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 1</title>
</head>

<body bgcolor="#C0C0C0">

<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse:
collapse" bordercolor="#111111" id="AutoNumber1" width="867" height="342">
<tr>
<td align="left" valign="top" rowspan="2" width="140" height="144">
</td>
<td align="center"> </td>
</tr>
<tr>
<td align="right" valign="top" height="120" style="color: #FFFF00">
<table width="725" border="1" bgcolor="#C0C0C0"
style="border-collapse: collapse" bordercolor="#111111" cellpadding="0"
cellspacing="0">
<thead>
<tr>
<td><b><font size="2" color="#111111">Agent Name</font></b></td>
<td width="120"><b><font size="2"
color="#111111">Office</font></b></td>
<td width="125" align="center"><b><font size="2"
color="#111111">Office Phone</font></b></td>
<td width="125" align="center"><b><font size="2"
color="#111111">Cell Phone</font></b></td>
<td width="120"><b><font size="2" color="#111111">E- Mail
Address</font></b></td>
<td width="200"><b><font size="2"
color="#111111">Website</font></b></td>
</tr>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM ""agent3"" ORDER BY ""Agent Name"" ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=6 align=left width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="Agent Name"
fp_sMenuValue="Agent Name"
fp_sColTypes="&Agent Name=200&Office=200&Office Phone=200&Cell Phone=200&E-
Mail Address=200&Website=200&"
fp_iDisplayCols=6
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>

<tr>
<td width="216">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Agent
Name")%></font></td>
<td width="120">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Office")%></font></td>
<td width="125" align="center">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Office
Phone")%></font></td>
<td width="125" align="center">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Cell
Phone")%></font></td>
<td width="120">
<font size="2" color="#111111">
<%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail Address") & """>" &
FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%></font></td>
<td width="200">
<font size="2" color="#111111">
<%="<a
href=""" & FP_FieldLink(fp_rs,"Website") & """>" &
FP_FieldVal(fp_rs,"Website") & "</a>"%></font></td>
</tr>

</tbody>
</table>
</td>
</tr>
</table>
</center>
</div>

</body>

David Berry · Mar 6, 2007

Where you have Email Address change:

<%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail Address") & """>" &
FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%>

To

<a href ='<%=FP_FieldLink(fp_rs,"E- Mail Address")%>'>email</a>

Where you have web site change:

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

To

<a href='<%=FP_FieldLink(fp_rs,"Website")%>'>connect</a>

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

Daytona Steve said:
Here is the code: If, in your review, you see a passcode, please tell me
where it is.

I took out as much irrelevant stuff like colors and back grounds:
<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do
not
Edit.
FP_LCID = 1033 %>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do
not
Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 1</title>
</head>

<body bgcolor="#C0C0C0">

<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse:
collapse" bordercolor="#111111" id="AutoNumber1" width="867" height="342">
<tr>
<td align="left" valign="top" rowspan="2" width="140" height="144">
</td>
<td align="center"> </td>
</tr>
<tr>
<td align="right" valign="top" height="120" style="color: #FFFF00">
<table width="725" border="1" bgcolor="#C0C0C0"
style="border-collapse: collapse" bordercolor="#111111" cellpadding="0"
cellspacing="0">
<thead>
<tr>
<td><b><font size="2" color="#111111">Agent
Name</font></b></td>
<td width="120"><b><font size="2"
color="#111111">Office</font></b></td>
<td width="125" align="center"><b><font size="2"
color="#111111">Office Phone</font></b></td>
<td width="125" align="center"><b><font size="2"
color="#111111">Cell Phone</font></b></td>
<td width="120"><b><font size="2" color="#111111">E- Mail
Address</font></b></td>
<td width="200"><b><font size="2"
color="#111111">Website</font></b></td>
</tr>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The
Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on
a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM ""agent3"" ORDER BY ""Agent Name"" ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=6 align=left width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="Agent Name"
fp_sMenuValue="Agent Name"
fp_sColTypes="&Agent Name=200&Office=200&Office Phone=200&Cell
Phone=200&E-
Mail Address=200&Website=200&"
fp_iDisplayCols=6
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>

<tr>
<td width="216">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Agent
Name")%></font></td>
<td width="120">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Office")%></font></td>
<td width="125" align="center">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Office
Phone")%></font></td>
<td width="125" align="center">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Cell
Phone")%></font></td>
<td width="120">
<font size="2" color="#111111">
<%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail Address") & """>" &
FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%></font></td>
<td width="200">
<font size="2" color="#111111">
<%="<a
href=""" & FP_FieldLink(fp_rs,"Website") & """>" &
FP_FieldVal(fp_rs,"Website") & "</a>"%></font></td>
</tr>

</tbody>
</table>
</td>
</tr>
</table>
</center>
</div>

</body>

David Berry said:

Yes. That code

Click to expand...

Guest · Mar 7, 2007

Thank you,

Unfortunately, when I make this change, its tells me that a FP Component has
been changed and it will be over written when I save the file, so my changes
get discarded.

I think there is a way to fix that, I just don't remember what it is. Bit
of a rookie here.

David Berry said:
Where you have Email Address change:

<%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail Address") & """>" &
FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%>

To

<a href ='<%=FP_FieldLink(fp_rs,"E- Mail Address")%>'>email</a>

Where you have web site change:

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

To

<a href='<%=FP_FieldLink(fp_rs,"Website")%>'>connect</a>

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

Daytona Steve said:

Here is the code: If, in your review, you see a passcode, please tell me
where it is.

I took out as much irrelevant stuff like colors and back grounds:
<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do
not
Edit.
FP_LCID = 1033 %>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do
not
Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 1</title>
</head>

<body bgcolor="#C0C0C0">

<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse:
collapse" bordercolor="#111111" id="AutoNumber1" width="867" height="342">
<tr>
<td align="left" valign="top" rowspan="2" width="140" height="144">
</td>
<td align="center"> </td>
</tr>
<tr>
<td align="right" valign="top" height="120" style="color: #FFFF00">
<table width="725" border="1" bgcolor="#C0C0C0"
style="border-collapse: collapse" bordercolor="#111111" cellpadding="0"
cellspacing="0">
<thead>
<tr>
<td><b><font size="2" color="#111111">Agent
Name</font></b></td>
<td width="120"><b><font size="2"
color="#111111">Office</font></b></td>
<td width="125" align="center"><b><font size="2"
color="#111111">Office Phone</font></b></td>
<td width="125" align="center"><b><font size="2"
color="#111111">Cell Phone</font></b></td>
<td width="120"><b><font size="2" color="#111111">E- Mail
Address</font></b></td>
<td width="200"><b><font size="2"
color="#111111">Website</font></b></td>
</tr>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The
Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on
a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM ""agent3"" ORDER BY ""Agent Name"" ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=6 align=left width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="Agent Name"
fp_sMenuValue="Agent Name"
fp_sColTypes="&Agent Name=200&Office=200&Office Phone=200&Cell
Phone=200&E-
Mail Address=200&Website=200&"
fp_iDisplayCols=6
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>

<tr>
<td width="216">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Agent
Name")%></font></td>
<td width="120">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Office")%></font></td>
<td width="125" align="center">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Office
Phone")%></font></td>
<td width="125" align="center">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Cell
Phone")%></font></td>
<td width="120">
<font size="2" color="#111111">
<%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail Address") & """>" &
FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%></font></td>
<td width="200">
<font size="2" color="#111111">
<%="<a
href=""" & FP_FieldLink(fp_rs,"Website") & """>" &
FP_FieldVal(fp_rs,"Website") & "</a>"%></font></td>
</tr>

</tbody>
</table>
</td>
</tr>
</table>
</center>
</div>

</body>

David Berry said:

Yes. That code

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

You mean the HTML view tab in Front Page, all that code?

I don't see a database connection user name and password on that page
so
I'm
not sure I've got the right info for you.

:

Ok. What I meant is that we need to see the actual code. Doing a View
Source on an ASP page won't show server-side scripting. Please switch
to
Code View and copy and paste all the ASP code into a reply. (delete
out
your
database connection user name and password first).

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

message
Sure, here is the page:

http://www.bdmcdaytona.com/testdux/agentroster.asp

In the right hand column, you see web site urls which work just
fine.
You
also see the word "connect". On the excel spreadsheet that feeds
this,
"connect" is the display word but when you click on it, you go to
the
target
URL.

Likewise you see e mail addresses in the next column. You also see
the
word
"email". On the excel sheet, that is the display word that
hyperlinks
to
an
e mail address but it doesn't work on this page.

The objective is to not show each e-mail address and site url but
use
the
words "connect" and "email" to save space on the table.

:

Do you mean you want to see the word "connect" with a hyperlink?
Ex:

<a href="http://www.mysite.com">connect</a>

If so the you would modify your ASP code to show the hyperlink,
then
the
word connect. Ex:

Click to expand...

Click to expand...

David Berry · Mar 7, 2007

Sorry I can't help more. I don't use the Database Wizards so I'm not an
expert there but If I recall, don't try and make the change in Code View.
In Design View double-click on where the code is. I think that will bring up
a box where you can change the code. See
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp for more
information on the Database Wizard

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

Daytona Steve said:
Thank you,

Unfortunately, when I make this change, its tells me that a FP Component
has
been changed and it will be over written when I save the file, so my
changes
get discarded.

I think there is a way to fix that, I just don't remember what it is. Bit
of a rookie here.

David Berry said:

Where you have Email Address change:

<%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail Address") & """>" &
FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%>

To

<a href ='<%=FP_FieldLink(fp_rs,"E- Mail Address")%>'>email</a>

Where you have web site change:

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

To

<a href='<%=FP_FieldLink(fp_rs,"Website")%>'>connect</a>

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

Daytona Steve said:

Here is the code: If, in your review, you see a passcode, please tell
me
where it is.

I took out as much irrelevant stuff like colors and back grounds:
<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do
not
Edit.
FP_LCID = 1033 %>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do
not
Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>New Page 1</title>
</head>

<body bgcolor="#C0C0C0">

<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0"
style="border-collapse:
collapse" bordercolor="#111111" id="AutoNumber1" width="867"
height="342">
<tr>
<td align="left" valign="top" rowspan="2" width="140"
height="144">
</td>
<td align="center"> </td>
</tr>
<tr>
<td align="right" valign="top" height="120" style="color:
#FFFF00">
<table width="725" border="1" bgcolor="#C0C0C0"
style="border-collapse: collapse" bordercolor="#111111" cellpadding="0"
cellspacing="0">
<thead>
<tr>
<td><b><font size="2" color="#111111">Agent
Name</font></b></td>
<td width="120"><b><font size="2"
color="#111111">Office</font></b></td>
<td width="125" align="center"><b><font size="2"
color="#111111">Office Phone</font></b></td>
<td width="125" align="center"><b><font size="2"
color="#111111">Cell Phone</font></b></td>
<td width="120"><b><font size="2" color="#111111">E- Mail
Address</font></b></td>
<td width="200"><b><font size="2"
color="#111111">Website</font></b></td>
</tr>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The
Database
Results component on this page is unable to display database content.
The
page must have a filename ending in '.asp', and the web must be hosted
on
a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM ""agent3"" ORDER BY ""Agent Name"" ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=6 align=left width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="Agent Name"
fp_sMenuValue="Agent Name"
fp_sColTypes="&Agent Name=200&Office=200&Office Phone=200&Cell
Phone=200&E-
Mail Address=200&Website=200&"
fp_iDisplayCols=6
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>

<tr>
<td width="216">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Agent
Name")%></font></td>
<td width="120">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Office")%></font></td>
<td width="125" align="center">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Office
Phone")%></font></td>
<td width="125" align="center">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Cell
Phone")%></font></td>
<td width="120">
<font size="2" color="#111111">
<%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail Address") & """>" &
FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%></font></td>
<td width="200">
<font size="2" color="#111111">
<%="<a
href=""" & FP_FieldLink(fp_rs,"Website") & """>" &
FP_FieldVal(fp_rs,"Website") & "</a>"%></font></td>
</tr>

</tbody>
</table>
</td>
</tr>
</table>
</center>
</div>

</body>

:

Yes. That code

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

message
You mean the HTML view tab in Front Page, all that code?

I don't see a database connection user name and password on that
page
so
I'm
not sure I've got the right info for you.

:

Ok. What I meant is that we need to see the actual code. Doing a
View
Source on an ASP page won't show server-side scripting. Please
switch
to
Code View and copy and paste all the ASP code into a reply. (delete
out
your
database connection user name and password first).

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

message
Sure, here is the page:

http://www.bdmcdaytona.com/testdux/agentroster.asp

In the right hand column, you see web site urls which work just
fine.
You
also see the word "connect". On the excel spreadsheet that feeds
this,
"connect" is the display word but when you click on it, you go to
the
target
URL.

Likewise you see e mail addresses in the next column. You also
see
the
word
"email". On the excel sheet, that is the display word that
hyperlinks
to
an
e mail address but it doesn't work on this page.

The objective is to not show each e-mail address and site url but
use
the
words "connect" and "email" to save space on the table.

:

Do you mean you want to see the word "connect" with a hyperlink?
Ex:

<a href="http://www.mysite.com">connect</a>

If so the you would modify your ASP code to show the hyperlink,
then
the
word connect. Ex:

Click to expand...

Click to expand...

Guest · Mar 7, 2007

thanks for the help, I appreciate all you did. I'll check out
spiderwebwoman, and perhaps a trip to banes and noble this weekend.

David Berry said:
Sorry I can't help more. I don't use the Database Wizards so I'm not an
expert there but If I recall, don't try and make the change in Code View.
In Design View double-click on where the code is. I think that will bring up
a box where you can change the code. See
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp for more
information on the Database Wizard

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

Daytona Steve said:

Thank you,

Unfortunately, when I make this change, its tells me that a FP Component
has
been changed and it will be over written when I save the file, so my
changes
get discarded.

I think there is a way to fix that, I just don't remember what it is. Bit
of a rookie here.

David Berry said:

Where you have Email Address change:

<%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail Address") & """>" &
FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%>

To

<a href ='<%=FP_FieldLink(fp_rs,"E- Mail Address")%>'>email</a>

Where you have web site change:

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

To

<a href='<%=FP_FieldLink(fp_rs,"Website")%>'>connect</a>

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

Here is the code: If, in your review, you see a passcode, please tell
me
where it is.

I took out as much irrelevant stuff like colors and back grounds:
<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do
not
Edit.
FP_LCID = 1033 %>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do
not
Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>New Page 1</title>
</head>

<body bgcolor="#C0C0C0">

<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0"
style="border-collapse:
collapse" bordercolor="#111111" id="AutoNumber1" width="867"
height="342">
<tr>
<td align="left" valign="top" rowspan="2" width="140"
height="144">
</td>
<td align="center"> </td>
</tr>
<tr>
<td align="right" valign="top" height="120" style="color:
#FFFF00">
<table width="725" border="1" bgcolor="#C0C0C0"
style="border-collapse: collapse" bordercolor="#111111" cellpadding="0"
cellspacing="0">
<thead>
<tr>
<td><b><font size="2" color="#111111">Agent
Name</font></b></td>
<td width="120"><b><font size="2"
color="#111111">Office</font></b></td>
<td width="125" align="center"><b><font size="2"
color="#111111">Office Phone</font></b></td>
<td width="125" align="center"><b><font size="2"
color="#111111">Cell Phone</font></b></td>
<td width="120"><b><font size="2" color="#111111">E- Mail
Address</font></b></td>
<td width="200"><b><font size="2"
color="#111111">Website</font></b></td>
</tr>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The
Database
Results component on this page is unable to display database content.
The
page must have a filename ending in '.asp', and the web must be hosted
on
a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM ""agent3"" ORDER BY ""Agent Name"" ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=6 align=left width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="Agent Name"
fp_sMenuValue="Agent Name"
fp_sColTypes="&Agent Name=200&Office=200&Office Phone=200&Cell
Phone=200&E-
Mail Address=200&Website=200&"
fp_iDisplayCols=6
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>

<tr>
<td width="216">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Agent
Name")%></font></td>
<td width="120">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Office")%></font></td>
<td width="125" align="center">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Office
Phone")%></font></td>
<td width="125" align="center">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Cell
Phone")%></font></td>
<td width="120">
<font size="2" color="#111111">
<%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail Address") & """>" &
FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%></font></td>
<td width="200">
<font size="2" color="#111111">
<%="<a
href=""" & FP_FieldLink(fp_rs,"Website") & """>" &
FP_FieldVal(fp_rs,"Website") & "</a>"%></font></td>
</tr>

</tbody>
</table>
</td>
</tr>
</table>
</center>
</div>

</body>

:

Yes. That code

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

message
You mean the HTML view tab in Front Page, all that code?

I don't see a database connection user name and password on that
page
so
I'm
not sure I've got the right info for you.

:

Ok. What I meant is that we need to see the actual code. Doing a
View
Source on an ASP page won't show server-side scripting. Please
switch
to
Code View and copy and paste all the ASP code into a reply. (delete

Click to expand...

Click to expand...

Kathleen Anderson [MVP - FrontPage] · Mar 7, 2007

Hi Steve:
You need to put that DatabaseResultColumn on a "Spooky Diet"
http://www.outfront.net/spooky/adv_drw_diet.htm

so, instead of something like this (sample code, not meant to match yours
perfectly)

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

you would do this:

<td headers="t4"><%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail Address") &
""">" & FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%></td>

The caveat is that you should wait until the page is complete before you
make this change, when you are sure that you won't have to run the DBRW
again.

--

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

Daytona Steve said:
thanks for the help, I appreciate all you did. I'll check out
spiderwebwoman, and perhaps a trip to banes and noble this weekend.

David Berry said:

Sorry I can't help more. I don't use the Database Wizards so I'm not an
expert there but If I recall, don't try and make the change in Code View.
In Design View double-click on where the code is. I think that will bring
up
a box where you can change the code. See
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp for more
information on the Database Wizard

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

Daytona Steve said:

Thank you,

Unfortunately, when I make this change, its tells me that a FP
Component
has
been changed and it will be over written when I save the file, so my
changes
get discarded.

I think there is a way to fix that, I just don't remember what it is.
Bit
of a rookie here.

:

Where you have Email Address change:

<%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail Address") & """>" &
FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%>

To

<a href ='<%=FP_FieldLink(fp_rs,"E- Mail Address")%>'>email</a>

Where you have web site change:

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

To

<a href='<%=FP_FieldLink(fp_rs,"Website")%>'>connect</a>

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

message
Here is the code: If, in your review, you see a passcode, please
tell
me
where it is.

I took out as much irrelevant stuff like colors and back grounds:
<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component.
Do
not
Edit.
FP_LCID = 1033 %>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component.
Do
not
Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>New Page 1</title>
</head>

<body bgcolor="#C0C0C0">

<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0"
style="border-collapse:
collapse" bordercolor="#111111" id="AutoNumber1" width="867"
height="342">
<tr>
<td align="left" valign="top" rowspan="2" width="140"
height="144">
</td>
<td align="center"> </td>
</tr>
<tr>
<td align="right" valign="top" height="120" style="color:
#FFFF00">
<table width="725" border="1" bgcolor="#C0C0C0"
style="border-collapse: collapse" bordercolor="#111111"
cellpadding="0"
cellspacing="0">
<thead>
<tr>
<td><b><font size="2" color="#111111">Agent
Name</font></b></td>
<td width="120"><b><font size="2"
color="#111111">Office</font></b></td>
<td width="125" align="center"><b><font size="2"
color="#111111">Office Phone</font></b></td>
<td width="125" align="center"><b><font size="2"
color="#111111">Cell Phone</font></b></td>
<td width="120"><b><font size="2" color="#111111">E- Mail
Address</font></b></td>
<td width="200"><b><font size="2"
color="#111111">Website</font></b></td>
</tr>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The
Database
Results component on this page is unable to display database
content.
The
page must have a filename ending in '.asp', and the web must be
hosted
on
a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM ""agent3"" ORDER BY ""Agent Name"" ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=6 align=left width=""100%"">No
records
returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="Agent Name"
fp_sMenuValue="Agent Name"
fp_sColTypes="&Agent Name=200&Office=200&Office Phone=200&Cell
Phone=200&E-
Mail Address=200&Website=200&"
fp_iDisplayCols=6
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>

<tr>
<td width="216">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Agent
Name")%></font></td>
<td width="120">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Office")%></font></td>
<td width="125" align="center">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Office
Phone")%></font></td>
<td width="125" align="center">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Cell
Phone")%></font></td>
<td width="120">
<font size="2" color="#111111">
<%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail Address") & """>" &
FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%></font></td>
<td width="200">
<font size="2" color="#111111">
<%="<a
href=""" & FP_FieldLink(fp_rs,"Website") & """>" &
FP_FieldVal(fp_rs,"Website") & "</a>"%></font></td>
</tr>

</tbody>
</table>
</td>
</tr>
</table>
</center>
</div>

</body>

:

Yes. That code

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

message
You mean the HTML view tab in Front Page, all that code?

I don't see a database connection user name and password on that
page
so
I'm
not sure I've got the right info for you.

:

Ok. What I meant is that we need to see the actual code. Doing
a
View
Source on an ASP page won't show server-side scripting. Please
switch
to
Code View and copy and paste all the ASP code into a reply.
(delete

Click to expand...

Click to expand...

David Berry · Mar 7, 2007

That would put him back to where he was. He doesn't want the actual address
to appear as the hyperlink text. He wants to add his own text like this:

<%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail Address") & """>" &
FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%>

To

<a href ='<%=FP_FieldLink(fp_rs,"E- Mail Address")%>'>email</a> (note the
word "email" instead of the link from the datbase again)

The problem is how to change the code without it getting overwritten.

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

Kathleen Anderson said:
Hi Steve:
You need to put that DatabaseResultColumn on a "Spooky Diet"
http://www.outfront.net/spooky/adv_drw_diet.htm

so, instead of something like this (sample code, not meant to match yours
perfectly)

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

you would do this:

<td headers="t4"><%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail Address") &
""">" & FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%></td>

The caveat is that you should wait until the page is complete before you
make this change, when you are sure that you won't have to run the DBRW
again.

--

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

Daytona Steve said:

thanks for the help, I appreciate all you did. I'll check out
spiderwebwoman, and perhaps a trip to banes and noble this weekend.

David Berry said:

Sorry I can't help more. I don't use the Database Wizards so I'm not an
expert there but If I recall, don't try and make the change in Code
View.
In Design View double-click on where the code is. I think that will
bring up
a box where you can change the code. See
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp for more
information on the Database Wizard

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

message
Thank you,

Unfortunately, when I make this change, its tells me that a FP
Component
has
been changed and it will be over written when I save the file, so my
changes
get discarded.

I think there is a way to fix that, I just don't remember what it is.
Bit
of a rookie here.

:

Where you have Email Address change:

<%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail Address") & """>" &
FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%>

To

<a href ='<%=FP_FieldLink(fp_rs,"E- Mail Address")%>'>email</a>

Where you have web site change:

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

To

<a href='<%=FP_FieldLink(fp_rs,"Website")%>'>connect</a>

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

message
Here is the code: If, in your review, you see a passcode, please
tell
me
where it is.

I took out as much irrelevant stuff like colors and back grounds:
<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage
Component. Do
not
Edit.
FP_LCID = 1033 %>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<% ' FP_ASP -- ASP Automatically generated by a Frontpage
Component. Do
not
Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>New Page 1</title>
</head>

<body bgcolor="#C0C0C0">

<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0"
style="border-collapse:
collapse" bordercolor="#111111" id="AutoNumber1" width="867"
height="342">
<tr>
<td align="left" valign="top" rowspan="2" width="140"
height="144">
</td>
<td align="center"> </td>
</tr>
<tr>
<td align="right" valign="top" height="120" style="color:
#FFFF00">
<table width="725" border="1" bgcolor="#C0C0C0"
style="border-collapse: collapse" bordercolor="#111111"
cellpadding="0"
cellspacing="0">
<thead>
<tr>
<td><b><font size="2" color="#111111">Agent
Name</font></b></td>
<td width="120"><b><font size="2"
color="#111111">Office</font></b></td>
<td width="125" align="center"><b><font size="2"
color="#111111">Office Phone</font></b></td>
<td width="125" align="center"><b><font size="2"
color="#111111">Cell Phone</font></b></td>
<td width="120"><b><font size="2" color="#111111">E-
Mail
Address</font></b></td>
<td width="200"><b><font size="2"
color="#111111">Website</font></b></td>
</tr>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The
Database
Results component on this page is unable to display database
content.
The
page must have a filename ending in '.asp', and the web must be
hosted
on
a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM ""agent3"" ORDER BY ""Agent Name"" ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=6 align=left width=""100%"">No
records
returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="Agent Name"
fp_sMenuValue="Agent Name"
fp_sColTypes="&Agent Name=200&Office=200&Office Phone=200&Cell
Phone=200&E-
Mail Address=200&Website=200&"
fp_iDisplayCols=6
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>

<tr>
<td width="216">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Agent
Name")%></font></td>
<td width="120">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Office")%></font></td>
<td width="125" align="center">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Office
Phone")%></font></td>
<td width="125" align="center">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Cell
Phone")%></font></td>
<td width="120">
<font size="2" color="#111111">
<%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail Address") & """>"
&
FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%></font></td>
<td width="200">
<font size="2" color="#111111">
<%="<a
href=""" & FP_FieldLink(fp_rs,"Website") & """>" &
FP_FieldVal(fp_rs,"Website") & "</a>"%></font></td>
</tr>

</tbody>
</table>
</td>
</tr>
</table>
</center>
</div>

</body>

:

Yes. That code

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

message
You mean the HTML view tab in Front Page, all that code?

I don't see a database connection user name and password on that
page
so
I'm
not sure I've got the right info for you.

:

Ok. What I meant is that we need to see the actual code. Doing
a
View
Source on an ASP page won't show server-side scripting. Please
switch
to
Code View and copy and paste all the ASP code into a reply.
(delete

Click to expand...

Click to expand...

Guest · Mar 8, 2007

You guys are great........

News Flash. I figured out how to make it stick, I knew I had see in
somewhere in this forum

Just deleted the grey code and it was fine.

This was the result:

<font size="2" color="#0B2476">
<a href='<%=FP_FieldLink(fp_rs,"Website")%>'>Connect to
Site</a></font></td>

Now one more problem....When the hyperlink was in the web page, I used
http:// to get it to open in a new window. How can I restore thatas the
target?

David Berry said:
That would put him back to where he was. He doesn't want the actual address
to appear as the hyperlink text. He wants to add his own text like this:

<%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail Address") & """>" &
FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%>

To

<a href ='<%=FP_FieldLink(fp_rs,"E- Mail Address")%>'>email</a> (note the
word "email" instead of the link from the datbase again)

The problem is how to change the code without it getting overwritten.

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

Kathleen Anderson said:

Hi Steve:
You need to put that DatabaseResultColumn on a "Spooky Diet"
http://www.outfront.net/spooky/adv_drw_diet.htm

so, instead of something like this (sample code, not meant to match yours
perfectly)

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

you would do this:

<td headers="t4"><%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail Address") &
""">" & FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%></td>

The caveat is that you should wait until the page is complete before you
make this change, when you are sure that you won't have to run the DBRW
again.

--

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

Daytona Steve said:

thanks for the help, I appreciate all you did. I'll check out
spiderwebwoman, and perhaps a trip to banes and noble this weekend.

:

Sorry I can't help more. I don't use the Database Wizards so I'm not an
expert there but If I recall, don't try and make the change in Code
View.
In Design View double-click on where the code is. I think that will
bring up
a box where you can change the code. See
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp for more
information on the Database Wizard

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

message
Thank you,

Unfortunately, when I make this change, its tells me that a FP
Component
has
been changed and it will be over written when I save the file, so my
changes
get discarded.

I think there is a way to fix that, I just don't remember what it is.
Bit
of a rookie here.

:

Where you have Email Address change:

<%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail Address") & """>" &
FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%>

To

<a href ='<%=FP_FieldLink(fp_rs,"E- Mail Address")%>'>email</a>

Where you have web site change:

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

To

<a href='<%=FP_FieldLink(fp_rs,"Website")%>'>connect</a>

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

message
Here is the code: If, in your review, you see a passcode, please
tell
me
where it is.

I took out as much irrelevant stuff like colors and back grounds:
<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage
Component. Do
not
Edit.
FP_LCID = 1033 %>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<% ' FP_ASP -- ASP Automatically generated by a Frontpage
Component. Do
not
Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>New Page 1</title>
</head>

<body bgcolor="#C0C0C0">

<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0"
style="border-collapse:
collapse" bordercolor="#111111" id="AutoNumber1" width="867"
height="342">
<tr>
<td align="left" valign="top" rowspan="2" width="140"
height="144">
</td>
<td align="center"> </td>
</tr>
<tr>
<td align="right" valign="top" height="120" style="color:
#FFFF00">
<table width="725" border="1" bgcolor="#C0C0C0"
style="border-collapse: collapse" bordercolor="#111111"
cellpadding="0"
cellspacing="0">
<thead>
<tr>
<td><b><font size="2" color="#111111">Agent
Name</font></b></td>
<td width="120"><b><font size="2"
color="#111111">Office</font></b></td>
<td width="125" align="center"><b><font size="2"
color="#111111">Office Phone</font></b></td>
<td width="125" align="center"><b><font size="2"
color="#111111">Cell Phone</font></b></td>
<td width="120"><b><font size="2" color="#111111">E-
Mail
Address</font></b></td>
<td width="200"><b><font size="2"
color="#111111">Website</font></b></td>
</tr>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The
Database
Results component on this page is unable to display database
content.
The
page must have a filename ending in '.asp', and the web must be
hosted
on
a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM ""agent3"" ORDER BY ""Agent Name"" ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=6 align=left width=""100%"">No
records
returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="Agent Name"
fp_sMenuValue="Agent Name"
fp_sColTypes="&Agent Name=200&Office=200&Office Phone=200&Cell
Phone=200&E-
Mail Address=200&Website=200&"
fp_iDisplayCols=6
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>

<tr>
<td width="216">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Agent
Name")%></font></td>
<td width="120">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Office")%></font></td>
<td width="125" align="center">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Office

Click to expand...

Click to expand...

Kathleen Anderson [MVP - FrontPage] · Mar 8, 2007

Daytona Steve said:
You guys are great........

News Flash. I figured out how to make it stick, I knew I had see in
somewhere in this forum

Just deleted the grey code and it was fine.

That's what I was trying to say in my example

This was the result:

<font size="2" color="#0B2476">
<a href='<%=FP_FieldLink(fp_rs,"Website")%>'>Connect to
Site</a></font></td>

Now one more problem....When the hyperlink was in the web page, I used
http:// to get it to open in a new window. How can I restore thatas the
target?

http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#new

--

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

David Berry · Mar 8, 2007

Add target='_blank'. Ex:

<a target='_blank' href='<%=FP_FieldLink(fp_rs,"Website")%>'>connect</a>

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

Daytona Steve said:
You guys are great........

News Flash. I figured out how to make it stick, I knew I had see in
somewhere in this forum

Just deleted the grey code and it was fine.

This was the result:

<font size="2" color="#0B2476">
<a href='<%=FP_FieldLink(fp_rs,"Website")%>'>Connect to
Site</a></font></td>

Now one more problem....When the hyperlink was in the web page, I used
http:// to get it to open in a new window. How can I restore thatas the
target?

David Berry said:

That would put him back to where he was. He doesn't want the actual
address
to appear as the hyperlink text. He wants to add his own text like this:

<%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail Address") & """>" &
FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%>

To

<a href ='<%=FP_FieldLink(fp_rs,"E- Mail Address")%>'>email</a> (note
the
word "email" instead of the link from the datbase again)

The problem is how to change the code without it getting overwritten.

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

Kathleen Anderson said:

Hi Steve:
You need to put that DatabaseResultColumn on a "Spooky Diet"
http://www.outfront.net/spooky/adv_drw_diet.htm

so, instead of something like this (sample code, not meant to match
yours
perfectly)

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

you would do this:

<td headers="t4"><%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail
Address") &
""">" & FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%></td>

The caveat is that you should wait until the page is complete before
you
make this change, when you are sure that you won't have to run the DBRW
again.

--

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

message
thanks for the help, I appreciate all you did. I'll check out
spiderwebwoman, and perhaps a trip to banes and noble this weekend.

:

Sorry I can't help more. I don't use the Database Wizards so I'm not
an
expert there but If I recall, don't try and make the change in Code
View.
In Design View double-click on where the code is. I think that will
bring up
a box where you can change the code. See
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp for
more
information on the Database Wizard

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

message
Thank you,

Unfortunately, when I make this change, its tells me that a FP
Component
has
been changed and it will be over written when I save the file, so
my
changes
get discarded.

I think there is a way to fix that, I just don't remember what it
is.
Bit
of a rookie here.

:

Where you have Email Address change:

<%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail Address") & """>" &
FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%>

To

<a href ='<%=FP_FieldLink(fp_rs,"E- Mail Address")%>'>email</a>

Where you have web site change:

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

To

<a href='<%=FP_FieldLink(fp_rs,"Website")%>'>connect</a>

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

message
Here is the code: If, in your review, you see a passcode,
please
tell
me
where it is.

I took out as much irrelevant stuff like colors and back
grounds:
<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage
Component. Do
not
Edit.
FP_LCID = 1033 %>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<% ' FP_ASP -- ASP Automatically generated by a Frontpage
Component. Do
not
Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>New Page 1</title>
</head>

<body bgcolor="#C0C0C0">

<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0"
style="border-collapse:
collapse" bordercolor="#111111" id="AutoNumber1" width="867"
height="342">
<tr>
<td align="left" valign="top" rowspan="2" width="140"
height="144">
</td>
<td align="center"> </td>
</tr>
<tr>
<td align="right" valign="top" height="120" style="color:
#FFFF00">
<table width="725" border="1" bgcolor="#C0C0C0"
style="border-collapse: collapse" bordercolor="#111111"
cellpadding="0"
cellspacing="0">
<thead>
<tr>
<td><b><font size="2" color="#111111">Agent
Name</font></b></td>
<td width="120"><b><font size="2"
color="#111111">Office</font></b></td>
<td width="125" align="center"><b><font size="2"
color="#111111">Office Phone</font></b></td>
<td width="125" align="center"><b><font size="2"
color="#111111">Cell Phone</font></b></td>
<td width="120"><b><font size="2" color="#111111">E-
Mail
Address</font></b></td>
<td width="200"><b><font size="2"
color="#111111">Website</font></b></td>
</tr>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color:
black;'>The
Database
Results component on this page is unable to display database
content.
The
page must have a filename ending in '.asp', and the web must be
hosted
on
a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM ""agent3"" ORDER BY ""Agent Name"" ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=6 align=left width=""100%"">No
records
returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="Agent Name"
fp_sMenuValue="Agent Name"
fp_sColTypes="&Agent Name=200&Office=200&Office Phone=200&Cell
Phone=200&E-
Mail Address=200&Website=200&"
fp_iDisplayCols=6
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>

<tr>
<td width="216">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Agent
Name")%></font></td>
<td width="120">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Office")%></font></td>
<td width="125" align="center">
<font size="2" color="#111111">
<%=FP_FieldVal(fp_rs,"Office

Click to expand...

Click to expand...

Guest · Mar 8, 2007

Perfect, it works........thank you guys, both of you for the help.

David Berry said:
Add target='_blank'. Ex:

<a target='_blank' href='<%=FP_FieldLink(fp_rs,"Website")%>'>connect</a>

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

Daytona Steve said:

You guys are great........

News Flash. I figured out how to make it stick, I knew I had see in
somewhere in this forum

Just deleted the grey code and it was fine.

This was the result:

<font size="2" color="#0B2476">
<a href='<%=FP_FieldLink(fp_rs,"Website")%>'>Connect to
Site</a></font></td>

Now one more problem....When the hyperlink was in the web page, I used
http:// to get it to open in a new window. How can I restore thatas the
target?

David Berry said:

That would put him back to where he was. He doesn't want the actual
address
to appear as the hyperlink text. He wants to add his own text like this:

<%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail Address") & """>" &
FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%>

To

<a href ='<%=FP_FieldLink(fp_rs,"E- Mail Address")%>'>email</a> (note
the
word "email" instead of the link from the datbase again)

The problem is how to change the code without it getting overwritten.

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

message Hi Steve:
You need to put that DatabaseResultColumn on a "Spooky Diet"
http://www.outfront.net/spooky/adv_drw_diet.htm

so, instead of something like this (sample code, not meant to match
yours
perfectly)

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

you would do this:

<td headers="t4"><%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail
Address") &
""">" & FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%></td>

The caveat is that you should wait until the page is complete before
you
make this change, when you are sure that you won't have to run the DBRW
again.

--

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

message
thanks for the help, I appreciate all you did. I'll check out
spiderwebwoman, and perhaps a trip to banes and noble this weekend.

:

Sorry I can't help more. I don't use the Database Wizards so I'm not
an
expert there but If I recall, don't try and make the change in Code
View.
In Design View double-click on where the code is. I think that will
bring up
a box where you can change the code. See
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp for
more
information on the Database Wizard

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

message
Thank you,

Unfortunately, when I make this change, its tells me that a FP
Component
has
been changed and it will be over written when I save the file, so
my
changes
get discarded.

I think there is a way to fix that, I just don't remember what it
is.
Bit
of a rookie here.

:

Where you have Email Address change:

<%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail Address") & """>" &
FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%>

To

<a href ='<%=FP_FieldLink(fp_rs,"E- Mail Address")%>'>email</a>

Where you have web site change:

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

To

<a href='<%=FP_FieldLink(fp_rs,"Website")%>'>connect</a>

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

message
Here is the code: If, in your review, you see a passcode,
please
tell
me
where it is.

I took out as much irrelevant stuff like colors and back
grounds:
<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage
Component. Do
not
Edit.
FP_LCID = 1033 %>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<% ' FP_ASP -- ASP Automatically generated by a Frontpage
Component. Do
not
Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>New Page 1</title>
</head>

<body bgcolor="#C0C0C0">

<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0"
style="border-collapse:
collapse" bordercolor="#111111" id="AutoNumber1" width="867"
height="342">
<tr>
<td align="left" valign="top" rowspan="2" width="140"
height="144">
</td>
<td align="center"> </td>
</tr>
<tr>
<td align="right" valign="top" height="120" style="color:
#FFFF00">
<table width="725" border="1" bgcolor="#C0C0C0"
style="border-collapse: collapse" bordercolor="#111111"
cellpadding="0"
cellspacing="0">
<thead>
<tr>
<td><b><font size="2" color="#111111">Agent
Name</font></b></td>
<td width="120"><b><font size="2"
color="#111111">Office</font></b></td>
<td width="125" align="center"><b><font size="2"
color="#111111">Office Phone</font></b></td>
<td width="125" align="center"><b><font size="2"
color="#111111">Cell Phone</font></b></td>
<td width="120"><b><font size="2" color="#111111">E-
Mail
Address</font></b></td>
<td width="200"><b><font size="2"
color="#111111">Website</font></b></td>
</tr>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color:
black;'>The
Database
Results component on this page is unable to display database
content.
The
page must have a filename ending in '.asp', and the web must be
hosted
on
a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM ""agent3"" ORDER BY ""Agent Name"" ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=6 align=left width=""100%"">No
records

Click to expand...

Click to expand...

David Berry · Mar 8, 2007

Glad to help!

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

Daytona Steve said:
Perfect, it works........thank you guys, both of you for the help.

David Berry said:

Add target='_blank'. Ex:

<a target='_blank' href='<%=FP_FieldLink(fp_rs,"Website")%>'>connect</a>

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

Daytona Steve said:

You guys are great........

News Flash. I figured out how to make it stick, I knew I had see in
somewhere in this forum

Just deleted the grey code and it was fine.

This was the result:

<font size="2" color="#0B2476">
<a href='<%=FP_FieldLink(fp_rs,"Website")%>'>Connect to
Site</a></font></td>

Now one more problem....When the hyperlink was in the web page, I used
http:// to get it to open in a new window. How can I restore thatas
the
target?

:

That would put him back to where he was. He doesn't want the actual
address
to appear as the hyperlink text. He wants to add his own text like
this:

<%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail Address") & """>" &
FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%>

To

<a href ='<%=FP_FieldLink(fp_rs,"E- Mail Address")%>'>email</a> (note
the
word "email" instead of the link from the datbase again)

The problem is how to change the code without it getting overwritten.

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

in
message Hi Steve:
You need to put that DatabaseResultColumn on a "Spooky Diet"
http://www.outfront.net/spooky/adv_drw_diet.htm

so, instead of something like this (sample code, not meant to match
yours
perfectly)

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

you would do this:

<td headers="t4"><%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail
Address") &
""">" & FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%></td>

The caveat is that you should wait until the page is complete before
you
make this change, when you are sure that you won't have to run the
DBRW
again.

--

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

message
thanks for the help, I appreciate all you did. I'll check out
spiderwebwoman, and perhaps a trip to banes and noble this weekend.

:

Sorry I can't help more. I don't use the Database Wizards so I'm
not
an
expert there but If I recall, don't try and make the change in
Code
View.
In Design View double-click on where the code is. I think that
will
bring up
a box where you can change the code. See
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp for
more
information on the Database Wizard

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

message
Thank you,

Unfortunately, when I make this change, its tells me that a FP
Component
has
been changed and it will be over written when I save the file,
so
my
changes
get discarded.

I think there is a way to fix that, I just don't remember what
it
is.
Bit
of a rookie here.

:

Where you have Email Address change:

<%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail Address") & """>"
&
FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%>

To

<a href ='<%=FP_FieldLink(fp_rs,"E- Mail Address")%>'>email</a>

Where you have web site change:

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

To

<a href='<%=FP_FieldLink(fp_rs,"Website")%>'>connect</a>

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

in
message
Here is the code: If, in your review, you see a passcode,
please
tell
me
where it is.

I took out as much irrelevant stuff like colors and back
grounds:
<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage
Component. Do
not
Edit.
FP_LCID = 1033 %>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<% ' FP_ASP -- ASP Automatically generated by a Frontpage
Component. Do
not
Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>New Page 1</title>
</head>

<body bgcolor="#C0C0C0">

<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0"
style="border-collapse:
collapse" bordercolor="#111111" id="AutoNumber1" width="867"
height="342">
<tr>
<td align="left" valign="top" rowspan="2" width="140"
height="144">
</td>
<td align="center"> </td>
</tr>
<tr>
<td align="right" valign="top" height="120"
style="color:
#FFFF00">
<table width="725" border="1" bgcolor="#C0C0C0"
style="border-collapse: collapse" bordercolor="#111111"
cellpadding="0"
cellspacing="0">
<thead>
<tr>
<td><b><font size="2" color="#111111">Agent
Name</font></b></td>
<td width="120"><b><font size="2"
color="#111111">Office</font></b></td>
<td width="125" align="center"><b><font size="2"
color="#111111">Office Phone</font></b></td>
<td width="125" align="center"><b><font size="2"
color="#111111">Cell Phone</font></b></td>
<td width="120"><b><font size="2"
color="#111111">E-
Mail
Address</font></b></td>
<td width="200"><b><font size="2"
color="#111111">Website</font></b></td>
</tr>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color:
black;'>The
Database
Results component on this page is unable to display database
content.
The
page must have a filename ending in '.asp', and the web must
be
hosted
on
a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM ""agent3"" ORDER BY ""Agent Name""
ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=6 align=left width=""100%"">No
records

Click to expand...

Click to expand...

Kathleen Anderson [MVP - FrontPage] · Mar 8, 2007

Me, too

--

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

David Berry said:
Glad to help!

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

Daytona Steve said:

Perfect, it works........thank you guys, both of you for the help.

David Berry said:

Add target='_blank'. Ex:

<a target='_blank' href='<%=FP_FieldLink(fp_rs,"Website")%>'>connect</a>

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

message
You guys are great........

News Flash. I figured out how to make it stick, I knew I had see in
somewhere in this forum

Just deleted the grey code and it was fine.

This was the result:

<font size="2" color="#0B2476">
<a href='<%=FP_FieldLink(fp_rs,"Website")%>'>Connect to
Site</a></font></td>

Now one more problem....When the hyperlink was in the web page, I used
http:// to get it to open in a new window. How can I restore thatas
the
target?

:

That would put him back to where he was. He doesn't want the actual
address
to appear as the hyperlink text. He wants to add his own text like
this:

<%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail Address") & """>" &
FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%>

To

<a href ='<%=FP_FieldLink(fp_rs,"E- Mail Address")%>'>email</a>
(note
the
word "email" instead of the link from the datbase again)

The problem is how to change the code without it getting overwritten.

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

in
message Hi Steve:
You need to put that DatabaseResultColumn on a "Spooky Diet"
http://www.outfront.net/spooky/adv_drw_diet.htm

so, instead of something like this (sample code, not meant to match
yours
perfectly)

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

you would do this:

<td headers="t4"><%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail
Address") &
""">" & FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%></td>

The caveat is that you should wait until the page is complete
before
you
make this change, when you are sure that you won't have to run the
DBRW
again.

--

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

message
thanks for the help, I appreciate all you did. I'll check out
spiderwebwoman, and perhaps a trip to banes and noble this
weekend.

:

Sorry I can't help more. I don't use the Database Wizards so I'm
not
an
expert there but If I recall, don't try and make the change in
Code
View.
In Design View double-click on where the code is. I think that
will
bring up
a box where you can change the code. See
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp for
more
information on the Database Wizard

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

message
Thank you,

Unfortunately, when I make this change, its tells me that a FP
Component
has
been changed and it will be over written when I save the file,
so
my
changes
get discarded.

I think there is a way to fix that, I just don't remember what
it
is.
Bit
of a rookie here.

:

Where you have Email Address change:

<%="<a href=""" & FP_FieldLink(fp_rs,"E- Mail Address") &
""">" &
FP_FieldVal(fp_rs,"E- Mail Address") & "</a>"%>

To

<a href ='<%=FP_FieldLink(fp_rs,"E- Mail
Address")%>'>email</a>

Where you have web site change:

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

To

<a href='<%=FP_FieldLink(fp_rs,"Website")%>'>connect</a>

--
David Berry
FrontPage Support: http://www.frontpagemvps.com/

in
message
Here is the code: If, in your review, you see a passcode,
please
tell
me
where it is.

I took out as much irrelevant stuff like colors and back
grounds:
<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage
Component. Do
not
Edit.
FP_LCID = 1033 %>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<% ' FP_ASP -- ASP Automatically generated by a Frontpage
Component. Do
not
Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>New Page 1</title>
</head>

<body bgcolor="#C0C0C0">

<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0"
style="border-collapse:
collapse" bordercolor="#111111" id="AutoNumber1" width="867"
height="342">
<tr>
<td align="left" valign="top" rowspan="2" width="140"
height="144">
</td>
<td align="center"> </td>
</tr>
<tr>
<td align="right" valign="top" height="120"
style="color:
#FFFF00">
<table width="725" border="1" bgcolor="#C0C0C0"
style="border-collapse: collapse" bordercolor="#111111"
cellpadding="0"
cellspacing="0">
<thead>
<tr>
<td><b><font size="2" color="#111111">Agent
Name</font></b></td>
<td width="120"><b><font size="2"
color="#111111">Office</font></b></td>
<td width="125" align="center"><b><font size="2"
color="#111111">Office Phone</font></b></td>
<td width="125" align="center"><b><font size="2"
color="#111111">Cell Phone</font></b></td>
<td width="120"><b><font size="2"
color="#111111">E-
Mail
Address</font></b></td>
<td width="200"><b><font size="2"
color="#111111">Website</font></b></td>
</tr>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color:
black;'>The
Database
Results component on this page is unable to display database
content.
The
page must have a filename ending in '.asp', and the web must
be
hosted
on
a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM ""agent3"" ORDER BY ""Agent Name""
ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=6 align=left
width=""100%"">No
records

Click to expand...

Click to expand...

Hyperlinks	7	Aug 30, 2007
publish relative references (hyperlinks)	4	May 16, 2007
Design view hyperlinks shortcut	1	Feb 21, 2008
Activating hyperlinks	3	Jun 17, 2014
Hyperlinks and inline frames	1	Sep 23, 2006
Open specific hyperlink (accept) automatically in email with outlook	0	Oct 7, 2021
recalculate hyperlinks	4	Oct 15, 2007
Will not auto open .jpg	1	Jan 25, 2020

data base hyperlinks

Guest

David Berry

Guest

David Berry

Guest

David Berry

Guest

David Berry

Guest

David Berry

Guest

Kathleen Anderson [MVP - FrontPage]

David Berry

Guest

Kathleen Anderson [MVP - FrontPage]

David Berry

Guest

David Berry

Kathleen Anderson [MVP - FrontPage]

Ask a Question

Similar Threads