MACROMEDIA COLDFUSION MX 61-DEVELOPING COLDFUSION MX, Develop Manual

Page: 423 / 860

Writing queries using an editor 423
The Simple Recordset dialog box appears:
4
Complete the dialog box.
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 text box and click OK. If an instance of the
record set is successfully created, a table displaying the data from your record set appears.
6
Click OK to add the record set to the list of available content sources in the Data bindings panel.
If you prefer to write your own SQL statements, or need to create more complex queries then the
Simple Recordset dialog box allows, you can define record sets using the Advanced Recordset
dialog box
Creating an advanced record set by writing SQL :
1
In the Dreamweaver MX Document window, open the page that will use the record set.
2
Choose Windows > Data Bindings to display the Data Bindings panel.
3
In the Data Bindings panel, click the Plus (+) button and select Recordset (Query) from the
pop-up menu.
If the Simple Recordset dialog box appears, switch to the Advanced Recordset dialog box by
clicking the Advanced button.