Welcome!

Charlie Arehart

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


Article

Using the SQL Built in the Studio Query Builder

Using the SQL Built in the Studio Query Builder
By Charlie Arehart
Article Rating:
September 17, 2003 12:00 AM EDT
Reads:
 6,457

After you've built some SQL in the tool, you have the option of either copying the SQL you build to the clipboard-to paste into your CFML template-or "saving" the query for later use. The option to copy to the clipboard is easily missed. It's represented by two icons listed at the top of the query builder (they're the last and next to last from the right).

The first icon copies just the SQL, while the second copies the SQL with a CFQUERY wrapped around it. After clicking one of those buttons, the SQL is copied to the clipboard and you can paste it into your code (after closing the query builder window) using the Edit>Paste command, or CTRL-V.

Charlie Arehart
Education Director, Fig Leaf Software

Published September 17, 2003 – Reads 6,457
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.

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.