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
- Open the data source schema in the Database Resource tab.
- Open the Queries folder in the data source you want to use.
- Drag and drop the query onto the page.
Method 2
- Click the CFQUERY button on the CFML Basic tag toolbar or select CFQUERY from the Tag Chooser (CTRL+E).
- Enter a name for the query.
- Click the Insert Query button.
- Choose a server from the select box.
- Open the Queries folder in the data source you want to use.
- Select a query and click Insert.
- Click Apply in the CFQUERY tag editor.
AllaireDoc@allaire.com
Copyright © 1998, Allaire Corporation. All rights reserved.