Day 5. Finding the Data You Need: An Introduction to Queries and SQL

In Day 2, "Anatomy of a ColdFusion Application," I introduced you to your first ColdFusion template page and illustrated the way it uses a query to select data to present on the Web. I designed a few simple queries, and gave examples of the output they might generate. In today's session, we'll take a closer look at the query and how it uses structured query language (SQL) to select records from a database. We'll cover

  • Examining the ColdFusion query

  • Basics of the SELECT statement

  • Qualifying a SELECT statement with conditions

  • Sorting and evaluating data

  • Using SQL to change a database

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.

Start your free trial