Essential ColdFusion 4.5 for Web Professionals

You'll learn all this and much more-hands-on!

• Database access and integration
• Building online catalogs, step-by-step
• Automating email and user interaction
• Providing site search capabilities
• Integrating ColdFusion with WAP and web-clipping technologies to build applications for WAP-enabled phones as well as wireless Palm devices

All these books share the same great format and the same dynamic Web site ... so once you've used one, learning from the others is a piece of cake!

Contents

1. Database Basics.
A Look at Relational Databases. Introduction to SQL. To Quote or Not to Quote? Project I: Creating an Access Database File. Setting Up an ODBC Connection1. Windows Control Panel. ColdFusion Administrator. Project II: Retrieving Data. SQL Builder. Recap.

2. ColdFusion Basics.
Commenting Your Code. Using Quotes. . Passing Variables. VARIABLES. URL. FORM. COOKIE. ATTRIBUTES. SESSION. CGI. APPLICATION. CLIENT. SERVER. Scope. Project I: Passing Variables Between Pages. . . . Now Function. Date Functions. DateFormat. TimeFormat. Project II: Display Days Left Until a User-Defined Date. DateDiff. IsDefined. Replace. Project III: Using . Recap. Advanced Project.

3. Global Templates.
Defining the Application File (application.cfm). . . Project I: Setting Global Values for Your Site. Project II: Defining Header and Footer Files. . Recap. Advanced Project.

4. Building an Online Catalog.
Building an Administration Screen. Setting Up the Administration Screen. Project I: Viewing Items in Your Database. DollarFormat Function. CurrentRow. MOD. IIF. RecordCount. Project II: Uploading Files to Your Site. . . Project III: Adding Records to Your Database. Project IV: Editing an Existing Record in Your Database. Project V: Processing the Information. Adding a Record. . Updating a Record. . Deleting a Record. Project VI: User Pages. Recap. Advanced Project.

5. Sending Email.
. . . and Tags. Project I: Sign Up! . Project II: Retrieving Your Email from a POP Server. Recap. Advanced Project.

6. Searching the Site.
PreserveSingleQuotes. and . . . Project I: Search Engines 'R' Us. Using Verity with ColdFusion. . . . Project II: Collection Management. Project III: Searching with Verity. . Recap. Advanced Project.

7. Knowing Who's Who.
Security Basics. Project I: Protect Your Management Templates. Adding a Table to the shelleyCatalog Database. C Is for Cookie. Project II: Enhanced Functionality with . Recap. Advanced Project.

8. Using Custom Tags. Introduction to Custom Tags. The Ins and Outs of Custom Tags. Where Can I Use Custom Tags? Project I: Counting Your Hits. SCRIPT_NAME Variable. Adding the Hits Table to the shelleyCatalog Database. Project II: Creating a Random Product Custom Tag. ListLen Function. ListAppend Function. ListGetAt Function. Other Functions Used in this Project. RandRange Function. Option 1-Code Every Page. Option 2-Make Use of the Developer's Friend, the Application.cfm File. Recap. Advanced Project.

9. ColdFusion and Wireless.
What Is WAP and How Is It Useful? Limitations. MIME Types. Internet Information Server 4 and 5. Personal Web Site (PWS). . Project I: WAP-Enabled Product List. Wireless Palm(tm) Series of Handhelds. Limitations. Palm Query Application. Project II: Palm(tm)-Enabled Product List. META Tags. Building and Installing the Palm(tm) Query Application. Recap. Advanced Project.

Appendix A. An Introduction to Forms.
GET. POST. Buttons. Two Types of Buttons. Single-Line Text Box. Scrolling Text Box. Menus. Check Boxes. Radio Buttons. Putting It All Together.

Appendix B. ColdFusion Reference.

Index.