Using the Database Results Wizard with ASP -

05 Sep 2010

Support Center » Knowledgebase » Using the Database Results Wizard with ASP

	Using the Database Results Wizard with ASP

Solution By using the Database Results Wizard on a Web site hosted on a server running Active Server Pages (ASP) (ASP: Active Server Pages. A server-side scripting technology that is used to create dynamic interactive Web applications. An ASP file is an HTML page containing scripts that are processed by a Web server before being sent to a browser.), you can create Web pages to view and search database records.

Security Use this feature with caution. Sensitive or confidential information could be revealed to others, such as other authors of your Web site, or site visitors on the Internet or your intranet.

Start the Database Results Wizard
On the Insert menu, point to Database, and then click Results.

Specify ASP as the server technology and the database connection

In the FrontPage has detected that your page will display best using area, clickASP, so that your pages will work correctly on a Web site located on a server running ASP.

Specify the database connection you want.

Specify the record source
Do one of the following:
To select the table or view you want, click Record Source.
To create a custom query, click Custom Query, and then click Edit.

Specify the fields to be displayed on the database results page
You can do one or more of the following:
To exclude fields from appearing in the database results region or to change the order in which they appear, click Edit List.
To filter, limit, or sort the database results, to set up a search form, or to provide default values for the search, click More Options.

Specify the formatting options for the database results region
You can format the database results region as a table, a list, or a drop-down list.

Specify whether to display all records together or to split them into groups

You can do the following:
If you specified to display the records as a table or a list on the previous page of the wizard, you can specify whether to display all of the records together or to split them into groups of records with buttons to move forward or backward through the records.

Additionally, if you specified that you wanted to use a field as a search field in the previous page of the wizard, you can specify here that you want to add a search form to your page.

Article Details

Article ID:

Created On:

04 Sep 2006 06:59 PM