Introduction.
Who Should Use This Book. How to Use This Book.
I. INTRODUCTION.
1. Why ColdFusion?
Introducing ColdFusion.
2. Introduction to ColdFusion.
Understanding the World Wide Web. Introducing ColdFusion. Linking to External Applications.
II. GETTING UP AND RUNNING.
3. Installing ColdFusion and ColdFusion Studio.
Preparing to Install ColdFusion. Installing ColdFusion. Preparing to Install ColdFusion Studio. Installing ColdFusion Studio.
4. Administering ColdFusion.
Using the ColdFusion Administrator. Using the Server Tab. Using the Data Sources Tab. Using the Debugging Tab. Using the Mail Tab. Using the Logging Tab. Using the Tags Tab. Using the Mappings Tab. Using the Scheduler Tab. Using the Verity Tab. Using the Applets Tab.
III. GETTING STARTED WITH COLDFUSION.
5. Designing an Application.
Introducing Application Design.
6. Database Fundamentals.
Understanding Databases. Understanding Relational Databases. Understanding the Different Types of Database Applications.
7. Creating Databases and Tables.
Creating Databases. Creating the A2Z Database. Creating Tables. Understanding Table Relationships. Adding Data with Microsoft Access.
8. Introduction to SQL.
Introducing SQL, the Structured Query Language. Introducing ODBC. Creating an ODBC Data Source. Using Microsoft Query. Preparing to Create Queries. Creating Queries. Sorting Query Results. Filtering Data.
9. SQL Data Manipulation.
Adding Data. Adding Multiple Rows. Modifying Data. Deleting Data.
10. Introduction to ColdFusion Studio.
Understanding ColdFusion Studio. Using the Editor. Getting Help. Using Tags and Expressions. Accessing ColdFusion Application Server Services. Configuring Studio.
11. ColdFusion Basics.
Using Templates. Understanding ColdFusion Templates. Passing Parameters to Templates. Creating Data-Driven Templates. Understanding Data-Driven Templates. Using Drill-Down Applications. Building Dynamic SQL Statements. Creating Frames for Use with ColdFusion. Displaying Results in Tables. Grouping Query Results. Specifying Field Types.
12. ColdFusion Forms.
Using Forms. Creating Forms. Processing Form Submissions. Creating Dynamic SQL Statements. Building Truly Dynamic Statements. Creating Dynamic Search Screens.
13. Using Forms to Add or Change Data.
Using a Web Browser as a Universal Client. Adding Data with ColdFusion. Introducing CFINSERT. Updating Data with ColdFusion. Introducing CFUPDATE. Deleting Data with ColdFusion. Reusing Forms. Creating a Complete Application. Using CFIF to Create Conditional Code.
14. Using the SQL Query Builder.
Understanding the SQL Query Builder. Generating SQL SELECT Statements. Using Query Builder SQL Statements. Generating Other SQL Statements.
15. Form Data Validation.
Understanding Form Validation. Using Server-Side Validation. Using Client-Side Validation. Putting It All Together.
16. The Report Writer.
Introducing Crystal Reports Professional. Creating Reports with Crystal Reports Professional. Embedding Reports into ColdFusion Templates. Customizing Reports On-The-Fly.
17. Debugging and Troubleshooting.
Debugging ColdFusion Applications. Understanding What Can Go Wrong. Debugging Web Server Configuration Problems. Debugging ODBC Driver Errors. Debugging SQL Statement or Logic Errors. Debugging ColdFusion Syntax Errors. Using the Document Validator. Debugging URL and Path Problems. Debugging Form Problems. Using the ColdFusion Debugging Options. Using the Studio Remote Debugger. Using the ColdFusion Log Files. Preventing Problems.
IV. ADVANCED COLDFUSION.
18. Working with Projects.
Understanding Projects. Using Projects.
19. Advanced SQL.
Using the DISTINCT Keyword. Using Column Aliases. Using Aggregate Functions to Report on Your Data. Combining SQL Statements. Working with Null Values. Using Views to Simplify and Reuse Your Queries. Using Scalar Functions to Manipulate Data Row-by-Row.
20. Working with Stored Procedures.
Why Use Stored Procedures? Calling Stored Procedures from ColdFusion Templates. Creating Stored Procedures.
21. Advanced ColdFusion Templates.
Reusing Code. Organizing Your Code. Browsing "Next n" Records. Caching Query Results.
22. Lists, Arrays, and Structures.
Using Advanced Data Types. Working with ColdFusion Lists. Working with ColdFusion Arrays. Working with ColdFusion Structures.
23. Enhancing Forms with CFFORM.
Working with CFFORM. Using CFFORM. Using CFSELECT. Using CFINPUT. Using CFTEXTINPUT. Using CFSLIDER. Using CFTREE and CFTREEITEM. Using CFGRID. Using CFAPPLET.
24. Interacting with Email.
Generating SMTP Mail. Including Query Results in Email. Sending Email to a List of People. Using HTML to Make Your Email Look Better. Sending Attachments with Your Email. Using CFPOP. Creating a Complete Mail Client. Mail Daemons. Working with Attachments.
25. Online Commerce.
Leveraging the Internet with ColdFusion. Understanding the Mechanics of Internet Commerce. Building the QuickStore Application. Using Payment Processing Systems.
26. Web Application Framework.
Introducing the Web Application Framework. Using the Application Template. Addressing the Web's Statelessness.
27. Session Variables and Cookies.
Using Client-State Management Techniques. Using ColdFusion Client and Session Management. Using Cookies.
28. Working with Files and Directories.
Manipulating Files and Directories. Understanding the CFFILE Tag and Its Attributes. Uploading Files Using the CFFILE Tag. Accessing the Local File System with CFFILE. Reading and Writing Files with CFFILE. Directory Manipulation with CFDIRECTORY.
29. Full-Text Searching with Verity.
Getting to Know Verity. Creating a Search Tool for Your Documents. Indexing Data. Maintaining Collections. Administrating Collections with CFCOLLECTION. Understanding Verity's Search Syntax.
30. Directory Services.
Understanding Directory Services. Understanding LDAP. Understanding CFLDAP. Retrieving Data with CFLDAP. Using CFLDAP. Accessing Public LDAP Servers. Creating an LDAP Client. Creating the Services List. Adding, Modifying, and Deleting LDAP Entries.
31. Version Control.
Using Revisions Control. Understanding Version Control. Using Versions 2.0. Using ColdFusion Studio Source Control Integration.
32. Event Scheduling.
Scheduling Template Execution. Using the Administrator to Create Tasks. Using the Administrator to Edit Tasks. Programming Control Tasks with the CFSCHEDULE Tag. Dynamically Creating Static Pages. Logging Scheduled Events.
V. APPENDIXES.
Appendix A. ColdFusion Tag Reference.
CFABORT. CFAPPLET. CFAPPLICATION. CFASSOCIATE. CFAUTHENTICATE. CFCOLLECTION. CFCONTENT. CFCOOKIE. CFDIRECTORY. CFERROR. CFEXIT. CFFILE. CFFORM, /CFFORM. CFFTP. CFGRID, CFGRIDCOLUMN, CFGRIDROW, /CFGRID. CFGRIDUPDATE. CFHEADER. CFHTMLHEAD. CFHTTP, CFHTTPPARAM, /CFHTTP. CFIF, CFELSEIF, CFELSE, /CFIF. CFINCLUDE. CFINDEX. CFINPUT. CFINSERT. CFLDAP. CFLOCATION. CFLOCK, /CFLOCK. CFLOOP, CFBREAK, /CFLOOP. CFMAIL, /CFMAIL. CFMODULE. CFOBJECT. CFOUTPUT, /CFOUTPUT. CFPARAM. CFPOP. CFQUERY, /CFQUERY. CFREGISTRY. CFREPORT, /CFREPORT. CFSCHEDULE. CFSCRIPT, /CFSCRIPT. CFSEARCH. CFSELECT, /CFSELECT. CFSET. CFSETTING. CFSLIDER. CFSTOREDPROC, CFPROCPARAM, CFPROCRESULT, /CFSTOREDPROC. CFSWITCH, CFCASE, /CFCASE, CFDEFAULTCASE, /CFDEFAULTCASE, /CFSWITCH. CFTABLE, CFCOL, /CFTABLE. CFTEXTINPUT. CFTHROW. CFTRANSACTION, /CFTRANSACTION. CFTREE, CFTREEITEM, /CFTREE. CFTRY, CFCATCH, /CFCATCH, /CFTRY. CFUPDATE. CFWDDX.
Appendix B. ColdFusion Function Reference.
Using ColdFusion Functions. String Manipulation Functions. Date and Time Functions. Data Formatting Functions. Mathematical Functions. International Functions. List Manipulation Functions. Array Manipulation Functions. Structure Manipulation Functions. Query Manipulation Functions. Security Functions. System Functions. Client Variable Manipulation Functions. Expression Evaluation Functions. Bit and Set Manipulation Functions. Miscellaneous Functions.
Appendix C. Verity Search Language Reference.
Using Angle Brackets Around Operators. Operators Are Not Case Sensitive. Using Prefix Instead of Infix Notation. Searching for Special Characters as Literals. Understanding Concept Operators. Understanding Evidence Operators. Understanding Proximity Operators. Understanding Relational Operators. Understanding Score Operators.
Index.
