You are previewing Inside ColdFusion™ MX.
O'Reilly logo
Inside ColdFusion™ MX

Book Description

The most comprehensive guide to learning and maximizing the latest version of ColdFusion. Inside ColdFusion MX begins with a discussion of ColdFusion MX and how it differs from previous versions of ColdFusion. The authors discuss the new ColdFusion Administration/Administration, integration with existing IDE's, recent language extensions, and the planning and development of ColdFusion applications under the new CF architecture. The book delves into a detailed discussion of the CFML language, the heart-and-soul of ColdFusion application development, including real-world example code and discussion on how to solve common problems. Coverage includes advanced application development topics, such as exception handling, interacting with other application/server resources, and extending ColdFusion MX with other technologies. The book discusses complex topics in an easy-to-follow and easy-to-understand way, focusing on the questions developers will ask when using the book for problem-solving.

Table of Contents

  1. Copyright
    1. Dedication
  2. About the Authors
  3. About the Contributors
  4. About the Technical Reviewers
  5. Acknowledgments
  6. Tell Us What You Think
  7. Introduction
    1. Who This Book Is For
    2. Overview
    3. Conventions
  8. 1. ColdFusion Starts Here
    1. The History
    2. ColdFusion MX Overview
      1. Understanding the New ColdFusion
      2. New Technology Brief
    3. Summary
  9. 2. Preparing Your Environment
    1. Installing and Configuring ColdFusion
      1. Installing ColdFusion MX on Windows
      2. Installing ColdFusion MX on UNIX Systems
      3. Summary
    2. Working with Dreamweaver MX
      1. Dreamweaver MX Workspace
      2. Creating Sites in Dreamweaver MX
      3. Connecting to Datasources in Dreamweaver MX
      4. Creating Queries in Dreamweaver MX
      5. Displaying Dynamic Content
      6. Debugging in Dreamweaver MX
      7. ColdFusion Components in Dreamweaver MX
    3. Integration of ColdFusion Studio
      1. Getting to Know ColdFusion Studio
        1. The Studio Interface
      2. Using ColdFusion Studio
        1. Tag Insight, Function Insight, and Tag Completion
        2. Expression Builder
        3. Query Builder
        4. Using Code Snippets
        5. Code Sweepers
        6. Remote Development Services (RDS) and Development Mappings
        7. Working with Projects
          1. Understanding Projects
          2. Creating a Project
          3. Working with Projects
          4. Deploying a Project
        8. Debugging in ColdFusion Studio
      3. Customizing ColdFusion Studio
        1. Custom QuickBar
        2. Keyboard Shortcuts
      4. Summary
    4. Summary
  10. 3. Before You Begin Coding—Application Planning
    1. Application Architecture
      1. Understanding Tiered Architecture
        1. Two-Tier Architectures
        2. N-Tier Architectures
    2. Application Layers
      1. The Presentation Layer
        1. The UI
          1. Layout
          2. Colors
          3. Screen Resolution
          4. Fonts
          5. Images
          6. Client-Side Scripting
          7. Browser Compatibility
      2. The Business Layer
        1. Business Rules
        2. Business Process Logic
      3. Data Interface Layer
      4. Data Layer
      5. Summary
    3. Resource Planning
      1. Environment Considerations
        1. OSs
        2. Choosing a Database
      2. Assessing the Needs of Your Application
      3. Planning Ahead for Scalability
      4. Summary
    4. Development Methodologies
      1. Fusebox
        1. Core Files
        2. Fusedocs
        3. Fusebox Basics
        4. Fusebox Conventions
        5. Encapsulation
        6. Summarizing Fusebox
      2. cfObjects
        1. Classes
        2. Methods
      3. SmartObjects
      4. Other Established Methodologies
        1. Switch_box
        2. BlackBox
      5. Developing a Personal Methodology
      6. Summary
    5. Summary
  11. 4. Fundamentals of ColdFusion Development
    1. Basic CFML
      1. ColdFusion Development Process
      2. Tag Syntax
        1. Comments
        2. Data Types
        3. Variables
          1. Variable Scopes
        4. Expressions
        5. Operators
        6. Functions
      3. Summary
    2. Bringing Data to the Browser
      1. Outputting Values
      2. Looping
        1. Looping with CFLOOP
          1. Index Loop
          2. Conditional Loop
          3. Query Loop
          4. List Loop
          5. Collection Loop
          6. Ending a Loop
        2. Looping with CFOUTPUT
      3. Conditional Processing Logic
        1. IF Statements
        2. SWITCH Statements
        3. IIf Inline Conditional Processing
      4. Summary
    3. Interacting with Database Records
      1. Understanding Datasources
      2. Selecting and Displaying Data
      3. Inserting Records—CFINSERT
      4. Updating Records—CFUPDATE
      5. Deleting Records
    4. Summary
  12. 5. Reusing Code
    1. CFINCLUDE
    2. Custom Tags
    3. CFX Custom Tags
    4. User-Defined Functions (UDFs)
      1. Using UDFs
      2. Advanced UDF Concepts
      3. Usage Considerations for UDFs
    5. Summary
  13. 6. ColdFusion Components
    1. Building Your First CFC
      1. Creating CFCs
      2. CFC Interaction
        1. Using CFINVOKE
        2. Interacting with CFC Using Forms
        3. CFCs Using URLs
        4. Using CFScript with CFCs
        5. Using Component Using the Flash Gateway
      3. Retrieving CFC Output
      4. Summary
    2. Advanced ColdFusion Component Development
      1. Dealing with Exceptions in CFCs
      2. Securing Your CFCs
      3. Building Role-Based Component Method Security
      4. ColdFusion Component Packages
      5. Component Inheritance
      6. ColdFusion Components and Metadata
      7. Summary
    3. Summary
  14. 7. Complex Data Types
    1. Using CFDUMP
    2. Queries
      1. Creating Query Objects
      2. Outputting Query Objects
    3. Lists
      1. Creating a List
      2. Outputting a List
      3. List Functions
        1. Creating a List Dynamically
    4. Arrays
      1. Creating an Array
      2. Adding Elements to an Array
      3. Outputting an Array
      4. Array Functions
    5. Structures
      1. Creating a Structure
      2. Adding Elements to a Structure
      3. Outputting a Structure
      4. Structure Functions
    6. Summary
  15. 8. Application Framework
    1. Web Statelessness
    2. Locking Shared Variable Access
      1. Using CFLOCK
      2. When to Lock
      3. ColdFusion Lock Checking
    3. Application Framework
      1. Applicationwide Settings
        1. Application.cfm
        2. OnRequestEnd.cfm
      2. Custom Error Handling
      3. Application Security
      4. Enabling Variable Scopes
    4. Application Variables
      1. CFAPPLICATION Tag
      2. Using Application Variables
    5. Session Variables
    6. User Sessions
      1. Understanding Session Variables
      2. Enabling Session Variables
      3. Using Session Variables
      4. Ending a User Session
    7. Server Variables
    8. Cookies
      1. Understanding Cookies
      2. Using Cookies
    9. Client Variables
      1. Understanding Client Variables
      2. Enabling Client Variables
      3. Storing Client Variables
      4. Using Client Variables
    10. Summary
  16. 9. Error Handling
    1. Error Types
      1. Runtime Errors
      2. Compiler Errors
      3. Input Errors
      4. Missing Template Errors
    2. Try/Catch/Throw Routines
      1. Try/Catch
      2. Using CFTHROW
    3. Custom Errors
      1. Using CFERROR
    4. Site-Wide Error Handlers
    5. Summary
  17. 10. Regular Expressions
    1. Basic Syntax
    2. Metacharacters
    3. POSIX Character Classes
    4. Finding Strings
    5. Replacing Strings
    6. Summary
  18. 11. Working with Email
    1. Preparing Your Environment
    2. CFMAIL
      1. Attaching Files to Your Messages
    3. CFPOP and Message Management
    4. Summary
  19. 12. Working with Files
    1. CFFILE
      1. Uploading Files to the Server
    2. CFFTP
    3. CFDIRECTORY
    4. CFREGISTRY
      1. ACTION="getAll"
      2. ACTION="get"
      3. ACTION="set"
      4. ACTION="delete"
    5. Summary
  20. 13. CFScript
    1. Benefits
    2. CFScript Syntax
    3. Commenting Code
    4. Conditional Programming
    5. Working with Data Structures
    6. Looping
    7. For Loop
      1. For-In
      2. while
    8. do-while
    9. break
      1. continue
      2. switch
    10. Functions
    11. Output
    12. Handling Exceptions
      1. CFScript Exception Syntax
    13. Summary
  21. 14. Debugging
    1. Debugging and the ColdFusion Administrator
      1. Debugging Settings Page
      2. Debugging IP Address Restrictions
    2. CFTRACE
    3. Summary
  22. 15. CFML Coding: Best Practices
    1. Considering Code Maintenance
      1. Comment, Comment, Comment
      2. Use CFSCRIPT for Long Variable Assignment Blocks
      3. Scope All Variables
    2. Coding for Performance
      1. Locking of Server, Application, and Session Variables
      2. Assigning Values to Application Variables for Each Page Request
      3. Overuse of CFOUTPUT
      4. Avoid Using Subqueries
      5. Use CFPARAM to Set Default Values
      6. Use CFSWITCH Instead of Multiple CFIF Statements
      7. Two Function Calls to a Database to Retrieve the Unique ID of Inserted Records
      8. Do Not Overuse the # Symbol
      9. Replace() Function Instead of CFLOOP
      10. Use Function Calls Instead of Comparisons in CFIF Statements
      11. Reduce Whitespace with CFSETTING, CFSILENT, and CFPROCESSINGDIRECTIVE
      12. Request Scope
      13. Use Functions to Resolve Criteria
    3. Summary
  23. 16. Further Extending Your Applications
    1. Working the Web—the Power of CFHTTP and CFCONTENT
      1. CFHTTP
        1. Using CFHTTP to GET Information
        2. Creating a Query Object
        3. Posting Data
      2. Using CFCONTENT
      3. Summary
    2. CFOBJECT and COM
      1. A Little About COM and DCOM
      2. Working with COM Objects and ColdFusion
        1. Properties and Methods
      3. Best Practices When Using COM Objects
      4. Summary
    3. Flash Remoting with ColdFusion
      1. Flash and ColdFusion Templates
      2. Summary
    4. Summary
  24. 17. Common Application Development Requirements
    1. Application Security
      1. User Authentication
        1. Application.cfm
          1. Checking for Login
          2. Loginform.cfm
      2. Authorization
        1. Logging Out
      3. Summary
    2. Content Management
      1. Building an Application for Content Management
        1. Access to Content
          1. Creating Content
          2. Editing Content
        2. Content Workflow
          1. Defining Workflows
      2. Making Use of Existing Components
      3. Spectra Community Source (Brief Discussion)
      4. Competing Components
        1. CommonSpot Content Server
        2. soEditor
        3. CMS100
      5. Summary
    3. E-Commerce
      1. Building a Catalog
        1. Details
      2. Building a Shopping Cart
        1. Add to Cart/Update Cart
      3. Checkout and Payment Processing
      4. Summary
    4. Personalization
      1. Simple Personalization with ColdFusion
      2. Summary
    5. Summary
  25. 18. Enhancing Application Performance with Caching
    1. Caching Strategies
      1. Administrative Caching Options
        1. Template Cache Size
        2. Trusted Cache
        3. Limit Maximum Number of Cached Queries
        4. Summary of Administrative Caching Settings
      2. Query Caching
      3. CFCACHE
      4. Other Caching Methods
    2. Summary
  26. 19. Introduction to XML and ColdFusion MX
    1. XML 101
      1. Metadata
      2. Well-Formedness
    2. Understanding Document Type Definitions
      1. Element Declaration
      2. Character Data Content
      3. Any (or Mixed) Content
      4. Empty Content
      5. Element Content
      6. Attribute-List Declaration
    3. Working with XML Schemas
      1. Defining Elements
      2. Expressing Cardinalities of Elements
      3. Namespaces
      4. Comparison
      5. Wrapping Up
    4. XML Syntax Rules
    5. Creating XML
    6. Using XML with ColdFusion MX
    7. Summary
  27. 20. Advanced XML
    1. How ColdFusion Parses XML
      1. SAX
      2. DOM
      3. Working with the XML Document Object
      4. Adding, Deleting, and Modifying XML Elements
        1. Adding Elements
        2. Deleting Elements
    2. Using XML-Related Technologies
      1. Using XPath
        1. Location Paths
        2. Path Expressions
        3. XPath Axes
        4. Predicates
        5. XPath Expressions
      2. XSLT with ColdFusion
        1. Using XPath Functions in XSLT
          1. count
          2. number
          3. position
          4. substring
          5. sum
    3. Working with WDDX
      1. Validating WDDX Data
      2. Using JavaScript Objects
        1. Converting CFML Data to a JavaScript Object
        2. Transferring Data from the Browser to the Server
      3. Storing Complex Data
    4. Summary
  28. 21. Web Services and ColdFusion
    1. Web Service Basics
    2. Communication
    3. Description and Discovery
    4. Finding Web Services with UDDI
    5. Invoking a Web Service
    6. Building Web Services
    7. Other Web Service Options with ColdFusion
    8. Summary
  29. 22. Leveraging J2EE
    1. A Bit of Background on J2EE
    2. ColdFusion and JSP
      1. Using Tag Libraries
      2. Mixing JSPs and ColdFusion
    3. Working with Java Classes and Java Beans
    4. Dealing with Java Exceptions
    5. Working with EJBs
    6. Summary
  30. 23. Working with Databases
    1. Relational Databases
      1. Understanding Databases
      2. Keys
      3. Relationships
      4. Indexes
      5. Datasources
        1. ODBC
        2. JDBC Drivers
      6. Summary
    2. Working with SQL
      1. Understanding SQL
      2. Queries
        1. SELECT
        2. INSERT
        3. UPDATE
        4. DELETE
      3. The WHERE Clause
      4. Summary
    3. Stored Procedures
      1. CFSTOREDPROC
      2. CFPROCPARAM
      3. CFPROCRESULT
      4. Summary
    4. Transactions
      1. CFTRANSACTION
        1. BEGIN
        2. COMMIT
        3. ROLLBACK
      2. Summary
    5. Summary
  31. 24. Advanced Database Interaction
    1. Dynamic SQL
    2. Query Caching
    3. Query of Queries (CFSQL)
    4. Summary
  32. 25. Administering the ColdFusion Server
    1. Server Settings
      1. Settings
        1. Settings—Helpful Hints
          1. Limit Simultaneous Requests
          2. Timeout Requests After x Seconds
      2. Caching
        1. Caching—Helpful Hints
      3. Client Variables
      4. Memory Variables
      5. Mappings
      6. Mail Server
      7. Charting
      8. Java and JVM Settings
      9. Archives and Deployment
      10. Settings Summary
    2. Data and Services
      1. Data Sources
      2. Verity Collections
      3. Web Services
    3. Debugging and Logging
      1. Debugging Settings
      2. Debugging IP Addresses
      3. Logging Settings
      4. Logging Files
      5. Scheduled Tasks
      6. System Probes
      7. Code Analyzer
    4. Extensions
      1. Java Applets
      2. CFX Tags
      3. Custom Tag Paths
      4. CORBA Connectors
    5. Security
      1. CF Admin Password
      2. RDS Password
      3. Sandbox Security
        1. Step 1—Add a New Sandbox
        2. Step 2—Configuring Your New Sandbox
    6. Summary
  33. 26. Performance Optimization and Scalability Planning
    1. Measuring Performance
      1. How to Test for Performance
    2. Enhancing Scalability
      1. Linear Scalability Explained
    3. Load Testing
      1. Interpretation of Load Test Data
        1. Finding the Sweet Spot
      2. Testing Methodology
      3. Other Performance Considerations
    4. Summary
  34. 27. Migration to ColdFusion MX
    1. Using the Code Compatibility Analyzer
    2. Deprecated or Changed CFML Tags
    3. Deprecated or Changed CFML Functions
    4. Summary
  35. 28. ColdFusion Tips and Tricks
    1. Design for Reusability
    2. Validating Data Received from the Client
    3. Use Application.cfm to Make Your Code Faster and More Portable
    4. Using Session Variables with Care
    5. Protect Yourself
      1. Coding
      2. Testing
    6. Establishing Standard Prefixes in Your ColdFusion Code
    7. Server-Side Redirections in CFMX
    8. Group Totals and Details in One Database Query
    9. Storing and Displaying Hierarchical Data
    10. Summary
  36. A. Tag Reference
    1. CFABORT
      1. Description
      2. Attributes
    2. CFAPPLET
      1. Description
      2. Attributes
    3. CFAPPLICATION
      1. Description
      2. Attributes
    4. CFARGUMENT
      1. Description
      2. Attributes
    5. CFASSOCIATE
      1. Description
      2. Attributes
    6. CFAUTHENTICATE (Obsolete)
      1. Description
    7. CFBREAK
      1. Description
    8. CFCACHE
      1. Description
      2. Attributes
    9. CFCASE
      1. Description
    10. CFCATCH
      1. Description
    11. CFCHART (New in MX)
      1. Description
      2. Attributes
    12. CFCHARTDATA
      1. Description:
      2. Attributes:
    13. CFCHARTSERIES
      1. Description
      2. Attributes
    14. CFCOL
      1. Description
      2. Attributes
    15. CFCOLLECTION
      1. Description
      2. Attributes
    16. CFCOMPONENT
      1. Description
      2. Attributes
    17. CFCONTENT
      1. Description
      2. Attributes
    18. CFCOOKIE
      1. Description
      2. Attributes
    19. CFDEFAULTCASE
      1. Description
    20. CFDIRECTORY
      1. Description
      2. Attributes
    21. CFDUMP
      1. Description
      2. Attributes
    22. CFELSE
      1. Description
      2. Example
    23. CFELSEIF
      1. Description
      2. Example
    24. CFERROR
      1. Description
      2. Attributes
    25. CFEXECUTE
      1. Description
      2. Attributes
    26. CFEXIT
      1. Description
      2. Attributes
    27. CFFILE
      1. Description
      2. Attributes
    28. CFFLUSH
      1. Description
      2. Attributes
    29. CFFORM
      1. Description
      2. Attributes
    30. CFFTP
      1. Description
      2. Attributes
    31. CFFUNCTION
      1. Description
      2. Attributes
    32. CFGRAPH
      1. Description
    33. CFGRID
      1. Description
      2. Attributes
    34. CFGRIDCOLUMN
      1. Description
      2. Attributes
    35. CGGRIDROW
      1. Description
      2. Attributes
    36. CGGRIDUPDATE
      1. Description
      2. Attributes
    37. CFHEADER
      1. Description
      2. Attributes
    38. CFHTMLHEAD
      1. Description
      2. Attributes
    39. CFHTTP
      1. Description
      2. Attributes
    40. CFHTTPPARAM
      1. Description
      2. Attributes
    41. CFIF
      1. Description
    42. CFIMPORT
      1. Description
      2. Attributes
    43. CFINCLUDE
      1. Description
      2. Attributes
    44. CFINDEX
      1. Description
      2. Attributes
    45. cfinput
      1. Description
      2. Attributes
    46. cfinsert
      1. Description
      2. Attributes
    47. cfinvoke
      1. Description
      2. Attributes
    48. cfinvokeargument
      1. Description
      2. Attributes
    49. cfldap
      1. Description
      2. Attributes
    50. cflocation
      1. Description
      2. Attributes
    51. cflock
      1. Description
      2. Attributes
    52. cflog
      1. Description
      2. Attributes
    53. CFLOGIN (New in MX)
      1. Description
    54. CFLOGINUSER (New in MX)
      1. Description
      2. Attributes
    55. cflogout (New in MX)
      1. Description
    56. cfloop
      1. Index Loop
      2. Conditional Loop
      3. Query Loop
      4. List/File Loop
      5. COM Collection/Structure Loop
      6. Description
      7. Attributes
    57. cfmail
      1. Description
      2. Attributes
    58. CFMAILPARAM
      1. Description
      2. Attributes
    59. cfmodule
      1. Description
      2. Attributes
    60. CFOBJECT
      1. Description
      2. Attributes
        1. cfobject type = "com"
        2. cfobject type = “component”
        3. cfobject type = “corba”
        4. cfobject type = “java”
        5. cfobject type = “webservice”
    61. CFOBJECTCACHE
      1. Description
      2. Attributes
    62. cfoutput
      1. Description
      2. Attributes
    63. cfparam
      1. Description
      2. Attributes
    64. cfpop
      1. Description
      2. Attributes
    65. cfprocessingdirective
      1. Description
      2. Attributes
    66. cfprocparam
      1. Description
      2. Attributes
    67. cfprocresult
      1. Description
      2. Attributes
    68. cfproperty
      1. Description
      2. Attributes
    69. cfquery
      1. Description
      2. Attributes
    70. cfqueryparam
      1. Description
      2. Attributes
    71. cfregistry
      1. action = “getAll”
      2. action = “get”
      3. action = “set”
      4. action = “delete”
      5. Description
      6. Attributes
    72. cfreport
      1. Description
      2. Attributes
    73. cfrethrow
      1. Description
    74. cfreturn
      1. Description
      2. Attributes
    75. CFSAVECONTENT
      1. Description
      2. Attributes
    76. cfschedule
      1. Description
      2. Attributes
    77. cfscript
      1. Description
    78. cfsearch
      1. Description
      2. Attributes
    79. CFSELECT
      1. Description
      2. Attributes
    80. CFSERVLET
      1. Description
    81. CFSERVLETPARAM
      1. Description
    82. CFSET
      1. Description
      2. Attributes
    83. CFSETTING
      1. Description
      2. Attributes
    84. CFSILENT
      1. Description:
    85. CFSLIDER
      1. Description
      2. Attributes
    86. CFSTOREDPROC
      1. Description
      2. Attributes
    87. cfswitch
      1. Description
      2. Attributes
    88. cftable
      1. Description
      2. Attributes
    89. cftextinput
      1. Description
      2. Attributes
    90. cfthrow
      1. Description
      2. Attributes
    91. cftrace
      1. Description
      2. Attributes
    92. cftransaction
      1. Description
      2. Attributes
    93. cftree
      1. Description
      2. Attributes
    94. cftreeitem
      1. Description
      2. Attributes
    95. cftry
      1. Description
      2. Attributes
    96. cfupdate
      1. Description
      2. Attributes
    97. cfwddx
      1. Description
      2. Attributes
    98. cfxml
      1. Description
      2. Attributes
  37. B. Function Reference
    1. Abs
      1. Description
      2. Example
    2. ACos
      1. Description
      2. Example
    3. ArrayAppend
      1. Description
      2. Example
    4. ArrayAvg
      1. Description
      2. Example
    5. ArrayClear
      1. Description
      2. Example
    6. ArrayDeleteAt
      1. Description
      2. Example
    7. ArrayInsertAt
      1. Description
      2. Example
    8. ArrayIsEmpty
      1. Description
      2. Example
    9. ArrayLen
      1. Description
      2. Example
    10. ArrayMax
      1. Description
      2. Example
    11. ArrayMin
      1. Description
      2. Example
    12. ArrayNew
      1. Description
      2. Example
    13. ArrayPrepend
      1. Description
      2. Example
    14. ArrayResize
      1. Description
      2. Example
    15. ArraySet
      1. Description
      2. Example
    16. ArraySort
      1. Description
      2. Example
    17. ArraySum
      1. Description
      2. Example
    18. ArraySwap
      1. Description
      2. Example
    19. ArrayToList
      1. Description
      2. Example
    20. Asc
      1. Description
      2. Example
    21. ASin
      1. Description
      2. Example
    22. Atn
      1. Description
      2. Example
    23. BitAnd
      1. Description
      2. Example
    24. BitMaskClear
      1. Description
      2. Example
    25. BitMaskRead
      1. Description
      2. Example
    26. BitMaskSet
      1. Description
      2. Example
    27. BitNot
      1. Description
      2. Example
    28. BitOr
      1. Description
      2. Example
    29. BitSHLN
      1. Description
      2. Example
    30. BitSHRN
      1. Description
      2. Example
    31. BitXor
      1. Description
      2. Example
    32. Ceiling
      1. Description
      2. Example
    33. Chr
      1. Description
      2. Example
    34. Cjustify
      1. Description
      2. Example
    35. Compare
      1. Description
      2. Example
    36. CompareNoCase
      1. Description
      2. Example
    37. Cos
      1. Description
      2. Example
    38. CreateDate
      1. Description
      2. Example
    39. CreateDateTime
      1. Description
      2. Example
    40. CreateObject
      1. Description
      2. COM Objects
      3. CORBA Objects
      4. Java Object Functions
    41. CreateODBCDate
      1. Description
      2. Example
    42. CreateODBCDateTime
      1. Description
      2. Example
    43. CreateODBCTime
      1. Description
      2. Example
    44. CreateTime
      1. Description
      2. Example
    45. CreateTimeSpan
      1. Description
      2. Example
    46. CreateUUID
      1. Description
      2. Example
    47. DateAdd
      1. Description
      2. Example
    48. DateCompare
      1. Description
      2. Example
    49. DateConvert
      1. Description
      2. Example
    50. DateDiff
      1. Description
      2. Example
    51. DateFormat
      1. Description
      2. Example
    52. DatePart
      1. Description
      2. Example
    53. Day
      1. Description
      2. Example
    54. DayOfWeek
      1. Description
      2. Example
    55. DayOfWeekAsString
      1. Description
      2. Example
    56. DayOfYear
      1. Description
      2. Example
    57. DaysInMonth
      1. Description
      2. Example
    58. DaysInYear
      1. Description
      2. Example
    59. DE
      1. Description
      2. Example
    60. DecimalFormat
      1. Description
      2. Example
    61. DecrementValue
      1. Description
      2. Example
    62. Decrypt
      1. Description
      2. Example
    63. DeleteClientVariable
      1. Description
      2. Example
    64. DirectoryExists
      1. Description
      2. Example
    65. DollarFormat
      1. Description
      2. Example
    66. Duplicate
      1. Description
      2. Example
    67. Encrypt
      1. Description
      2. Example
    68. Evaluate
      1. Description
      2. Example
    69. Exp
      1. Description
      2. Example
    70. ExpandPath
      1. Description
      2. Example
    71. FileExists
      1. Description
      2. Example
    72. Find
      1. Description
      2. Example
    73. FindNoCase
      1. Description
      2. Example
    74. FindOneOf
      1. Description
      2. Example
    75. FirstDayOfMonth
      1. Description
      2. Example
    76. Fix
      1. Description
      2. Example
    77. FormatBaseN
      1. Description
      2. Example
    78. GetAuthUser
      1. Description
      2. Example
    79. GetBaseTagData
      1. Description
      2. Example
    80. GetBaseTagList
      1. Description
      2. Example
    81. GetBaseTemplatePath
      1. Description
      2. Example
    82. GetClientVariablesList
      1. Description
      2. Example
    83. GetCurrentTemplatePath
      1. Description
      2. Example
    84. GetDescriptor_html
      1. Description
    85. GetDirectoryFromPath
      1. Description
      2. Example
    86. GetException
      1. Description
      2. Example
    87. GetFileFromPath
      1. Description
      2. Example
    88. GetFunctionList
      1. Description
      2. Example
    89. GetHttpRequestData
      1. Description
      2. Example
    90. GetHttpTimeString
      1. Description
      2. Example
    91. GetK2ServerCollections
      1. Description
      2. Example
    92. GetK2ServerDocCount
      1. Description
      2. Example
    93. GetK2ServerDocCountLimit
      1. Description
      2. Example
    94. GetLocale
      1. Description
      2. Example
    95. GetMetaData
      1. Description
      2. Example
    96. GetMetricData
      1. Description
      2. Mode
    97. GetPageContext
      1. Description
      2. Example
    98. GetProfileSections
      1. Description
      2. Example
    99. GetProfileString
      1. Description
      2. Example
    100. GetServiceSettings
      1. Description
      2. Example
    101. GetTempDirectory
      1. Description
      2. Example
    102. GetTempFile
      1. Description
      2. Example
    103. GetTickCount
      1. Description
      2. Example
    104. GetTimeZoneInfo
      1. Description
      2. Example
    105. GetToken
      1. Description
      2. Example
    106. Hash
      1. Description
      2. Example
    107. Hour
      1. Description
      2. Example
    108. HTMLCodeFormat
      1. Description
      2. Example
    109. HTMLEditFormat
      1. Description
      2. Example
    110. IIf
      1. Description
      2. Example
    111. IncrementValue
      1. Description
      2. Example
    112. InputBaseN
      1. Description
      2. Example
    113. Insert
      1. Description
      2. Example
    114. Int
      1. Description
      2. Example
    115. IsArray
      1. Description
      2. Example
    116. IsBinary
      1. Description
      2. Example
    117. IsBoolean
      1. Description
      2. Example
    118. IsCustomFunction
      1. Description
      2. Example
    119. IsDate
      1. Description
      2. Example
    120. IsDebugMode
      1. Description
      2. Example
    121. IsDefined
      1. Description
      2. Example
    122. IsK2ServerABroker
      1. Description
      2. Example
    123. IsK2ServerDocCountExceeded
      1. Description
      2. Example
    124. IsK2ServerOnline
      1. Description
      2. Example
    125. IsLeapYear
      1. Description
      2. Example
    126. IsNumeric
      1. Description
      2. Example
    127. IsNumericDate
      1. Description
      2. Example
    128. IsObject
      1. Description
      2. Example
    129. IsQuery
      1. Description
      2. Example
    130. IsSimpleValue
      1. Description
      2. Example
    131. IsStruct
      1. Description
      2. Example
    132. IsUserInRole
      1. Description
      2. Example
    133. IsWDDX
      1. Description
      2. Example
    134. IsXmlDoc
    135. IsXmlElement
      1. Description
    136. IsXmlRoot
      1. Description
    137. JavaCast
      1. Description
      2. Example
    138. JSStringFormat
      1. Description
      2. Example
    139. LCase
      1. Description
      2. Example
    140. Left
      1. Description
      2. Example
    141. Len
      1. Description
      2. Example
    142. ListAppend
      1. Description
      2. Example
    143. ListChangeDelims
      1. Description
      2. Example
    144. ListContains
      1. Description
      2. Example
    145. ListContainsNoCase
      1. Description
      2. Example
    146. ListDeleteAt
      1. Description
      2. Example
    147. ListFind
      1. Description
      2. Example
    148. ListFindNoCase
      1. Description
      2. Example
    149. ListFirst
      1. Description
      2. Example
    150. ListGetAt
      1. Description
      2. Example
    151. ListInsertAt
      1. Description
      2. Example
    152. ListLast
      1. Description
      2. Example
    153. ListLen
      1. Description
      2. Example
    154. ListPrepend
      1. Description
      2. Example
    155. ListQualify
      1. Description
      2. Example
    156. ListRest
      1. Description
      2. Example
    157. ListSetAt
      1. Description
      2. Example
    158. ListSort
      1. Description
      2. Example
    159. ListToArray
      1. Description
      2. Example
    160. ListValueCount
      1. Description
      2. Example
    161. ListValueCountNoCase
      1. Description
      2. Example
    162. LJustify
      1. Description
      2. Example
    163. Log
      1. Description
      2. Example
    164. Log10
      1. Description
      2. Example
    165. LSCurrencyFormat
      1. Description
      2. Example
    166. LSDateFormat
      1. Description
      2. Example
    167. LSEuroCurrencyFormat
      1. Description
      2. Example
    168. LSIsCurrency
      1. Description
      2. Example
    169. LSIsDate
      1. Description
      2. Example
    170. LSIsNumeric
      1. Description
      2. Example
    171. LSNumberFormat
      1. Description
      2. Example
    172. LSParseCurrency
      1. Description
      2. Example
    173. LSParseDateTime
      1. Description
      2. Example
    174. LSParseEuroCurrency
      1. Description
      2. Example
    175. LSParseNumber
      1. Description
      2. Example
    176. LSTimeFormat
      1. Description
      2. Example
    177. LTrim
      1. Description
      2. Example
    178. Max
      1. Description
      2. Example
    179. Mid
      1. Description
      2. Example
    180. Min
      1. Description
      2. Example
    181. Minute
      1. Description
      2. Example
    182. Month
      1. Description
      2. Example
    183. MonthAsString
      1. Description
      2. Example
    184. Now
      1. Description
      2. Example
    185. NumberFormat
      1. Description
      2. Example
    186. ParagraphFormat
      1. Description
      2. Example
    187. ParseDateTime
      1. Description
      2. Example
    188. Pi
      1. Description
      2. Example
    189. PreserveSingleQuotes
      1. Description
      2. Example
    190. Quarter
      1. Description
      2. Example
    191. QueryAddColumn
      1. Description
      2. Example
    192. QueryAddRow
      1. Description
      2. Example
    193. QueryNew
      1. Description
      2. Example
    194. QuerySetCell
      1. Description
      2. Example
    195. QuotedValueList
      1. Description
      2. Example
    196. Rand
      1. Description
      2. Example
    197. Randomize
      1. Description
      2. Example
    198. RandRange
      1. Description
      2. Example
    199. REFind
      1. Description
      2. Example
    200. REFindNoCase
      1. Description
      2. Example
    201. RemoveChars
      1. Description
      2. Example
    202. RepeatString
      1. Description
      2. Example
    203. Replace
      1. Description
      2. Example
    204. ReplaceList
      1. Description
      2. Example
    205. ReplaceNoCase
      1. Description
      2. Example
    206. REReplace
      1. Description
      2. Example
    207. REReplaceNoCase
      1. Description
      2. Example
    208. Reverse
      1. Description
      2. Example
    209. Right
      1. Description
      2. Example
    210. RJustify
      1. Description
      2. Example
    211. Round
      1. Description
      2. Example
    212. RTrim
      1. Description
      2. Example
    213. Second
      1. Description
      2. Example
    214. SetEncoding
      1. Description
      2. Example
    215. SetLocale
      1. Description
      2. Example
    216. SetProfileString
      1. Description
      2. Example
    217. SetVariable
      1. Description
    218. Sgn
      1. Description
      2. Example
    219. Sin
      1. Description
      2. Example
    220. SpanExcluding
      1. Description
      2. Example
    221. SpanIncluding
      1. Description
      2. Example
    222. Sqr
      1. Description
      2. Example
    223. StripCR
      1. Description
      2. Example
    224. StructAppend
      1. Description
      2. Example
    225. StructClear
      1. Description
      2. Example
    226. StructCopy
      1. Description
      2. Example
    227. StructCount
      1. Description
      2. Example
    228. StructDelete
      1. Description
      2. Example
    229. StructFind
      1. Description
      2. Example
    230. StructFindKey
      1. Description
      2. Example
    231. StructFindValue
      1. Description
      2. Example
    232. StructGet
      1. Description
      2. Example
    233. StructInsert
      1. Description
      2. Example
    234. StructIsEmpty
      1. Description
      2. Example
    235. StructKeyArray
      1. Description
      2. Example
    236. StructKeyExists
      1. Description
      2. Example
    237. StructKeyList
      1. Description
      2. Example
    238. StructNew
      1. Description
      2. Example
    239. StructSort
      1. Description
      2. Example
    240. StructUpdate
      1. Description
      2. Example
    241. Tan
      1. Description
      2. Example
    242. TimeFormat
      1. Description
      2. Example
    243. ToBase64
      1. Description
    244. ToBinary
      1. Description
      2. Example
    245. ToString
      1. Description
      2. Example
    246. Trim
      1. Description
      2. Example
    247. UCase
      1. Description
      2. Example
    248. URLDecode
      1. Description
      2. Example
    249. URLEncodedFormat
      1. Description
      2. Example
    250. URLSessionFormat
      1. Description
      2. Example
    251. Val
      1. Description
      2. Example
    252. ValueList
      1. Description
      2. Example
    253. Week
      1. Description
      2. Example
    254. WriteOutput
      1. Description
      2. Example
    255. XmlChildPos
      1. Description
      2. Example
    256. XmlElemNew
      1. Description
      2. Example
    257. XmlFormat
      1. Description
      2. Example
    258. XmlNew
      1. Description
      2. Example
    259. XmlParse
      1. Description
      2. Example
    260. XmlSearch
      1. Description
      2. Example
    261. XmlTransform
      1. Description
      2. Example
    262. Year
      1. Description
      2. Example
    263. YesNoFormat
      1. Description
      2. Example