ColdFusion MX Developer's Cookbook (Developer's Library)

ColdFusion is a rapid application development tool used to create Web sites throughout the Internet. The product's ease of use and capabilities allow even inexperienced developers to rapidly produce basic Web sites. The ColdFusion MX Developer's Cookbook focuses upon teaching the use of ColdFusion's advanced features in the development of more complex Web sites -- Web sites that interact with other sites on the Internet, that are data-driven rather than static, and that are not necessarily confined to one server. Though the basics of ColdFusion are easily picked up by even novice programmers, many encounter difficulties when they attempt to master more advanced features because they lack formal training. The ColdFusion MX Developer's Cookbook provides recipes and insights into ColdFusion, and along the way teaches some of the fundamentals of the development process. The recipes serve as templates for database access, custom tags, scripting, generating charts and graphs, and linking into other resources on the Web using SOAP and .NET. 0672324628......Page 1 Copyright © 2003 by Sams Publishing......Page 5 Contents at a Glance......Page 7 Table of Contents......Page 9 About the Authors......Page 20 We Want to Hear from You!......Page 22 How to Use This Book......Page 24 PART I Datatypes and Containers......Page 28 1.1. Concatenating Strings......Page 30 1.2. Delimiting Strings......Page 31 1.3. Using ASCII Character Codes......Page 32 1.4. Forming Substring......Page 33 1.5. Encrypting Strings......Page 35 1.6. Hashing Strings......Page 36 1.7. Iterating Through a String......Page 37 1.8. Reading a File Line by Line......Page 38 1.9. Searching a String......Page 39 1.10. Replacing Substrings within a String......Page 40 1.11. Using REFind() to Perform a Literal String Search......Page 41 1.12. Using Qualifiers to Indicate Multiplicity......Page 42 1.14. Using Brackets......Page 43 1.16. Escaping Special Characters......Page 44 1.17. Using Character Classes......Page 45 2.1. Creating Lists......Page 46 2.2. Changing Delimiters......Page 47 2.3. Extracting Elements......Page 48 2.4. Handling Empty Values......Page 49 2.5. Changing Values in a List......Page 51 2.6. Searching a List......Page 52 2.8. Adding Qualifiers to a List......Page 53 2.9. Looping Through a List......Page 54 2.10. Looping Over a Structure’s Key List......Page 55 2.11. Looping Until a List Is Empty......Page 56 2.12. Parsing Input Forms......Page 57 3.1. Creating an Array......Page 60 3.2. Adding an Element to an Array......Page 61 3.3. Displaying a Value in an Array......Page 62 3.4. Looping over an Array......Page 63 3.6. Sorting an Array......Page 64 3.7. Multidimensional Arrays......Page 67 3.8. Creating Arrays with More Than Three Dimensions......Page 68 3.9. Array Aggregate Functions......Page 69 3.10. Array Utility Functions......Page 70 3.11. Array Information Functions......Page 71 4.0. Introduction......Page 74 4.2. Using Structure Information Functions......Page 75 4.3. Using Structure Management Functions......Page 76 4.4. Inserting Values into a Structure......Page 78 4.5. Updating Values in a Structure......Page 79 4.6. Displaying the Value of an Element in a Structure Using the Key Name......Page 80 4.7. Using Dot Notation......Page 81 4.8. Looping Over a Structure......Page 82 4.9. Using Structure Utility Functions......Page 83 4.10. Copying Structures......Page 84 4.11. Sorting Structures......Page 86 5.1. Querying a Database......Page 90 5.2. Programmatically Creating Queries......Page 92 5.3. Displaying Query Results......Page 93 5.4. Using Query Variables......Page 94 5.5. Creating Queries of Queries......Page 96 5.6. Converting a Query Column to a List......Page 98 5.7. Caching a Query......Page 99 6.1. Creating a Date,Time, or DateTime Object......Page 102 6.2. Formatting Dates......Page 103 6.3. Comparing Dates......Page 105 6.4. Determining Date Differences......Page 106 6.5. Formatting Times......Page 107 6.6. Defining Time Spans......Page 108 6.7. Using Date Information Functions......Page 109 6.8. Managing Dates and Times in Different Locales......Page 111 PART II Controlling Application Flow......Page 112 7.1. Creating a ColdFusion Application......Page 114 7.2. Using the Application Variable Scope......Page 117 7.3. Implementing Session Management......Page 118 7.4. Implementing Client Management......Page 119 7.5. Storing Client State Using the Registry......Page 120 7.6. Storing Client State Using Cookies......Page 121 7.7. Storing Client State Using a Database......Page 122 8.0. Introduction......Page 124 8.1. Catching Exceptions......Page 126 8.2. Catching Multiple Exceptions......Page 127 8.3. Examining an Exception......Page 128 8.4. Throwing Exceptions......Page 130 8.5. Re-Throwing Exceptions......Page 131 PART III Using Utility Tags......Page 134 9.1. Creating a Simple Chart......Page 136 9.2. Managing the Chart Container......Page 137 9.3. Managing Chart Series......Page 140 9.5. Populating Charts with Query Values......Page 144 9.6 Implementing Click-Through Behaviors in Charts......Page 145 9.7 Administering Charts Through the ColdFusion Administrator......Page 146 10.1. Reading Files......Page 148 10.2. Writing Files......Page 149 10.3. Appending to Files......Page 150 10.4. Uploading Files......Page 152 10.5. Manipulating Files......Page 155 10.6. Listing Directories......Page 157 10.7. Manipulating Directories......Page 159 11.1. HTTP Requests......Page 160 11.3. Receiving Email......Page 163 11.4. Querying an LDAP Directory......Page 164 11.5. Adding an LDAP Entry......Page 166 11.6. Updating an LDAP Entry......Page 167 11.7. Adding and Deleting an LDAP Entry’s Attributes......Page 168 11.8. Renaming an Entry......Page 169 11.10. Sending a File via FTP......Page 170 11.11. Getting a File via FTP......Page 171 12.1. Creating a Collection......Page 174 12.2. Adding Information to a Verity Collection......Page 175 12.3. Searching a Verity Collection with Simple Search......Page 178 12.4. Searching a Verity Collection with Explicit Search......Page 180 13.0. Introduction......Page 182 13.2. Logging out a User......Page 183 13.3. Authenticating a User......Page 184 13.5. Authorizing a Block of Code......Page 185 13.6. Authorizing a Function......Page 187 13.7. Authentication Example......Page 188 PART IV Database Integration......Page 202 14.0. Introduction......Page 204 14.2. Updating Data......Page 206 14.3. Deleting Data......Page 207 14.5. Limiting Rows Returned......Page 208 14.6. Specifying Multiple Conditions......Page 209 14.8. Using Aliases......Page 210 14.9. Selecting from Multiple Tables......Page 211 14.11. Joining Three Tables......Page 212 14.12. Grouping Data with CFOUTPUT......Page 213 14.13. Performing Outer Joins......Page 214 14.15. Using Aggregate Functions......Page 215 14.16. Grouping Aggregate Data......Page 216 14.18. Using the IN Keyword......Page 217 14.19. Using IN with Web Forms......Page 218 14.20. Matching a Wildcard Pattern......Page 219 14.21. Matching a Single Character......Page 220 14.23. Matching a Range of Characters......Page 221 14.25. Excluding a Range of Characters......Page 222 14.26. Using Prepared Statements......Page 223 15.0. Introduction......Page 226 15.1. Writing a Simple Stored Procedure in Microsoft SQL Server......Page 227 15.2. Writing a Simple Stored Procedure in Oracle......Page 228 15.3. Invoking a Simple Stored Procedure......Page 229 15.4. Writing a Stored Procedure with Parameters in Microsoft SQL Server......Page 230 15.5. Writing a Stored Procedure with Parameters in Oracle......Page 231 15.6. Invoking a Stored Procedure with Parameters......Page 232 15.7. Using Output Parameters......Page 234 15.8. Working with Multiple Result Sets......Page 236 PART V Language Extensibility Features......Page 238 16.0. Introduction......Page 240 16.1. Declaring a Function......Page 241 16.2. Function Arguments......Page 243 16.4. Suppressing Output......Page 245 16.5. Recursive Functions......Page 246 16.6. Working with Function References......Page 248 17.1. Creating a Simple Custom Tag......Page 252 17.3. Using Attributes......Page 253 17.4. Returning a Result......Page 254 17.5. Adding Start and End Tags......Page 255 17.6. Building Nested Tags......Page 257 17.7. Encoding Custom Tags......Page 258 17.8. Using ......Page 259 17.9. Using ......Page 260 18.0. Introduction......Page 262 18.1. Creating a Simple Java CFX Tag......Page 263 18.2. Using Tag Attributes......Page 264 18.3. Setting ColdFusion Variables......Page 267 18.4. Using Queries in Java CFX Tags......Page 268 18.5. A Simple C++ CFX Tag......Page 270 18.6. Using Tag Attributes......Page 273 18.7. Setting ColdFusion Variables......Page 274 18.8. Using Queries in C++ CFX Tags......Page 276 18.9. Installing a Java CFX Tag......Page 279 18.10. Installing a C++ CFX Tag......Page 280 19.1. Defining a Component......Page 282 19.2 Instantiating a Component......Page 285 19.3. Invoking a Component Method......Page 286 19.4. Component Inheritance......Page 288 19.5. Accessing a Component......Page 290 19.6. Using Component Meta Data......Page 291 20.1. Creating a Java Object Instance......Page 294 20.2. Invoking Methods on an Object......Page 296 20.4. Working with Java Objects......Page 298 20.5. Working with COM Objects......Page 299 20.6. Working with CORBA Objects......Page 300 21.1. CFML to WDDX......Page 304 21.2. CFML to JavaScript......Page 306 21.3. WDDX to CFML......Page 308 21.4. WDDX to JavaScript......Page 309 21.5. Syndicating Content with WDDX......Page 310 21.6. Converting a Java Object into WDDX......Page 313 21.7. Deserializing WDDX in Java......Page 315 22.1. Creating an XML Object with the Tag......Page 318 22.2. Creating an XML Object with the XmlNew() Function......Page 319 22.3. Creating an XML Object from Another XML Object......Page 321 22.5. Accessing Attributes......Page 322 22.7. Accessing Inner Text......Page 323 22.8. Searching XML with XPath......Page 324 22.9. XSL Transformations......Page 325 23.0. Introduction......Page 328 23.1. Invoking a Web Service with CFINVOKE......Page 329 23.2. Creating an Instance of a Web Service......Page 330 23.3. Writing a Web Service......Page 331 23.4. Using Properties......Page 332 23.5. Deploying a Web Service......Page 334 23.6. Invoking a Web Service with .NET......Page 335 23.7. Invoking a Web Service with Java......Page 338 24.0. Introduction......Page 340 24.2. Including a Servlet or JSP......Page 341 24.3. Accessing ColdFusion Pages from Servlets and JSPs......Page 342 24.4. Sharing Data Between ColdFusion and Servlets/JSPs......Page 343 24.5. Accessing Enterprise Java Beans......Page 345 PART VI Appendixes......Page 350 ColdFusion Web Sites......Page 352 XML Web Sites......Page 354 Other Useful Web Sites......Page 355 Session Hijacking......Page 356 URL Injection Hacking......Page 357 Denial of Service Attacks......Page 358 Cross Site Scripting......Page 359 Security Resources......Page 360 ColdFusion Settings Migration Wizard......Page 362 References......Page 363 The Tag......Page 364 Loops......Page 366 Switch Statements......Page 368 Exception Handling......Page 369 Index......Page 372 This text is an examples-based reference for intermediate-level ColdFusion developers. The book teaches the use of ColdFusion's advanced features in the development of complex Web sites, providing recipes for database access, custom tags, scripting generating charts and linking to Web resources