Table of 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.

Promotional Information

This concise, example-rich guide teaches Web designers and other graphics professionals exactly what they need to know to build top-quality Web applications with ColdFusion 4.5 -- fast. Endorsed by the World Organization of Webmasters, Essential ColdFusion 4.5 for Web Professionals offers no-nonsense, practical coverage designed around actual application examples. Working Web professionals learn ColdFusion by building real-world applications for a fictitious company -- and checking your work against finished applications deployed on a companion Web site. Along the way, you'll learn each component of a working ColdFusion solution, mastering the most widely used ColdFusion tags and functions as you create increasingly sophisticated applications. Coverage includes: database integration, online catalogs, sending email and interacting with users, providing site search features, and more. The book also includes a thorough introduction to developing e-commerce applications for WAP enabled cell phones and wireless PDAs.

About the Author

Micah Brown currently owns and operates WebStalkers.com located in the Los Angeles area where he develops web and wireless applications. Sites he has developed include Dr. Laura, Pacific Bell, and Ascend Communications. Mike Fredrick is an Internet Applications Developer for Polaris Industries, and proprietor of the ColdFusion-based PolarisMan.com, one of the Web's leading resources for Polaris snowmobilers.