Operation Manual
539
USING DREAMWEAVER
Making pages dynamic
Last updated 3/28/2012
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:
Form parameters in the Run-time Value column:
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.
If successful, a table appears displaying the data in your recordset. Each row contains a record and each column
represents a field in that record. Click OK to clear the recordset.
6 If satisfied with your work, click OK.
Options for the advanced Recordset dialog box (ColdFusion)
Use the advanced Recordset dialog box to write custom SQL queries, or use the Database Items tree to author SQL
queries using a point-and-click interface.
1 In the Name box, enter a name for the recordset.
Server Model Run-Time value expression for URL parameter
ASP Request.QueryString(“formFieldName”)
PHP $_GET['formFieldName']
Server Model Run-Time value expression for form parameter
ASP Request.Form(“formFieldName”)
PHP $_POST['formFieldName']