MACROMEDIA ColdFusion Server 5, Руководство пользователя

Страница: 134 / 328

116 Chapter 8 Accessing Data Sources
Testing and editing queries
You can refine SQL statements after constructing them.
Testing queries
Before inserting a query into an application, we recommend that you test it in SQL
Builder. The following procedure explains how to run a query for testing.
Caution
Only test SELECT statements. When you click the Run Query button, the SQL
statement is processed. If you run an INSERT, UPDATE, or DELETE statement, the
changes that you coded in the SQL statement are made in the data source.
To run a query in SQL Builder:
1 Click the Run Query button.
The Run Query button looks like this:
2 ColdFusion Studio prompts you to enter values for the variables in the query.
Editing queries
If you save a query, you can edit it later. However, pages containing the query are not
automatically updated. To make the changes take effect, you must reinsert the query
into the pages.
To edit a query:
1 Open the query folder for the data source that you want to use.
2 Double-click a query.
3 Make changes in the Table pane and the Properties pane.
4 Save the updated query.
Note
ColdFusion Studio does not update the Properties and Table panes when you make
changes in the SQL pane. If you write a query in the SQL pane and save it, the
Properties and Table panes show no changes. But the SQL pane displays the SQL
generated from changes made in the Properties and Table panes.