Database Results

[Andy]

I have a database with a list of staff and there various levels of
experience which I want to display on a web page. How can I create a
hyperlink that points to a specific record in my database.

Any help would be appreciated.......Thanks!

 

[Jim Buyens]

-----Original Message-----

I have a database with a list of staff and there various
levels of experience which I want to display on a web
page. How can I create a hyperlink that points to a
specific record in my database.

Append a query string parameter such as ?staffid=1234 to
your URL, whre stafid is any name you want and 1234 is
the key to some individual's record. For example, link to
staffinfo.asp?staffid=1234.

Then, on the staffinfo.asp (or whatever) page, run the
Database Results Wizard and on page 3, Click More
Options, Criteria, and Add.

When the Add criteria dialog box appears:
o Set Field Name to the key field corresponding to 1234.
o Set Comparison to Equals.
o Set Value to staffid (or whatever name you decided
to use).
o Select the Use This Search Form Field box.

Click OK, OK, OK, then Next, Next, Finish.

Jim Buyens
Microsoft FrontPage MVP
(e-mail address removed)
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*

 

[Andy]

Thanks Jim, great help but was also wondering instead of having to type a
name in to find a certain staff member can I setup a hyperlink that will
take me to that persons details?

Thanks again,

Andy

 

[Jim Buyens]

Thanks Jim, great help but was also wondering instead of having to type a
name in to find a certain staff member can I setup a hyperlink that will
take me to that persons details?

Right, you code the hyperlink:

<a href="staffinfo.asp?staffid=1234">Andrew</a>

and if 1234 is Andrew's id in the database, that's the record the
Database Results Region will display (provided you configured the
Database Results Region as I described in my first post.)

If this isn't the type of hyperlink you want, you'll have to explain
what kind you *do* want.

Jim Buyens
Microsoft FrontPage MVP
(e-mail address removed)
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*

 

[Andy]

Cheers Jim!!! Worked a treat!