Welcome!

Charlie Arehart

Subscribe to Charlie Arehart: eMailAlertsEmail Alerts
Get Charlie Arehart via: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn


Article

Using Saved Queries in the Query Builder

Using Saved Queries in the Query Builder

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

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.

Comments (0)

Share your thoughts on this story.

Add your comment
You must be signed in to add a comment. Sign-in | Register

In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.