Database Integration
Want to send form results to a database? You will need a custom
script.
Let me just get the hard part over with first. And please
don't shoot the messenger ... that's me, by the way.
While FrontPage will create forms that can input data to a database, you
or someone you hire must write the custom script to send form results to the database.
FrontPage's built in database connectivity supports extracting not inputting data.
Using the Database Region Wizard
Using the FrontPage Database Region Wizard, you can submit SQL queries to
an ODBC-compliant database accessible from the Web server computer. When a user visits
your Web site and submits search criteria, the query runs based on the values of SQL
parameter fields. The results are then combined with an Active Server Page, which acts as
a custom form handler, and returned to the Web browser for display.
An Active Server Page is an HTML document that contains embedded server-side scripting.
Web servers compatible with ASP can execute these server-side scripts. On the client side,
an ASP is a standard HTML document, viewable on any platform using any Web browser.
Before you can integrate a database into a FrontPage web, you must follow a series of
steps that take place outside of FrontPage. These include configuring your Web server and
workstation, and building (and modifying) Structured Query Language (SQL) queries in a
database management tool such as Microsoft Access. You can use any database with an
available Open Data Base Connectivity (ODBC) compliant driver to publish data on a Web
site.
More Soon ... This is a work in progress
[ Home ][ Web Design Basics ] [ Design & Maintenance ] [ Creating Pages ] [ Features & Functions ] [ Index ][ Forms ] [ FrontPage Components ] [ Active Elements ] [ Database ]
Web Design Basics |
Site Design & Maintenance | Creating
Pages | Features & Functions | Index | Photo Gallery | Feedback