| By Charlie Arehart | Article Rating: |
|
| September 17, 2003 12:00 AM EDT | Reads: |
5,304 |
If you "save" the query instead (either by using the left-most icon at the top of the query builder or by simply closing the query builder once you've created or modified one), this saved query is presented in a list of all such queries that have been saved for the given datasource (presented below the list of tables for that datasource, as shown in the database tab). You can then drag and drop such a saved query onto your CFML code.
You can also change a saved query by double-clicking on it in the just-mentioned list of saved queries. Note, however, that once a query is dropped into your code, it will not be affected by changes made to the saved query. Similarly, to be sure, changes made to the query in the CFML code will have no impact on any saved query from which it was created.
Charlie Arehart
Education Director, Fig Leaf Software
Published September 17, 2003 Reads 5,304
Copyright © 2003 SYS-CON Media, Inc. — All Rights Reserved.
Syndicated stories and blog feeds, all rights reserved by the author.
More Stories By Charlie Arehart
A veteran ColdFusion developer since 1997, Charlie Arehart is a long-time contributor to the community and a recognized Adobe Community Expert. He's a certified Advanced CF Developer and Instructor for CF 4/5/6/7 and served as tech editor of CFDJ until 2003. Now an independent contractor (carehart.org) living in Alpharetta, GA, Charlie provides high-level troubleshooting/tuning assistance and training/mentoring for CF teams. He helps run the Online ColdFusion Meetup (coldfusionmeetup.com, an online CF user group), is a contributor to the CF8 WACK books by Ben Forta, and is frequently invited to speak at developer conferences and user groups worldwide.
- Validating Input with Regular Expressions
- Getting Focus()ed and a Quick JavaScript Lesson
- Setting Up Your Development Server with ColdFusion 5, MX, and BlueDragon
- Toward Better Error Handling
- Monitoring Your ColdFusion Environment With the Free Log Parser Toolkit
- New Possibilities for Session/Client Variable Handling in CFMX
- Testing Existence in Arrays
- Making the Case for CFML on J2EE
- Exploring Amazon Web Services with ColdFusion MX
- Getting Focused - and a Quick JavaScript Lesson
- CFML on J2EE: Easy as 1-2-3
- Getting into HomeSite+

























