Transcription
Developing WebApplications withColdFusion ExpressColdFusion Express for Windows NT and Windows 95/98Allaire Corporation
Copyright Notice Allaire Corporation. All rights reserved.This manual, as well as the software described in it, is furnished under license and maybe used or copied only in accordance with the terms of such license. The content ofthis manual is furnished for informational use only, is subject to change withoutnotice, and should not be construed as a commitment by Allaire Corporation. AllaireCorporation assumes no responsibility or liability for any errors or inaccuracies thatmay appear in this book.Except as permitted by such license, no part of this publication may be reproduced,stored in a retrieval system, or transmitted in any form or by any means, electronic,mechanical, recording, or otherwise, without the prior written permission of AllaireCorporation.ColdFusion is a registered trademark and Allaire, HomeSite, the ColdFusion logo andthe Allaire logo are trademarks of Allaire Corporation in the USA and other countries.Microsoft, Windows, Windows NT, Windows 95, Microsoft Access, and FoxPro areregistered trademarks of Microsoft Corporation. All other products or name brandsare the trademarks of their respective holders. Solaris is a trademark of SunMicrosystems Inc. UNIX is a trademark of Novell Inc. PostScript is a trademark ofAdobe Systems Inc.
ContentsPreface: Welcome To ColdFusion Express .5About ColdFusion Express Documentation . 6Printing ColdFusion Express Documentation. 6Documentation Conventions . 6Intended Audience. 7Using This Guide. 8Developer Resources . 8Getting Answers . 9Contacting Allaire. 9Chapter 1: Understanding ColdFusion .11ColdFusion Web Applications . 11CFML. 13ColdFusion Server. 15The ColdFusion Administrator . 16Development Considerations . 17Chapter 2: Verifying the Server Environment.19Windows System Requirements . 20Windows Configuration . 20Verifying the Web Server . 20Installing ColdFusion Express. 21Configuring the Apache Web Server. 22Verifying ColdFusion Express . 22Installation Considerations and Final Notes . 23
ivDeveloping Web Applications with ColdFusion ExpressChapter 3: Understanding Development.25ColdFusion Application Pages.25The Development Process .26Writing Code .27Saving Application Pages .28Viewing Application Pages .28Adding CFML .29Development Considerations.30Chapter 4: Creating and Manipulating Variables .33Variables .34Variable Types .34Variable Scope.35Creating Variables.35Local Variables .36CFSET Syntax Example.36Creating Local Variables.37Referencing Variables.37Outputting Variables .38CFOUTPUT Syntax Example.38Variable Prefixing.38Variable Lookup Order .40Outputting Local Variables .40Working with CGI Variables .41Working with Cookie Variables.44Development Considerations.45Variable Table .46Chapter 5: Building Pages that Retrieve Data .49Publishing Dynamic Data .50Understanding Data Sources.50Adding Data Sources .51Data Source Notes and Considerations .52Retrieving Data.53Using the CFQUERY Tag .53Writing SQL .55Building Queries .55Building Dynamic SQL Statements .57Query Notes and Considerations .57CFQUERY Variable Information.58Debugging Application Pages .59Outputting Query Data.60Using CFOUTPUT to Output Query Data.61Query Output Notes and Considerations .63Development Considerations.63
ContentsChapter 6: Formatting and Manipulating Data .65Controlling Data .65Formatting Data.66Using Tables with CFML .66Table Syntax Usage Example .66Table Notes and Considerations .68Understanding ColdFusion Functions .68Using Display and Formatting Functions.70Using the DollarFormat Function .71Using the DateFormat Function.72Function Notes and Considerations .73Development Considerations.73Chapter 7: Using Forms and Action Pages .75Using Forms .75Building Forms.76Form Notes and Considerations.79Dynamically Populating Select Boxes .80Understanding Action Pages .82Working with Form Variables .82Creating Action Pages.82Form Variable Notes and Considerations.83Development Considerations.84Chapter 8: Programming with ColdFusion .85Using Programming Logic .85Using ColdFusion Conditional Logic .86Coding Conditional Logic .87Writing Conditional Logic Expressions.87Using Decision Functions to Build Expressions .88Using Operators to Build Expressions.90Conditional Logic Notes and Considerations .95Redirecting Users.95Reusing Code.97Development Considerations.99Chapter 9: Building Search Interfaces .101Understanding Search Interfaces.101Dynamically Generating SQL Statements .102Filtering Data.102Performing Pattern Matching .103Filtering Data Based on Multiple Conditions.104Creating Table Joins.104Building Flexible Search Interfaces .105Returning Results to the User .107Development Considerations.109
viDeveloping Web Applications with ColdFusion ExpressChapter 10: Building Web Front-Ends .111Understanding Web Front-Ends .111Adding Data.111Validating Data.112Inserting Data.115Updating Data.117Passing URL Variables .117Creating Update Action Page.122Development Considerations.124Chapter 11: Where to Go From Here.125ColdFusion Express Sample Application .126Section 2 .128Chapter 12: Introducing ColdFusion Express Administrator .129Overview of Administering ColdFusion Express .129Summary of Administrative Tasks.131Starting and Stopping ColdFusion .132Chapter 13: Configuring ColdFusion Express Server .133The ColdFusion Administrator .133Starting and Stopping ColdFusion .134The Settings Page .135Configuring Administrator Security .136Mapping Directories.137The ColdFusion Logging Page .138ColdFusion Administrator Debugging Options .139Monitoring ColdFusion Performance .141Chapter 14: Managing Data Sources .143About ColdFusion Data Sources.143Configuring ODBC Data Sources for ColdFusion .144Configuring ODBC Data Sources for Windows .145Verifying ColdFusion Data Sources.149Using ColdFusion to Create a Data Source.150Chapter 15: Managing Client Variables.153About Client Variables.153Enabling Ex
Preface : Welcome To ColdFusion Express 11 Developer Resources Allaire is committed to setting the standard for customer support in developer education, technical support, and professional services. Our Web site is designed to give
