MACROMEDIA COLDFUSION STUDIO 4.5-USING COLDFUSION..., Руководство пользователя

Страница: 68 / 236

68
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:
•
If you open the SQL Builder from the CFQUERY tag editor, it prompts you to
insert the query when you close the editor.
•
If you open the SQL Builder from a CFML page, it prompts you to insert the
query when you close it.
•
To insert just the SQL statement, click the Copy SQL to Clipboard button on the
toolbar. Close the SQL Builder and paste the SQL into your page. You will be
prompted to save the query.
•
To insert the SQL statement within a CFQUERY tag, click the Copy CFQUERY
button. Close the SQL Builder and paste the query into your page. You will be
prompted to save the query.
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.