132
Chapter 8 Accessing Data Sources
Using SQL Builder for database queries
SQL Builder is a powerful visual tool that you can use to build, test, and save SQL
statements for use in application data queries. You can copy a SQL code block
directly into your application or insert it into a
cfquery
tag. You can also use SQL
Builder to test your queries.
To open SQL Builder, do one of the following:
•
In the Database tab, right-click a database name or a table and select New Query.
•
Select
Tools > SQL Builder
. In SQL Builder, select a database from the drop-down
list, and click New Query.
•
Open the
cfquery
tag editor and click New Query.
In the Select Table dialog box (shown in the following graphic), select the table
that you want to query against, and click Select.
Summary of Contents for HOMESITE
Page 11: ...Contents xi Table of CommandID values 310 Table of SettingID values 314 Glossary 323...
Page 12: ...xii Contents...
Page 20: ...xx About This Book...
Page 28: ...8 Chapter 1 Setting Up the Product...
Page 70: ...50 Chapter 4 Managing Files...
Page 88: ...68 Chapter 5 Writing Code and Web Content...
Page 116: ...96 Chapter 6 Editing Pages...
Page 148: ...128 Chapter 7 Using Web Development Languages...
Page 190: ...170 Chapter 11 Deploying Files...
Page 210: ...190 Chapter 12 Testing and Maintaining Web Pages...
Page 216: ...196 Chapter 13 Extending the Help System...
Page 350: ...330 Glossary...
Page 358: ...338 Index...