• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 1: Week 1 At a Glance > Finding the Data You Need: An Introduction to Quer...

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


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint