Coldfusion 5 Developer's Guide Book

	Acknowledgments	xvii
	Introduction	xix
Part I	Installation & Overview
Chapter 1	Windows 2000 Installation and Optimization	3
	Internet Information Server 5.0	4
	SQL Server 2000	19
	Installing ColdFusion 5.0	46
	Wrapping Up	50
Chapter 2	Linux Installation and Optimization	51
	Setting Up Apache as Your Web Server	52
	Setting Up MySQL	63
	Installing ColdFusion 5.0	68
	Wrapping Up	69
Chapter 3	New ColdFusion 5.0 Features	71
	ColdFusion Administrator	72
	Database Connection Support	126
	New Tags	127
	New Functions	133
	User Defined Functions	133
	Queries of Queries	134
	Wrapping Up	134
Part II	The Project
Chapter 4	Project Planning	137
	Planning Methods for Software Development	138
	Planning Our Sample Skate Shop Application	142
	Wrapping Up	164
Chapter 5	The Database	165
	Background on Database Forms	166
	Referential Integrity	172
	Designing Our Database	179
	Building Our Database	187
	Wrapping Up	193
Chapter 6	Building the skate.shop Front End	195
	Discussing the Skate.shop Code Standard	196
	Building the Interface	199
	Building the Mini-Applications for the Interface	219
	Wrapping Up	265
Chapter 7	Building the skate.shop Administrator Tool	267
	Administrator Overview	268
	Order Processing	275
	Reporting	289
	Wrapping Up	293
Chapter 8	Launching and Maintaining the Site	295
	Building a Maintenance Scheduler	296
	Staging and Launching skate.shop	309
	Monitoring Performance	315
	Tweaking Performance	331
	Listening to the Customer	336
	Wrapping Up	343
Part III	Advanced Topics
Chapter 9	Scripting with [left angle bracket]CFSCRIPT[right angle bracket]	347
	Advantages of [left angle bracket]CFSCRIPT[right angle bracket]	348
	Disadvantages of [left angle bracket]CFSCRIPT[right angle bracket]	350
	[left angle bracket]CFSCRIPT[right angle bracket] Conventions	352
	Setting Variables	353
	Using WriteOutput()	355
	Using Conditional Statements	356
	Using Loops	359
	User Defined Functions	360
	Wrapping Up	362
Chapter 10	Advanced Technologies	365
	Locking	366
	ColdFusion Extensions	370
	WDDX	374
	Using Advanced Security	377
	Wrapping Up	394
Chapter 11	Stored Procedures and Advanced Database Connectivity	395
	Stored Procedures	396
	Advanced Database Connectivity	415
	Wrapping Up	417
Chapter 12	[left angle bracket]CFTRANSACTION[right angle bracket]	419
	Database Transactions	420
	How SQL Server 2000 Handles Transactions	422
	Locking	424
	The [left angle bracket]CFTRANSACTION[right angle bracket] Tag	432
	Controlling Transactions	434
	Wrapping Up	438
Chapter 13	Debugging	439
	Debugging ColdFusion Applications	440
	Wrapping Up	463
Chapter 14	Error Handling	465
	Using [left angle bracket]CFERROR[right angle bracket]	467
	Using [left angle bracket]CFTRY[right angle bracket] and [left angle bracket]CFCATCH[right angle bracket]	477
	Using [left angle bracket]CFTHROW[right angle bracket]	482
	Using [left angle bracket]CFRETHROW[right angle bracket]	483
	Sitewide Error Handler	484
	Missing Template Handler	484
	Wrapping Up	485
Chapter 15	Custom Tags	487
	Simple Custom Tags	488
	Advanced Custom Tags and Functionality	506
	Using [left angle bracket]CFASSOCIATE[right angle bracket]	522
	Using [left angle bracket]CFMODULE[right angle bracket]	524
	Wrapping Up	526
Chapter 16	Pattern Matching with Regular Expressions	527
	Overview	528
	The Rules	529
	Character Classes	532
	Multicharacter Regular Expressions	533
	Anchoring	534
	Backreferencing	535
	Matched Subexpressions	536
	Wrapping Up	536
Chapter 17	Internet Protocols	537
	E-mail and ColdFusion	538
	File Transfer Protocol	555
	Hypertext Transfer Protocol (HTTP)	564
	Wrapping Up	573
Chapter 18	XML and SQL 2000	575
	Reading XML Data	576
	Writing XML Data	595
	Wrapping Up	599
	Index	601