Create an Active Hyperlink Using a Database Field

In FrontPage 2000, you can create a hyperlink based on database field data. The sample
database volcano2000 has a field called URL. You can use this to create a table of hyperlinks.

To do this, follow these steps:

1. Create a new page, and name it "emp_links.asp" (without the quotation marks).
   
   
2. On the Insert menu, point to Database, and click Results.
   
   
3. In Step 1 of the Database Results Wizard, click the Use an existing database connection button, and click to select Volcano2 from the list. Click Next.
   
   
4. In Step 2 of the Database Results Wizard, make sure the Record source option is selected and Employees is selected from the list. Click Next.
   
   
5. In Step 3 of the Database Results Wizard, click Edit List.
   
   
6. In the Displayed Fields dialog box, click to select all of the items in the Displayed Fields list except for First Name, LastName, and URL, and click Remove.
   
   
7. In Step 4 of the Database Results Wizard, click Next.
   
   
8. In Step 5 of the Database Results Wizard, click to select the Display all records together option, and click Finish.
   
   
9. Right-click <<URL>> in the URL column of the results table, and click Hyperlink.
   
   
10. In the Create Hyperlink dialog box, click Parameters.
    
    
11. In the Hyperlink Parameters dialog box, clear the Path box.
    
    
12. Click Insert Field Value, and click to select URL.
    
    
13. To return to your Web page, click OK twice. View your page in your Web browser.

Top