Inserting Queries into a Page  
 
 

You have four options for inserting a query directly into a CFML page from the Query Builder:

  • If you open the Query Builder from the CFQUERY tag editor, it will prompt you to insert the query when you close the editor.
  • If you open the Query Builder from a CFML page, the it will prompt you to insert the query when you close it.
  • Click the Copy SQL to Clipboard button on the Query toolbar. Close the Query Builder and paste the SQL into your page.
  • Click the Copy CFQUERY button on the Query toolbar. Close the Query Builder and paste the CFQUERY tag into your page.
 
 
  To insert a saved query:  
     
 
    Method 1  
 
  1. Open the data source schema in the Database Resource tab.
  2. Open the Queries folder in the data source you want to use.
  3. Drag and drop the query onto the page.
 
 
  Method 2  
 
  1. Click the CFQUERY button on the CFML Basic tag toolbar or select CFQUERY from the Tag Chooser (CTRL+E).
  2. Enter a name for the query.
  3. Click the Insert Query button.
  4. Choose a server from the select box.
  5. Open the Queries folder in the data source you want to use.
  6. Select a query and click Insert.
  7. Click Apply in the CFQUERY tag editor.


 
 
BackUp LevelNext
 
 

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