Welcome!

Charlie Arehart

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


Related Topics: ColdFusion on Ulitzer

CFDJ: Article

Whither The Studio Query Builder

Whither The Studio Query Builder
By Charlie Arehart
Article Rating:
September 17, 2003 12:00 AM EDT
Reads:
 6,467

Did you know that Studio has a built-in SQL query builder? It provides a drag-and-drop SQL query building interface (much like that used in MS Access) that can be performed against any of your available datasources, including Access, SQL Server, and the rest. To find the tool, use the "database" tab in the resource tab (the yellow disk-like icon in the lower left of the Studio interface).

Select an RDS server from the drop down box at the top of its window. (Information on creating RDS server connections is presented in the "Using ColdFusion Studio" online help available inside Studio.) Then select a datasource from the list available on that server, and then select a table. The query builder is a little hidden: right click on the table and choose "new query". See the "Using ColdFusion Studio" online help for more on using the Query Builder.

Charlie Arehart
Education Director, Fig Leaf Software

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