Adobe ColdFusion 8 Web Application Construction Kit, Volume 1: Getting Started

Preparing to Write SQL Queries

Now that you have a data source, all you need is a client application with which to access the data. Ultimately, the client you will use is ColdFusion via CFML code; after all, that is why you’re reading this book. But to start learning SQL, we’ll use something simpler, a SQL Query Tool (written in ColdFusion). The tool is accessed via a file named index.cfm in a directory named sql under the ows directory, and so the path to it (if using the integrated Web server) will be:

http://localhost:8500/ows/sql/index.cfm

Note

If you are using the integrated server in a multi-server installation, use port 8300 instead of 8500.

The SQL Query Tool, shown in Figure 6.6, allows you to enter SQL statements in the box provided; ...