1. Chapter 1 Introducing ColdFusion

   1. What Is Allaire's ColdFusion?

   2. ColdFusion Architecture

   3. Getting Started with ColdFusion

2. Chapter 2 ColdFusion Basics

   1. Getting Started

   2. Datatypes

   3. Variables

   4. Expressions

   5. Writing Output

   6. Conditional Processing

   7. Looping

   8. Including Other Templates

3. Chapter 3 Passing Data Between Templates

   1. Passing Parameters via URL

   2. Passing Data Using Forms

   3. Dealing with Nonexistent Parameters

4. Chapter 4 Database Basics

   1. Configuring Data Sources

   2. Introducing CFQUERY

   3. A Quick SQL Primer

   4. Retrieving and Displaying Data

   5. Sorting Query Results

   6. Grouping Output

   7. Looping Over a Query Result Set

   8. Formatting Techniques

5. Chapter 5 Maintaining Database Records

   1. Inserting Records

   2. Updating Existing Records

   3. Deleting Records

6. Chapter 6 Complex Datatypes

   1. Lists

   2. Arrays

   3. Structures

   4. Query Objects

7. Chapter 7 Maintaining State

   1. Setting Up the Web Application Framework

   2. Using Persistent Variables

   3. Browser Redirection

   4. Portal Example

8. Chapter 8 Security

   1. Security Basics

   2. Implementing Security from Scratch

   3. Using ColdFusion's Built-in Advanced Security Services

9. Chapter 9 Error and Exception Handling

   1. Basic Exception Handling

   2. Custom Exception Handling

   3. Rethrowing Exceptions

   4. Error Handling Within the Web-Application Framework

   5. Server-wide Error Handling

10. Chapter 10 Dynamic Form Controls

    1. Combining HTML and CFML Form Controls

    2. Data Validation

    3. Basic Input Controls

    4. Textual Input

    5. A Selection Control

    6. Sliders

    7. Grids

    8. Trees

    9. Custom Controls

    10. Form Controls in Version 5.0

11. Chapter 11 Advanced Database Techniques

    1. Display Techniques

    2. Drill-Down Queries

    3. Query Caching

    4. Advanced SQL

    5. CFSQL

    6. Calling Stored Procedures

    7. Transaction Processing

12. Chapter 12 Manipulating Files and Directories

    1. Working with Directories

    2. Dealing with Files

    3. Performing FTP Operations

13. Chapter 13 Working With Email

    1. Sending Email

    2. Dealing with Undeliverable Email

    3. Retrieving Messages

    4. Building a Web-Based Email Client

14. Chapter 14 Interacting with Other Web Servers Using HTTP

    1. Retrieving Information

    2. Parsing Data

    3. Generating Static HTML Pages

    4. Posting Information

    5. CFHTTP Considerations

15. Chapter 15 Interfacing with LDAP-Enabled Directories

    1. LDAP Basics

    2. Querying an LDAP Directory

    3. Modifying LDAP Entries

    4. Modifying the Distinguished Name

16. Chapter 16 Working with the Verity Search Interface

    1. Creating Collections

    2. Populating Collections

    3. Searching Collections

    4. The Verity Search Language

    5. Updating Collections

    6. Maintaining Collections

    7. Advanced Techniques

17. Chapter 17 Regular Expressions in ColdFusion

    1. Regular-Expression Syntax

    2. Finding Strings

    3. Replacing Strings

    4. Back References

    5. Useful Regular Expressions

    6. Input Considerations

    7. Regular Expression Builder

18. Chapter 18 Scripting

    1. Scripting Syntax

    2. Writing Output

    3. CFScript Statements

    4. User-Defined Functions

19. Chapter 19 Creating Custom Tags

    1. Getting Started

    2. Calling Custom Tags

    3. Passing Data

    4. Returning Data

    5. Attribute Validation and Error Handling

    6. Advanced Techniques

    7. Protecting Your Tags

    8. CFX Tags

20. Chapter 20 Sharing Data with WDDX

    1. WDDX Basics

    2. Serializing and Deserializing Data

    3. Storing WDDX Packets

    4. Server-to-Server WDDX

    5. Server-to-Browser WDDX Using JavaScript

21. Chapter 21 Working with the System Registry

    1. Getting Registry Keys and Values

    2. Setting Registry Keys and Values

    3. Deleting Registry Keys and Values

22. Chapter 22 Using the ColdFusion Scheduler

    1. Scheduling Tasks with the ColdFusion Administrator

    2. Scheduling Tasks with CFSCHEDULE

    3. Additional Considerations

23. Chapter 23 Calling External Objects

    1. Connecting to External Objects

    2. Executing Programs

    3. Invoking Java Servlets

24. Chapter 24 Graphing and Charting

    1. Creating a Simple Graph

    2. Graphing Query Results

    3. Drilling Down on Graph Data

1. Appendix A Tag Reference

   1. Tags by Type

   2. Alphabetical List of Tags

   3. CFABORT

   4. CFADMINSECURITY

   5. CFAPPLET

   6. CFAPPLICATION

   7. CFASSOCIATE

   8. CFAUTHENTICATE

   9. CFBREAK

   10. CFCACHE

   11. CFCASE

   12. CFCATCH

   13. CFCOL

   14. CFCOLLECTION

   15. CFCONTENT

   16. CFCOOKIE

   17. CFDEFAULTCASE

   18. CFDIRECTORY

   19. CFDUMP

   20. CFELSE

   21. CFELSEIF

   22. CFERROR

   23. CFEXECUTE

   24. CFEXIT

   25. CFFILE

   26. CFFLUSH

   27. CFFORM

   28. CFFTP

   29. CFGRAPH

   30. CFGRAPHDATA

   31. CFGRID

   32. CFGRIDCOLUMN

   33. CFGRIDROW

   34. CFGRIDUPDATE

   35. CFHEADER

   36. CFHTMLHEAD

   37. CFHTTP

   38. CFHTTPPARAM

   39. CFIF

   40. CFIMPERSONATE

   41. CFINCLUDE

   42. CFINDEX

   43. CFINPUT

   44. CFINSERT

   45. CFINTERNALDEBUG

   46. CFLDAP

   47. CFLOCATION

   48. CFLOCK

   49. CFLOG

   50. CFLOOP

   51. CFMAIL

   52. CFMAILPARAM

   53. CFMODULE

   54. CFNEWINTERNALADMINSECURITY

   55. CFNEWINTERNALREGISTRY

   56. CFOBJECT

   57. CFOBJECTCACHE

   58. CFOUTPUT

   59. CFPARAM

   60. CFPOP

   61. CFPROCESSINGDIRECTIVE

   62. CFPROCPARAM

   63. CFPROCRESULT

   64. CFQUERY

   65. CFQUERYPARAM

   66. CFREGISTRY

   67. CFREPORT

   68. CFRETHROW

   69. CFSAVECONTENT

   70. CFSCHEDULE

   71. CFSCRIPT

   72. CFSEARCH

   73. CFSELECT

   74. CFSERVLET

   75. CFSERVLETPARAM

   76. CFSET

   77. CFSETTING

   78. CFSILENT

   79. CFSLIDER

   80. CFSTOREDPROC

   81. CFSWITCH

   82. CFTABLE

   83. CFTEXTINPUT

   84. CFTHROW

   85. CFTRANSACTION

   86. CFTREE

   87. CFTREEITEM

   88. CFTRY

   89. CFUPDATE

   90. CFWDDX

2. Appendix B Function Reference

   1. Array Functions

   2. Alphabetical List of Functions

   3. Abs

   4. ACos

   5. ArrayAppend

   6. ArrayAvg

   7. ArrayClear

   8. ArrayDeleteAt

   9. ArrayInsertAt

   10. ArrayIsEmpty

   11. ArrayLen

   12. ArrayMax

   13. ArrayMin

   14. ArrayNew

   15. ArrayPrepend

   16. ArrayResize

   17. ArraySet

   18. ArraySort

   19. ArraySum

   20. ArraySwap

   21. ArrayToList

   22. Asc

   23. Asin

   24. Atn

   25. AuthenticatedContext

   26. AuthenticatedUser

   27. BitAnd

   28. BitMaskClear

   29. BitMaskRead

   30. BitMaskSet

   31. BitNot

   32. BitOr

   33. BitSHLN

   34. BitSHRN

   35. BitXor

   36. Ceiling

   37. CFusion_DBConnections_Flush

   38. CFusion_Decrypt

   39. CFusion_Disable_DBConnections

   40. CFusion_Encrypt

   41. CFusion_GetODBCDSN

   42. CFusion_GetODBCINI

   43. CFusion_SetODBCINI

   44. CFusion_Settings_Refresh

   45. CFusion_VerifyMail

   46. CF_GetDataSourceUserName

   47. CF_IsColdFusionDataSource

   48. CF_SetDataSourcePassword

   49. CF_SetDataSourceUserName

   50. Chr

   51. CJustify

   52. Compare

   53. CompareNoCase

   54. Cos

   55. CreateDate

   56. CreateDateTime

   57. CreateObject

   58. CreateODBCDate

   59. CreateODBCDateTime

   60. CreateODBCTime

   61. CreateTime

   62. CreateTimeSpan

   63. CreateUUID

   64. DateAdd

   65. DateCompare

   66. DateConvert

   67. DateDiff

   68. DateFormat

   69. DatePart

   70. Day

   71. DayOfWeek

   72. DayOfWeekAsString

   73. DayOfYear

   74. DaysInMonth

   75. DaysInYear

   76. DE

   77. DecimalFormat

   78. DecrementValue

   79. Decrypt

   80. DeleteClientVariable

   81. DirectoryExists

   82. DollarFormat

   83. Duplicate

   84. Encrypt

   85. Evaluate

   86. Exp

   87. ExpandPath

   88. FileExists

   89. Find

   90. FindNoCase

   91. FindOneOf

   92. FirstDayOfMonth

   93. Fix

   94. FormatBaseN

   95. GetBaseTagData

   96. GetBaseTagList

   97. GetBaseTemplatePath

   98. GetClientVariablesList

   99. GetCurrentTemplatePath

   100. GetDirectoryFromPath

   101. GetException

   102. GetFileFromPath

   103. GetFunctionList

   104. GetHTTPRequestData

   105. GetHTTPTimeString

   106. GetK2ServerCollections

   107. GetK2ServerDocCount

   108. GetK2ServerDocCountLimit

   109. GetLocale

   110. GetMetricData

   111. GetProfileString

   112. GetTempDirectory

   113. GetTempFile

   114. GetTemplatePath

   115. GetTickCount

   116. GetTimeZoneInfo

   117. GetToken

   118. Hash

   119. Hour

   120. HTMLCodeFormat

   121. HTMLEditFormat

   122. IIf

   123. IncrementValue

   124. InputBaseN

   125. Insert

   126. Int

   127. IsArray

   128. IsAuthenticated

   129. IsAuthorized

   130. IsBinary

   131. IsBoolean

   132. IsCustomFunction

   133. IsDate

   134. IsDebugMode

   135. IsDefined

   136. IsK2ServerDocCountExceeded

   137. IsLeapYear

   138. IsNumeric

   139. IsNumericDate

   140. IsProtected

   141. IsQuery

   142. IsSimpleValue

   143. IsStruct

   144. IsWDDX

   145. JavaCast

   146. JSStringFormat

   147. Lcase

   148. Left

   149. Len

   150. ListAppend

   151. ListChangeDelims

   152. ListContains

   153. ListContainsNoCase

   154. ListDeleteAt

   155. ListFind

   156. ListFindNoCase

   157. ListFirst

   158. ListGetAt

   159. ListInsertAt

   160. ListLast

   161. ListLen

   162. ListPrepend

   163. ListQualify

   164. ListRest

   165. ListSetAt

   166. ListSort

   167. ListToArray

   168. ListValueCount

   169. ListValueCountNoCase

   170. LJustify

   171. Log

   172. Log10

   173. LSCurrencyFormat

   174. LSDateFormat

   175. LSEuroCurrencyFormat

   176. LSIsCurrency

   177. LSIsDate

   178. LSIsNumeric

   179. LSNumberFormat

   180. LSParseCurrency

   181. LSParseDateTime

   182. LSParseEuroCurrency

   183. LSParseNumber

   184. LSTimeFormat

   185. LTrim

   186. Max

   187. Mid

   188. Min

   189. Minute

   190. Month

   191. MonthAsString

   192. Now

   193. NumberFormat

   194. ParagraphFormat

   195. ParameterExists

   196. ParseDateTime

   197. Pi

   198. PreserveSingleQuotes

   199. Quarter

   200. QueryAddColumn

   201. QueryAddRow

   202. QueryNew

   203. QuerySetCell

   204. QuotedValueList

   205. Rand

   206. Randomize

   207. RandRange

   208. REFind

   209. REFindNoCase

   210. RemoveChars

   211. RepeatString

   212. Replace

   213. ReplaceList

   214. ReplaceNoCase

   215. REReplace

   216. REReplaceNoCase

   217. Reverse

   218. Right

   219. RJustify

   220. Round

   221. RTrim

   222. Second

   223. SetLocale

   224. SetProfileString

   225. SetVariable

   226. Sgn

   227. Sin

   228. SpanExcluding

   229. SpanIncluding

   230. Sqr

   231. StripCR

   232. StructAppend

   233. StructClear

   234. StructCopy

   235. StructCount

   236. StructDelete

   237. StructFind

   238. StructFindKey

   239. StructFindValue

   240. StructGet

   241. StructInsert

   242. StructIsEmpty

   243. StructKeyArray

   244. StructKeyExists

   245. StructKeyList

   246. StructNew

   247. StructSort

   248. StructUpdate

   249. Tan

   250. TimeFormat

   251. ToBase64

   252. ToBinary

   253. ToString

   254. Trim

   255. Ucase

   256. URLDecode

   257. URLEncodedFormat

   258. Val

   259. ValueList

   260. Week

   261. WriteOutput

   262. XMLFormat

   263. Year

   264. YesNoFormat

3. Appendix C Example Database Tables

4. Appendix D ColdFusion Resources

   1. Official Allaire Resources

   2. Magazines

   3. Community Resources

   4. User Groups

5. Colophon

Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The animal on the cover of Programming ColdFusion is an Arctic tern. Arctic terns (Sterna paradisaea) are small birds, about 12 to 15 inches long, that make the longest migration of any avian on Earth. They breed in the Arctic tundra but fly to the edge of the Antarctic ice pack during the winter. An Arctic tern flies over 21,750 miles each year; it spends most of its life, about 20 years, flying.

The Arctic tern has webbed feet, the tail is long and forked, the legs are short and red, and the head is rounded and white with a black cap and a bright orange beak. Research has shown that Arctic terns don?t swim well and will do everything possible to stay out of the water. Even though their feet are webbed, they are small, so the birds swoop down, catch a fish, and eat it while flying.

During the breeding or courtship time male terns fly a "fish flight." A male takes a small fish in its bill and passes as low as it can over a female on the ground. If she notices, she'll join him in the fish flight, and they soon mate.

In Arctic breeding grounds, females lay one or two cream-colored eggs with brown speckles (1.6 inches long). The eggs are laid in a grassy area for protection from their predators and because there are no trees in the Arctic. Both parents care for the eggs and feed the hatchlings.

Native humans watch to see where Arctic terns are feeding. By monitoring where the terns hunt, they can find large schools of fish and increase their catch. Mary Anne Weeks Mayo was the production editor and copyeditor for Programming ColdFusion. Ann Schirmer and Jane Ellin provided quality control. Edie Shapiro, Matt Hutchinson, Sada Preisch, and Molly Shangraw provided production assistance. Nancy Crumpton wrote the index.

Hanna Dyer designed the cover of this book, based on a series design by Edie Freedman. The cover image is an original illustration created by Lorrie LeJeune. Emma Colby produced the cover layout with QuarkXPress 4.1 using Adobe's ITC Garamond font.

Melanie Wang designed the interior layout based on a series design by Nancy Priest. Anne-Marie Vaduva converted the files from Microsoft Word to FrameMaker 5.5.6 using tools created by Mike Sierra. The text and heading fonts are ITC Garamond Light and Garamond Book; the code font is Constant Willison. The illustrations for this book were created by Robert Romano and Jessamyn Read using Macromedia Freehand 9 and Adobe Photoshop 6. This colophon was compiled by Mary Anne Weeks Mayo.

Whenever possible, our books use a durable and flexible lay-flat binding. If the page count exceeds this binding's limit, perfect binding is used.