Adobe Dreamweaver CC 2015 - Manual (Page 573)

566
Dynamic sites, pages and web forms
Last updated 6/3/2015
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.
Options for the simple Recordset dialog box (PHP, ASP)
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.
A table appears displaying the returned data. Each row contains a record and each column represents a field in that
record.
8 Click OK. The newly defined recordset appears in the Bindings panel.