How to return records from a query as a hyperlink by using ASP in FrontPage 2000 (205980)

SUMMARY

This article describes how to return the results from a query as a hyperlink using FrontPage and Active Server Pages (ASP).

back to the top

Query Information from Microsoft Access Database Using ASP

Use the following procedures to query information from an MS Access database with an ASP web page. After a web project is created you can import an MS Access database to the web so you can make it accessible to use with the ASP web page.

back to the top

Format Results of a Query as a Hyperlink

1. Start Microsoft Access 2000
2. In the Microsoft Access dialog box, click Blank Database and click OK.
3. In the File name box, type: "Asplink.mdb" (without the quotes) and click Create.
4. Click the Tables tab. Double-click Create Table in Design View.
5. In the Field Name box, type Hyperlink.
6. On the View menu, click Datasheet View.
7. When you are prompted to save, click Yes, name the table: "Hyperlink" (without the quotes), and then click OK.
8. If you are asked to create a primary key, click Yes.
9. In the Hyperlink box, type the following record into the database:

   <a href="hyperlink">TextToDisplay</a>
   						

   where hyperlink is the URL this record will link to and TextToDisplay is the display text for the record. For example, if you want to link to the Microsoft Home Page, you can type the following:

   <a href="http://www.microsoft.com">Microsoft</a>
   						

10. On the File menu, click Exit.

back to the top

Create a Web

1. Start FrontPage and create a new Web.
2. On the File menu, point to New, and click Web.
3. Click One Page Web.
4. In the Please specify a location of the new web box, type the following:

   http://localhost/ASPLink
   						

5. Click OK

back to the top

Import Database into Current Web

1. On the File menu, click Import.
2. Click Add File.
3. Select the asplink.mdb file from the file list, and click Open
4. Click OK.
5. When you are prompted to create a new database connection, type: "ASPLink" for the name (without the quotes), and click Yes.
6. Click Yes again. You have now added the database to your web. This allows your web to have access to the database once you have created your ASP page.

back to the top

Create the ASP Page

In FrontPage, create the ASP page.

1. On the View menu, click Page.
2. On the File menu, point to New, and then click the page.
3. Double-click Normal Page.
4. On the Insert menu, point to Database, and click Results.
5. In Step One of the Database Results Wizard, click to select Use an existing database connection, and select ASPLink from the list.
6. Click Next.
7. Select the Hyperlink table from the Record Source list, and click Next.
8. Click Next twice, then click Finish.
9. Right Click the <<Hyperlink>> column, and select Database Column Value Properties.
10. Click to select the Column value contains HTML check box, and click OK.
11. Save the Page.
12. On the File menu, click Preview in Browser.
13. Click Microsoft Internet Explorer 5.0, and then click Preview.

back to the top