Summary

Most ColdFusion applications you'll build have a database at their heart. If you're new to databases, think of them as mini-libraries that organize and relate data by common traits. If you know someone's name, databases make it easy to find the corresponding address, and so on.

When you use a database as the backbone of a ColdFusion application, define it as a datasource with CF's Administrator software. Doing so tells the program where the database is on the system, and opens up an ODBC pipeline that connects ColdFusion directly to the database.

When the database is active as a datasource, you can build template files that will output items from the database as Web pages. Each template file has three elements—a query section, an output ...

Get Sams Teach Yourself ColdFusion® in 21 Days now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.