macromedia® Coldfusion® MX 7 Web Application Construction Kit

Chapter 10. Creating Data-Driven Pages

IN THIS CHAPTER

Accessing Databases 217

Displaying Database Query Results 225

Using Query Variables 234

Grouping Result Output 239

Using Data Drill-Down 243

Debugging Dynamic Database Queries 261

Accessing Databases

In the past few chapters, you created and executed ColdFusion templates. You worked with different variable types, conditional processing, code reuse, and more.

But this chapter is where it starts to get really interesting. Now it's time to learn how to connect to databases to create complete dynamic and data-driven pages.

Note

The examples in this chapter, and indeed all the chapters that follow, use the data in the ows data sources and database. These must be present before continuing.

And I'll remind you ...