Inserting SQL into a Page

You can use any of the following methods to insert a query directly into a CFML page from the SQL Builder:

Note To insert a saved query:

Use either of the methods listed below.

  1. Open the data source schema in the Database tab.
  2. Open the Queries folder in the data source you want to use.
  3. Drag and drop the query onto the page.

OR

  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.