| Acknowledgments | xvii |
| Introduction | xix |
Part I | Setting the Table: Get Cookin' with Dreamweaver MX | |
Chapter 1 | Dreamweaver MX: Cleaner, Whiter, Brighter | 3 |
| Installation Checklist | 4 |
| Installing Dreamweaver MX | 5 |
| Setting Up the Getting Started Lessons | 7 |
| New and Improved Features | 10 |
| Summary | 23 |
Chapter 2 | Utensils: Choosing the Right Tools for the Job | 25 |
| Which Server Model? | 26 |
| Installing a Web Server | 30 |
| Installing an Application Server | 37 |
| Summary | 43 |
Chapter 3 | Ingredients: The Care and Feeding of Databases | 45 |
| File-based vs. Client/Server Databases | 46 |
| Installing the Database Software | 47 |
| Understanding Relational Databases | 50 |
| Using Access Projects | 55 |
| How to Deploy and Manage Remote Databases | 60 |
| Summary | 66 |
Chapter 4 | Organizing Your Kitchen: The Macromedia Workflow | 67 |
| Fireworks MX Integration | 68 |
| TopStyle Pro Integration | 73 |
| HomeSite+ Integration | 78 |
| Summary | 83 |
Part II | Appetizers: Some Recipes to Get You Started | |
Chapter 5 | Advanced Contact Form | 87 |
| Setting Up the Newman Zone Site | 88 |
| Defining the Site in Dreamweaver MX | 90 |
| Understanding Conditional Regions | 94 |
| Building the Page Blocks | 97 |
| The Confirmation Message | 101 |
| Sending E-mail | 103 |
| Form Validation | 113 |
| Error-Handling | 114 |
| Summary | 120 |
Chapter 6 | Advanced Guestbook | 121 |
| Setting Up the Newman Zone Database | 122 |
| The View Guestbook Page | 126 |
| The Sign Guestbook Page | 131 |
| Summary | 140 |
Chapter 7 | Filtering Recordsets Using Parameter Queries | 143 |
| The Downloads Table | 144 |
| The DownloadCats Table | 146 |
| Creating the Parameter Query | 147 |
| The qDownloadCats Query | 151 |
| Building the Downloads Page | 152 |
| Summary | 161 |
Chapter 8 | Filtering Recordsets Using Stored Procedures | 163 |
| Queries, Views, and Stored Procedures | 165 |
| Your First Stored Procedure | 166 |
| Creating the ODBC Data Source | 174 |
| Creating the ColdFusion Data Source | 175 |
| Revising the Downloads Page | 176 |
| Summary | 179 |
Chapter 9 | Download Counter | 181 |
| Revising the Downloads Page | 182 |
| Forcing the "Save As" Dialog Box | 184 |
| Creating the Downloads Response Page | 185 |
| Incrementing the Download Counter | 190 |
| Summary | 197 |
Chapter 10 | News Section | 199 |
| The News Table | 200 |
| Building the News Page | 201 |
| Revising the Home Page | 206 |
| Summary | 212 |
Part III | Entrees: Building a Data-Driven Web Application | |
Chapter 11 | Preparation and Planning | 217 |
| Defining the Site's Structure | 220 |
| Designing the Front End | 220 |
| Designing the Back End | 231 |
| Testing Usability | 234 |
| Publishing and Maintaining the Site | 237 |
| Summary | 237 |
Chapter 12 | Insert Record and Retrieve Identity | 239 |
| Retrieving the Identity Column | 240 |
| Setting Up the Realty Database | 244 |
| Building the Add Listing Page | 246 |
| Building the Response Page | 255 |
| Summary | 260 |
Chapter 13 | Uploads Made Simple | 263 |
| The Trouble with Multipart/Form-Data | 264 |
| Revising the Add Listing Page | 267 |
| The Add Listing Details Page | 276 |
| Summary | 281 |
Chapter 14 | Preview Image Before Upload | 283 |
| Revising the Add Listing Page | 284 |
| Creating the Preview Page | 290 |
| Reusing the Preview Image Code | 300 |
| Summary | 301 |
Chapter 15 | Batch Deletes | 303 |
| The Dangers of DELETE Statements | 304 |
| The Links Page | 305 |
| The Admin Listings Page | 310 |
| Creating the Delete Listing Page | 312 |
| Summary | 323 |
Chapter 16 | Batch Updates | 325 |
| Using UPDATE Statements | 326 |
| The Edit Listing Details Page | 328 |
| Creating the Batch Update Page (ASP) | 333 |
| Creating the Batch Update Page (ColdFusion) | 337 |
| Summary | 341 |
Chapter 17 | Nested Repeat Regions | 343 |
| Understanding the Table Relationships | 344 |
| The Links Page (ASP) | 348 |
| The Links Page (ColdFusion) | 352 |
| The Listing Details Page | 356 |
| Summary | 365 |
Chapter 18 | Online HTML Editors | 367 |
| Using PD On-Line HTML Editor (ASP) | 368 |
| Using ActivEdit (ColdFusion) | 379 |
| Summary | 388 |
Chapter 19 | User Authentication | 389 |
| Understanding Sessions | 390 |
| The User Login Page | 393 |
| The Logout Page | 399 |
| Revising the Current Listings Page | 400 |
| The Reminder Page | 402 |
| Summary | 409 |
Chapter 20 | Admin Section | 411 |
| Revising the Listing Details Page | 412 |
| Revising the Current Listings Page | 413 |
| Revising the Edit Listing Details Page | 415 |
| Revising the Add Listing Page | 418 |
| The Add Realtor Page | 421 |
| The Edit Listing Page | 427 |
| Summary | 429 |
Appendix A | Sample Code | 431 |
Appendix B | Ingredients | 435 |
| Index | 437 |