User Guide

C HAPTER 7
Accessing Data Sources
This chapter describes how to use Studios visual tools to significantly accelerate
development of data-driven ColdFusion applications.
Contents
Introduction to Database Tools ............................................................................... 62
Registering Data Sources.......................................................................................... 62
Connecting to Data Sources..................................................................................... 63
Viewing Data Sources ............................................................................................... 63
Using SQL Builder ..................................................................................................... 64
Building a SELECT Statement .................................................................................. 66
Testing a Query.......................................................................................................... 67
Editing a Query.......................................................................................................... 67
Inserting SQL into a Page.......................................................................................... 68