Operation Manual
538
USING DREAMWEAVER
Making pages dynamic
Last updated 3/28/2012
A table appears displaying the returned data. Each row contains a record and each column represents a field in that
record. Click OK to close the test recordset.
10 Click OK. The newly defined ColdFusion recordset appears in the Bindings panel.
Define an advanced recordset by writing SQL
Write your own SQL statements by using the advanced Recordset dialog box, or create a SQL statement by using the
graphical Database Items tree.
1 In the Document window, open the page that will use the recordset.
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 advanced Recordset dialog box appears. If you are developing a ColdFusion site, the Recordset dialog box is
slightly different. (If the simple Recordset dialog box appears instead, switch to the advanced Recordset dialog box by
clicking the Advanced button.)
4 Complete the advanced Recordset dialog box.
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.
More Help topics
“Create SQL queries using the Database Items tree” on page 541
“Database connections for ASP developers” on page 511
“Database connections for PHP developers” on page 518
“Defining sources of dynamic content” on page 536
“Add a stored procedure (ColdFusion)” on page 606
SQL primer
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.