User manual MACROMEDIA COLDFUSION STUDIO 5-USING COLDFUSION 5 STUDIO

[. . . ] CFS_MANCVRPG_live. fh9 10/1/01 12:37 PM Page 1 C M Y CM MY CY CMY K macromedia ® Using ColdFusion 5 Studio COLDFUSION®5 STUDIO ® macromedia ® Composite Copyright Notice Copyright 2001 Macromedia, Inc. Macromedia, the Macromedia logo, ColdFusion, Dreamweaver, Dreamweaver UltraDev, Flash, HomeSite, JRun, Quick Tag Editor, Roundtrip, and what the web can be are trademarks or registered trademarks of Macromedia, Inc. which may be registered in the United States and internationally. Java and Solaris are trademarks of Sun Microsystems, Inc. [. . . ] Double-click on a variable placeholder name and enter a value. To save a query: 1 2 3 4 Open SQL Builder. For instructions, see the opening SQL Builder procedure earlier in this section. On the Query toolbar, click the Save Query button. In the dialog box that appears, enter a name for the query. Click Save. Saved queries are stored on the database server. They can be edited and used by anyone who has access to the server. Using SQL Builder for Database Queries 115 Note ColdFusion Studio does not update the Properties and Table panes when you make changes in the SQL pane. If you edit a SQL statement in the SQL pane and save it, and then modify the Table pane or change any values in the Properties pane, a new SQL statement is generated which overwrites the changes that you made in the SQL pane. Inserting SQL into a page This section describes how to insert new and saved queries into a page in the Editor. To insert a new query, do one of the following: · If you opened SQL Builder from the CFQUERY tag editor, it prompts you to insert the query when you close the editor. · If you opened SQL Builder from a CFML page, it prompts you to insert the query when you close SQL Builder. · To insert just the SQL statement from SQL Builder, click the Copy SQL to Clipboard button on the toolbar and close SQL Builder. ColdFusion Studio prompts you to save the query. Then you can paste the statement into your page. · To insert the SQL statement into a cfquery tag, click the Copy CFQUERY button. Close SQL Builder and paste the query into your page. ColdFusion Studio prompts you to save the query. To insert a saved query, do one of the following: 1 2 3 4 or 1 2 3 4 5 6 7 On the CFML Basic QuickBar, click the CFQUERY button. You can also select CFQUERY from the Tag Chooser. In the select dialog box, select a server. In the data source that you want to use, open the Queries folder. In the Resources window, click the Database tab. Open the Queries folder in the data source. Drag and drop the query onto the page in the Editor. 116 Chapter 8 Accessing Data Sources Testing and editing queries You can refine SQL statements after constructing them. Testing queries Before inserting a query into an application, we recommend that you test it in SQL Builder. The following procedure explains how to run a query for testing. When you click the Run Query button, the SQL statement is processed. [. . . ] For example, an XML language for cooking could have a <recipe> tag, and <recipe> could contain tags for <header>, <ingredients>, and <instructions>. The power of XML lies in the fact that the information can be stored and retrieved from a database, rendered in a variety of formats, and used for a variety of purposes--for example on a Web page, hand-held computer, or cell phone; or for a cookbook, recipe card club, or book about cilantro. 302 Glossary Index A absolute paths, deploying to 144 accessibility 66 accessing data sources 109 Help 35 project files from VSS 136 ActiveDocument Object in VTOM 230 ActiveScript 88 ActiveScripting examples in VTOM 276 ActiveX 87 administering multiuser projects in VSS 138 advanced search operators 38 anchoring regular expressions to strings 93 answers, finding xvii APF files 127 Application Object in VTOM 199 arguments, inserting with Tag Insight 58 ASP 95, 102 support for 84 assigning keyboard shortcuts 63 attributes viewing 57 Auto Backup 49 about 48 options 49 using 50 Auto Completion 59 auto-inclusive folders about 127 files in 131 B backing up files 48 backups, managing 49 bookmarks. See favorites breakpoints, setting in debugger 122 Browse tab 29 browsers configuring 9 configuring external 11 configuring internal 10 copying text from 61 editing configurations for 11 integrating 11 integrating Mozilla 10 Internet Explorer as default 10 options for internal 10 removing integration from 12 setting file saving behavior 12 viewing integrated 11 viewing pages in external 12 building favorite folders list 51 SQL select statements 114 C Cascading Style Sheets. See CSS case matching in searches 153, 154, 156 of event handler in CodeSweepers 99 CFML 84 changing color coding schemes 96 character classes 92 checking file size after file transfer 16 spelling 159 Chinese, support for 3 classes 295 clients 296 clipboard, customizing 72 code editing in Tag Inspector 79 generating tools 60 preserving with CodeSweepers 97 selecting blocks 72 code snippets. [. . . ]