Running and Editing Queries  
 
 

You can do a lot of work with SQL statements after building them.

 
 
  Running Queries  
 
 

You can test your SQL code in Query Builder before inserting it a page.

 
 
  To run a query in the Query Builder:  
 
  1. Click the Run Query button.
  2. You are prompted to enter values for any CFML variables in the query.
 
 
  Warning  
 

When you click the Run Query button, the SQL statement is actually processed. If you run an INSERT, UPDATE, or DELETE statement, the changes you coded in the SQL statement are made in the data source.

 
 
  Editing Queries  
 
 

If you save a query, you can edit it later. Pages that contain the edited query are not automatically updated, so you will need to re-insert the query for the changes to take effect.

 
 
  To edit a query:  
 
  1. Open the query folder for the data source you want to use.
  2. Double-click on the query you want to edit.
  3. Make changes in the Table pane and the Properties pane.
  4. Save the new query.
 
 
  Note  
 

The interactions among the Query Builder panes differ somewhat. If you write a query in the SQL pane and save it, the code is not reflected in the Properties or Table panes. If you take an action, such as adding a table, in the Properties or Table panes, the SQL pane is refreshed with the SQL generated from these panes.



 
 
BackUp LevelNext
 
 

allaire     AllaireDoc@allaire.com
    Copyright © 1998, Allaire Corporation. All rights reserved.