Adding Database Functionality - New Perspectives on Adobe Dreamweaver CS5, Comprehensive - page 542

information that a Web application server needs to connect to a database. The connec-
tion string begins and ends with quotation marks. The connection string has two parts:

Provider. The name of the interface that provides ASP pages with access to the specifi c
type of database you are using.
Data Source. The complete path to the database on the server.

The Insert Record behavior enables you to specify what will happen to the information
collected from the Web page (in this case, when the form is submitted). You can specify
in which database the data will be placed, where the data will be stored in the database,
what columns will be included, and so on. It also lets you select the page that appears in
the browser window once the form is submitted.
You'll create a recordset for the contact.asp page.

To create the recordset for the contact.asp page:

◗

1. At the top of the Server Behaviors panel, click the Add behavior button , and
then click Recordset (Query) . The Recordset dialog box opens. See Figure 9-28.

Figure 9-28 Recordset dialog box

type a name for the recordset

click to select the
database for the
recordset

click to switch to
Advanced mode

◗

2. Click the Advanced button to switch the Recordset dialog box to Advanced mode,
and then click the Define button next to the Connection box. The Connections for
Site 'NextBest Fest' dialog box opens.
Click the New button, and then click Custom Connection String . The Custom
Connection String dialog box opens. See Figure 9-29.