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:
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; ...