User Guide

C HAPTER 4
Chapter 4 Retrieving and Formatting the
Data You Want
This chapter explains how to select the data to display in a dynamic Web page. It also
describes how to populate an HTML table with query results and how to use
ColdFusion functions to format and manipulate data.
Contents
• Using Forms to Specify the Data to Retrieve.................................................. 30
• Processing Form Variables on Action Pages................................................... 34
• Dynamically Generating SQL Statements...................................................... 34
• Creating Action Pages ...................................................................................... 35
• Using HTML Tables to Layout Query Results ................................................ 37
• Formatting Individual Data Items .................................................................. 38
• Performing Pattern Matching ......................................................................... 39
• Filtering Data Based on Multiple Conditions ................................................ 39
• Creating Table Joins ......................................................................................... 40
• Building Flexible Search Interfaces ................................................................ 40
• Returning Query Results to the User .............................................................. 42