Adobe Dreamweaver CS3 User Manual
Page 555
DREAMWEAVER CS3
User Guide
548
2
Select Windows > Bindings to display the Bindings panel.
3
In the Bindings panel, click the Plus (+) button and select Recordset (Query) from the pop-up menu.
The simple Recordset dialog box appears. If you are developing a ColdFusion or ASP.NET site, the Recordset dialog
box is slightly different. (If the advanced Recordset dialog appears instead, click the Simple button to switch to the
simple Recordset dialog box.)
4
Complete the Recordset dialog box for your document type.
For instructions, see the topics below.
5
Click the Test button to execute the query and ensure that it retrieves the information you intended.
If you defined a filter that uses parameters input by users, enter a value in the Test Value box, and click OK. If an
instance of the recordset is successfully created, a table appears that displays data extracted from the recordset.
6
Click OK to add the recordset to the list of available content sources in the Bindings panel.
See also
“Database connections for ASP.NET developers” on page 518
Options for the simple Recordset dialog box (PHP, ASP, JSP)
1
In the Name box, enter a name for the recordset.
A common practice is to add the prefix rs to recordset names to distinguish them from other object names in the
code, for example:
rsPressReleases
.
Recordset names can only contain letters, numbers, and the underscore character (_). You cannot use special
characters or spaces.
2
Select a connection from the Connection pop-up menu.
If no connection appears in the list, click Define to create one.
3
In the Table pop-up menu, select the database table that will provide data to the recordset.
The pop-up menu displays all tables in the specified database.
4
To include a subset of the table’s columns in the recordset, click Selected and choose the desired columns by
Control-clicking (Windows) or Command-clicking (Macintosh) them in the list.
5
To further limit the records returned from the table, complete the Filter section:
•
From the first pop-up menu, select a column in the database table to compare against a test value you define.
•
From the second pop-up menu, select a conditional expression to compare the selected value in each record
against the test value.
•
From the third pop-up menu, select Entered Value.
•
In the box, enter the test value.
If the specified value in a record meets your filtering condition, the record is included the recordset.
6
(Optional) To sort the records, select a column to sort by, and then specify whether the records should be sorted
in ascending order (1, 2, 3... or A, B, C...) or descending order.
7
Click Test to connect to the database and create an instance of the data source, and click OK to close the data
source.
September 4, 2007