Adobe Dreamweaver CC 2014 v.13 - Manual (Page 613)

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, the Test button displays the Test Value dialog box. Enter a value in the Test Value
box and click OK. If an instance of the recordset is successfully created, a table displaying the data from the recordset appears.
6. Click OK to add the recordset to the list of available content sources in the Bindings panel.
Options for the advanced Recordset dialog box (PHP, ASP)
Define a recordset as a source of dynamic content by writing a custom SQL statement, or by creating a SQL statement using the graphical
Database Items tree.
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:
rsPressRelease
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.
3. Enter a SQL statement in the SQL text area or use the graphical Database Items tree at the bottom of the dialog box to build a SQL
statement from the chosen recordset.
Do the following to use the Database Items tree to build the SQL statement:
Ensure the SQL text area is blank.
Expand the branches of the tree until you find the database object you need—a column in a table, for example, or a stored procedure in
the database.
Select the database object and click one of the buttons on the right side of the tree.
For example, if you select a table column, the available buttons are SELECT, WHERE, and ORDER BY. Click one of the buttons to add
the associated clause to your SQL statement.
You can also use a predefined SQL statement in a stored procedure by selecting the stored procedure from the Database Items tree and
clicking the Procedure button. Dreamweaver automatically fills in the SQL and Variable areas.
4. If the SQL statement contains variables, define their values in the Variables area by clicking the Plus (+) button and entering the variable’s
name, type (integer, text, date, or floating point number), default value (the value the variable should take if no run-time value is returned),
and run-time value.
Note: When using variables in a SQL statement in PHP, Dreamweaver automatically adds a leading dollar sign to the variable name, so
you should omit the dollar sign (e.g., colname, instead of $colname).
If the SQL statement contains variables, make sure the Default Value column of the Variables box contains valid test values.
The run-time value is usually a URL or form parameter entered by a user in an HTML form field.
URL parameters in the Run-time Value column:
Server Model Run-Time value expression for URL parameter
ASP Request.QueryString(“formFieldName”)
PHP $_GET['formFieldName']
Form parameters in the Run-time Value column:
Server Model Run-Time value expression for form parameter
ASP Request.Form(“formFieldName”)
PHP $_POST['formFieldName']
5. Click Test to connect to the database and create an instance of the recordset.
If the SQL statement contains variables, make sure the Default Value column of the Variables box contains valid test values before clicking
Test.
606