O'Reilly logo

Adobe ColdFusion 8 Web Application Construction Kit, Volume 1: Getting Started by Charlie Arehart, Raymond Camden, Ben Forta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required