Dreamweaver MX, ColdFusion Studio, and HomeSite+ provide a GUI for writing and executing queries. A GUI is useful for developing and testing your queries before you insert them into a ColdFusion application.
This section contains a brief description of these GUIs. For more information, see the documentation on your specific tool.
This section describes how to define a query using the Dreamweaver MX Recordset dialog box, which allows you to create a record set without having to manually enter SQL statements. Defining a record set using this method can be as easy as selecting a database connection and table from the pop-up menus.
The Simple Recordset dialog box appears:
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.
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
If the Simple Recordset dialog box appears, switch to the Advanced Recordset dialog box by clicking the Advanced button.
The Advanced Recordset dialog box appears:
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 field and click OK. If an instance of the record set is successfully created, a table displaying the data from your record set appears.
Macromedia HomeSite+ includes the combined features of HomeSite 5 and ColdFusion Studio 5, with additional support for new ColdFusion MX tags. Both HomeSite+ and ColdFusion Studio support SQL Builder for writing queries.
SQL Builder is a powerful visual tool for building, testing, and saving SQL statements for use in application data queries. You can copy completed SQL code blocks directly into your ColdFusion applications.
cfquery
tag editor, select an RDS server, and click New Query.The following figure shows the SQL Builder interface:
The SQL Builder is divided into the following four sections:
SQL Builder opens a SELECT statement by default, since this is the most common type of query. SQL Builder supports the following four types of SQL statements: