Retrieve Information Using a Hyperlink with Parameters

		Microsoft Support Online \| Resources \| Contact Us

Home \| Create Database With Form \| ODBC \| ADO \| Form Post \| Form Retrieve \| Hyperlink Retrieve \| Hyperlink using Field \| Display Image \| FrontPageHowTo Home

Retrieve Information Using a Hyperlink with Parameters

In FrontPage 2000, you can pass information from one page to another as a hyperlink with
parameters. You can use this technique to pass information to a page that contains
a Database Results Wizard and display specific records from a database.

Create the Hyperlink Page

With the following example, you will create a page that displays the ID number, first name, and
last name of each employee in the database. Using a hyperlink with the ID number, you will
pass the ID number as a parameter to another page to display the full record of the individual
employee. To do this, follow these steps:

In Folders view, create two new pages. Name these pages "employees.asp" (without the quotation marks) and "record.asp" (without the quotation marks).
Open employees.asp in page view.
On the Insert menu, point to Database, and click Results.
In Step 1 of the Database Results Wizard, click to select the Use an existing database connection button. Click to select Volcano2 from the list.

Click Next.
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.
In Step 3 of the Database Results Wizard, click Edit List.
In the Displayed Fields dialog box, click to select all of the items in the Displayed fields list except ID, FirstName, and LastName. Click Remove.

Click OK.
In Step 4 of the Database Results Wizard, click Next.
In Step 5 of the Database Results Wizard, click the Display all records together button, and click Finish.
Right-click <<ID>> in the ID column of the results table, and click Hyperlink.
In the Create Hyperlink dialog box, click to select record.asp, and click Parameters.
In the Hyperlink Parameters dialog box, click Add.
In the Add Parameter dialog box, click to select ID in the Name list, and click OK.

Click OK until you return to your page.
Save and close employees.asp.

The <<ID>> will now be a hyperlink. When you view the page in a Web browser, the list of ID numbers will be hyperlinks. When you click an ID number, the ID will be passed to the next page. The next page will display all of the information for this ID number.

Continue to Next Set of Steps

Top