Formatting Hyperlinks in a Frontpage ASP Site

Popular Searches: FrontPage Hosting | FrontPage Templates | FrontPage Training | Free FrontPage

Logged in as: Guest

Printable Version

All Forums >>Taking FrontPage Further >>FrontPage and Databases >>

Page: [1]

Name:

Message

<< Newer Topic Older Topic >>

JAY5817

Posts: 3
Member since: 5/29/2010

Formatting Hyperlinks in a Frontpage...

I have a Hyperlink field in an Access 2000 database. After entering a web address, I click the right mouse and get to the Edit Hyperlink dialog. The dialog has the following options:

1. Type Text to display
2. Type the file or Web page name

I type the page to display and the web address. For instance:
Text to display = John Doe
Web Page = http://en.wikipedia.org/wiki/John_Doe

This worked perfectly in Access but when I connected it to my webpage, the hyperlink shows as http://en.wikipedia.org/wiki/John_Doe instead of John Doe. How can I make it to display only John Doe instead of the full URL. I use Frontpage 2000 and connected to the database via the Database Result Wizard.

P.S: My ASP webpage recognises the hyperlink and it works when clicked. I just want to display the name and not the full URL.

Thanks for your assistance.

Report Abuse | Date: 5/30/2010 7:24:12 AM

TexasWebDevelopers

Posts: 7242
Member since: 9/24/2002
From: USA

RE: Formatting Hyperlinks in a Front... (in reply to JAY5817)

data in - data out. You ned two fields..one is the url, the other is the text you want displayed.

<a href="url"> url_text </a>
<a href="<%=url%>"> <%=url_text%> </a>

_____________________________

Report Abuse | Date: 5/30/2010 8:35:08 AM

JAY5817

Posts: 3
Member since: 5/29/2010

RE: Formatting Hyperlinks in a Front... (in reply to JAY5817)

Hi TexasWebDevelopers,

Thanks for your response. I have now created two fieds, BioLink (URL) and BioLinkText (text). How do I incorporate it into my SQL statement to accomplish the task. Below is the SQL statement:

SELECT * FROM MyQryCategoryName WHERE (CategoryID = ::CategoryID::) ORDER BY LastName ASC

Report Abuse | Date: 5/30/2010 10:10:49 AM

JAY5817

Posts: 3
Member since: 5/29/2010

RE: Formatting Hyperlinks in a Front... (in reply to JAY5817)

RESOLVED.

I have finally figured out how to solve this problem. Just like TexasWebDevelopers suggested, I created a text field in additon to the hyperlink field. I did not touch the query below. I left it as it is.

SELECT * FROM MyQryCategoryName WHERE (CategoryID = ::CategoryID::) ORDER BY LastName ASC

But in Frontpage, I right clicked on the text field and clicked "Hyperlink Properties", then "Parameters" then "Insert Field Value" and then selected the Hyperlink/URL field itself. That's it. When I uploaded the file, the URL for the text field appear as John Doe, instead of www.JohnDoe.com. When you click on John Doe, it still takes you to www.JohnDoe.com which is what I want.

Report Abuse | Date: 5/30/2010 12:22:36 PM