Creating ASP File       Creating Forms        Viewing Your ASP

How To Create an Active Server Page (ASP)

• See a movie demonstration on how to create an Active Server Page
• See steps to create an Active Server Page
• See some ASP samples

   To Create an Active Server Page

   1. In the FrontPage Editor, create a new page, and type some text for a title. (The following
        example will contain the title of "Volcano Employees".)
    2. On the Insert menu, point to Database and click Database Region Wizard.

   3. In the ODBC Data Source Name (DSN) text box, type Volcano.
   4. Click Next.
   5. In the Enter SQL string for the query text box, enter the following SQL:

       SELECT FirstName, LastName FROM Employees WHERE FirstName = '%%FirstName%%'

   6. Click Next.
  
    In the Database Region Wizard, you will now enter the query field names as they appear in
    Microsoft Access, while you are in Design View.

   7. Click Add Field.
   8. Type FirstName in the text box and click OK.
   9. Repeat Steps 7 and 8 for the Field name LastName.

   10. Click OK.
  
   NOTE: You may recieve the following message:

   "For the database region to work, this page must be saved in a folder that allows
     scripts and ASP pages to be run. Use the Edit Properties command in the FrontPage
     Explorer to change this setting for the folder in which you save this page."

    Click OK in this message.

Save your page as display.asp into the Scripts folder to complete the creation of the Active Server Page.

   Examples:

   For more information and sample code, see the ASP Samples page.