Microsoft KB Archive/280328

= HOW TO: Create a Table of Contents to Filter Database Results Using ASP with FrontPage 2000 =

Article ID: 280328

Article Last Modified on 6/18/2005

-

APPLIES TO


 * Microsoft FrontPage 2000 Standard Edition

-



This article was previously published under Q280328



IN THIS TASK
SUMMARY
 * Table of Contents Example



SUMMARY
This article describes how to dynamically create a table of contents with Active Server Pages (ASP) for use with the Database Results Wizard.

NOTE: This article uses custom Dynamic Hypertext Markup Language (DHTML) and cascading style sheets (CSS) that may not be available in all browsers.

For more information about this topic, click Microsoft FrontPage Help on the Help menu, type compatibility in the Answer Wizard, and then click Search to view the topic.

Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements.

NOTE: You may receive an error message if you copy the examples directly from this article and paste them into FrontPage. The angle brackets may appear as escaped HTML code. To work around this behavior, paste the script into a blank Notepad document, and then copy it from Notepad before you paste it into FrontPage.

back to the top

Table of Contents Example
The following steps demonstrate how to create a dynamic table of contents for the Database Results Wizard to use.

 Open a Web site on a Microsoft Internet Information Services-based Web server. Start a new page, and switch to HTML view.  Remove all the existing HTML, and type the following code:

.normal { BACKGROUND-COLOR: #cccccc; COLOR: #000000 } .hover  { BACKGROUND-COLOR: #0000ff; COLOR: #ffffff } .current { BACKGROUND-COLOR: #ff0000; COLOR: #ffffff }  Switch back to normal view. On the Insert menu, click Database and then click Results. Select Sample Database Connection (Northwind), and then click Next. Select Customers as the record source, and then click Next.</li> Click the More Options button.</li> Click the Criteria button.</li> Click the Add button.</li> Select CustomerID for the Field Name.</li> Select Begins With for the Comparison.</li> Click OK three times.</li> Click Next twice.</li> Clear the Add search form check box.</li> Click Finish.</li> Save the page as dbtoc.asp in your Web site.</li> Click Preview in Browser on the standard toolbar in FrontPage.</li></ol>

When a user browses this page by using HTTP, the page displays a table of contents, followed by the output of the FrontPage Database Results Wizard. When a user clicks a button in the table of contents, the database is filtered for data that begins with the letter that is clicked.

back to the top

Additional query words: front page

Keywords: kbhowto kbhowtomaster KB280328

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.