It's a good time to pray for victims of September 11, 2001 terrorist activities!
'
Geneonet

Use a Form to Post Information to a Database

Previous versions of FrontPage required custom ASP script to post information to a database. FrontPage 2000 has expanded its support for database management. To post information to a database using an HTML form, follow these steps:

  1. On the File menu, point to New, and click Page.

  2. On the Insert menu, point to Form, and click Form.




    This will add Submit and Reset buttons surrounded by the form, represented by a dashed-line bounding box.

  3. With the insertion point in front of the Submit button, type "First Name: " (without the quotation marks). On the Insert menu, point to Form, and click One-Line Text Box.



    Right-click the text box, and click Form Field Properties. In the Name box, type "FirstName" (without the quotation marks), and click OK. Select the text and the text box.

    On the Insert menu, point to Form, and click Label

    Press ENTER to move the insertion point down two lines.

  4. Repeat step 3 until your form looks similar to the following:

    First Name:     Email Address:

    Last Name:     Phone Number:

    Title:

    City: State:  

    Use the following names for the form fields:

    LastName, City, State, Email, Phone, Title, City, State

  5. Right-click anywhere within the form, and click Form Properties.

  6. In the Form Properties dialog box, click the Send to database button, and click Options.



  7. In the Options for Saving Results to Database dialog box, click to select Volcano2 in the Database Connection to Use list, and then click the Saved Fields tab.



  8. Click to select City in the Form Field column, and click Modify.



  9. In the Modify Field dialog box, click OK.

  10. Repeat steps 8 and 9 for each item in the Form Field column until your Saved Fields tab looks similar to the following:



  11. Click OK.

  12. On the File menu, click Save As. Save the page as "post.asp" (without the quotation marks).

Top


© 1999 Microsoft and/or its suppliers. All rights reserved. Terms of Use.

You are visitor number
Hit Counter
Since November 20, 1999

Instant Decision - Card Design Option

125x125button
Created by Jim Needham
NextCard Visa

©Vector Graphics 1995

Revised: January 14, 2005
Best viewed with
 

Shop at Amazon.com!