book

Programming ColdFusion MX, 2nd Edition

Name: Programming ColdFusion MX, 2nd Edition
Author: Rob Brooks-Bilson
ISBN: 9781491909485

by Rob Brooks-Bilson

August 2003

Intermediate to advanced

1140 pages

68h 45m

English

O'Reilly Media, Inc.

Read now

Unlock full access

Programming ColdFusion MX, 2nd Edition
A Note Regarding Supplemental Files
Preface
What’s New in ColdFusion MX
Readers of the First Edition
Audience
Organization
Conventions Used in This Book
Comments and Questions
Acknowledgments

1. Introducing ColdFusion
1.1. What Is ColdFusion?
1.2. ColdFusion Architecture
1.3. Getting Started with ColdFusion
2. ColdFusion Basics
2.1. Getting Started
2.1.1. Saving CFML Templates2.1.2. Tag Syntax2.1.3. Comments
2.2. Datatypes
2.3. Variables
2.3.1. Variable Names2.3.2. Assigning Values to Variables2.3.3. Variable Scope2.3.4. Specifying Default Values Using cfparam
2.4. Expressions
2.4.1. Operators2.4.2. Functions
2.5. Writing Output
2.5.1. Using Pound Signs Within Expressions2.5.1.1. Including an expression within a string2.5.1.2. Including expressions within tag attributes2.5.2. Nested Pound Signs2.5.3. Escaping Pound Signs
2.6. Conditional Processing
2.6.1. cfif, cfelseif, and cfelse2.6.2. cfswitch, cfcase, and cfdefaultcase2.6.3. IIF
2.7. Looping
2.7.1. Index Loops2.7.2. Conditional Loops
2.8. Including Other Templates
3. Passing Data Between Templates
3.1. Passing Parameters Via URL
3.1.1. Dealing with Special Characters3.1.2. Obtaining a List of All Available URL Parameters
3.2. Passing Data Using Forms
3.2.1. Handling Specific Types of Form Fields3.2.1.1. Multiple selection lists3.2.1.2. Checkboxes and radio buttons3.2.2. Using Hidden Form Fields3.2.3. Automatically Validating Form-Field Data3.2.4. Manually Validating Form-Field Data3.2.5. Obtaining a List of All Available Form Variables
3.3. Dealing with Nonexistent Parameters
4. Database Basics
4.1. Configuring Data Sources
4.1.1. Configuring a Data Source in the ColdFusion Administrator4.1.2. Additional Resources
4.2. Introducing cfquery
4.3. A Quick SQL Primer
4.4. Retrieving and Displaying Data
4.4.1. Creating the Example Database4.4.2. Retrieving Data from a Data Source4.4.3. Outputting Query Results4.4.4. Obtaining Additional Query Information
4.5. Sorting Query Results
4.6. Grouping Output
4.7. Looping Over a Query Result Set
4.8. Formatting Techniques
4.8.1. Formatting Plain-Text Strings4.8.1.1. Using ParagraphFormat4.8.1.2. Wrapping text4.8.1.3. Changing case4.8.1.4. Making strings JavaScript-safe4.8.1.5. Making strings safe for XML4.8.2. Formatting HTML4.8.2.1. HTMLCodeFormat4.8.2.2. HTMLEditFormat4.8.3. Formatting Numbers4.8.3.1. Formatting decimal numbers4.8.3.2. General number formatting4.8.3.3. Locale-specific number formatting4.8.4. Formatting Currency Values4.8.4.1. Formatting dollars4.8.4.2. Locale-specific currency formatting4.8.4.3. Locale-specific currency formatting with the euro4.8.5. Formatting Boolean Values4.8.6. Formatting Dates and Times4.8.6.1. General date formatting4.8.6.2. Locale-specific date formatting4.8.6.3. General time formatting4.8.6.4. Locale-specific time formatting
5. Maintaining Database Records
5.1. Inserting Records
5.1.1. Inputting Data Via Forms5.1.2. Inserting Form-Field Data5.1.2.1. Inserting a record using cfquery5.1.2.2. Inserting a record using cfinsert
5.2. Updating Existing Records
5.2.1. Choosing a Record to Update5.2.2. Dynamically Populating Update Forms5.2.3. Performing the Database Update5.2.3.1. Updating a record using cfquery5.2.3.2. Updating a record using cfupdate5.2.4. Dynamically Populating Additional Form-Field Types5.2.4.1. Populating text areas5.2.4.2. Populating select lists5.2.4.3. Generating and selecting multiple checkboxes5.2.4.4. Generating and selecting radio buttons
5.3. Deleting Records
5.3.1. Deleting a Single Record5.3.2. Deleting Multiple Records5.3.3. Asking for Confirmation Before Deleting5.3.4. A Note About Referential Integrity and Cascading Deletes
6. Complex Datatypes
6.1. Lists
6.1.1. Looping over a List6.1.2. Manipulating Lists
6.2. Arrays
6.2.1. Initializing an Array6.2.2. Adding Data to an Array6.2.3. Manipulating Array Elements
6.3. Structures
6.3.1. Creating a Structure6.3.2. Populating a Structure with Data6.3.3. Using a Collection Loop to Loop over the Contents of a Structure6.3.4. Creating an Array of Structures6.3.5. Manipulating Structures
6.4. Query Objects
6.4.1. Manipulating Query Objects
7. Maintaining State
7.1. Setting Up the Web Application Framework
7.1.1. The Application.cfm File7.1.2. The OnRequestEnd.cfm File
7.2. Using Shared Scope Variables
7.2.1. Locking7.2.1.1. Locking shared scope variables at the scope level7.2.1.2. Locking shared scope variable access using named locks7.2.1.3. Locking access to nonthread-safe objects and file operations7.2.1.4. Additional locking considerations7.2.2. Application Variables7.2.3. Client Variables7.2.3.1. Client-variable storage options7.2.3.2. Creating an external data source for client variable storage7.2.3.3. Using client variables without cookies7.2.3.4. Storing complex datatypes in client variables7.2.3.5. Client variables and clustering7.2.3.6. Deleting client variables7.2.4. Cookies7.2.4.1. Setting cookies7.2.4.2. Retrieving cookies7.2.4.3. Deleting cookies7.2.5. Session Variables7.2.5.1. Using session variables without cookies7.2.5.2. Deleting session variables7.2.5.3. Session variables and clustering7.2.6. Server Variables
7.3. Browser Redirection
7.4. Portal Example
7.4.1. Web Application Framework7.4.2. Main Template7.4.3. Customization
8. Security
8.1. Security Basics
8.2. Implementing Security from Scratch
8.2.1. Creating a Simple Security Table in the Database8.2.2. Setting Up the Application.cfm Template8.2.3. Creating Login and Registration Screens8.2.4. Authenticating Users8.2.5. Securing Non-CFML Files8.2.6. Levels of Access
8.3. Taking Advantage of ColdFusion MX’s New Security Framework
8.3.1. Authenticating Users8.3.1.1. Application-based authentication8.3.1.2. HTTP authentication8.3.2. Role-Based Permissions
9. Error and Exception Handling
9.1. Basic Exception Handling
9.2. Custom Exception Handling
9.3. Rethrowing Exceptions
9.4. Error Handling Within the Web-Application Framework
9.4.1. Form Validation Errors9.4.2. Request Errors9.4.3. Specific Exceptions9.4.4. Monitors (ColdFusion 5 Only)9.4.5. Exception Logging
9.5. Server-Wide Error Handling
9.5.1. Missing Template Handler9.5.2. Site-wide Error Handler
10. Dynamic Form Controls
10.1. Combining HTML and CFML Form Controls
10.2. Basic Input Controls
10.2.1. Data Validation10.2.2. Data Validation with JavaScript Regular Expressions
10.3. Textual Input
10.4. A Selection Control
10.5. Sliders
10.6. Grids
10.6.1. Customizing Column Data10.6.2. Specifying Row Data10.6.3. Creating Updateable Grids10.6.3.1. Updating a grid using cfgridupdate10.6.3.2. Updating a grid using cfquery10.6.3.3. Advanced editable grid controls
10.7. Trees
10.7.1. Populating a Tree Control10.7.1.1. Creating a static tree10.7.1.2. Dynamically populating a tree control with query data10.7.2. Submitting a Tree Selection10.7.3. Creating a Tree Via Recursion
10.8. Preserving Input
10.9. Custom Controls
11. Advanced Database Techniques
11.1. Display Techniques
11.1.1. Flushing Page Output11.1.2. Displaying Limited Record Sets11.1.3. Alternating Row Color in HTML Tables11.1.4. Multicolumn Output11.1.4.1. Sorting multicolumn output from left to right11.1.4.2. Sorting multicolumn output from top to bottom11.1.5. Next/Previous Record Browsing11.1.6. Controlling Whitespace11.1.6.1. Optimizing output11.1.6.2. Suppressing output11.1.6.3. Suppressing whitespace
11.2. Drilldown Queries
11.3. Query Caching
11.4. Advanced SQL
11.4.1. Dynamic SQL11.4.2. Creating and Modifying Tables11.4.2.1. Creating new tables11.4.2.2. Populating new tables with existing data11.4.2.3. Altering table design11.4.2.4. Deleting tables11.4.3. Retrieving Unique Values11.4.4. Using Column Aliases11.4.5. Scalar Functions11.4.6. Aggregate Functions11.4.7. Subqueries11.4.8. Unions11.4.9. Joins11.4.9.1. Inner joins11.4.9.2. Outer joins11.4.10. Data Binding and Preventing Malicious Query Code
11.5. Query of Queries
11.6. Calling Stored Procedures
11.6.1. Using cfstoredproc11.6.1.1. Passing parameters using cfprocparam11.6.1.2. Specifying result sets using cfprocresult11.6.2. Using cfquery
11.7. Transaction Processing
12. Manipulating Files and Directories
12.1. Working with Directories
12.1.1. Listing Directory Contents12.1.2. Creating a Directory12.1.3. Renaming a Directory12.1.4. Deleting a Directory
12.2. Dealing with Files
12.2.1. Uploading Files12.2.2. Renaming Files12.2.3. Moving Files12.2.4. Copying Files12.2.5. Deleting Files12.2.6. Reading Text Files12.2.7. Reading Binary Files12.2.8. Writing Text Files12.2.9. Writing Binary Files12.2.10. Appending Text Files
12.3. Performing FTP Operations
12.3.1. Connecting to a Remote Server12.3.2. Automatically Opening a Connection12.3.3. Closing the Connection12.3.4. Performing File and Directory Operations12.3.4.1. Obtaining a directory listing12.3.4.2. Uploading files12.3.4.3. Downloading files12.3.4.4. Deleting files
12.4. Executing Command-Line Programs
13. Working with Email
13.1. Sending Email
13.1.1. Sending HTML Mail13.1.2. Sending Multi-Part Messages13.1.3. Emailing Form Contents13.1.4. Adding Query Results to Email13.1.5. Including Grouped Query Results13.1.6. Sending Customized Email to Multiple Recipients13.1.7. Sending File Attachments13.1.8. Specifying Additional Header Information
13.2. Dealing with Undeliverable Email
13.3. Retrieving Messages
13.3.1. Retrieving Message Headers13.3.2. Retrieving Message Contents13.3.3. Dealing with Attachments13.3.4. Deleting Messages
13.4. Building a Web-Based Email Client
13.4.1. Moving Beyond a Basic Email Client
14. Interacting with Other Web Servers Using HTTP
14.1. Retrieving Information
14.1.1. Saving Information to a Variable14.1.2. Saving Information to a File14.1.3. Retrieving HTTP Header Information14.1.4. Creating Query Objects from Text Files14.1.5. Passing Parameters
14.2. Parsing Data
14.3. Generating Static HTML Pages
14.4. Posting Information
14.4.1. Sending Form-Field Data14.4.2. Sending URL Variables14.4.3. Sending CGI Variables14.4.4. Sending Cookies14.4.5. Sending Files14.4.6. Sending XML14.4.7. Sending Header and Body Content
14.5. cfhttp Considerations
14.5.1. JRE-Related Issues in ColdFusion MX14.5.2. Authentication
15. Interfacing with LDAP-Enabled Directories
15.1. LDAP Basics
15.1.1. LDAP Attributes15.1.2. Public LDAP Servers
15.2. Querying an LDAP Directory
15.2.1. Performing an LDAP Query15.2.2. Obtaining the LDAP Server Schema
15.3. Modifying LDAP Entries
15.3.1. Adding/Updating Entries15.3.2. Deleting Entries
15.4. Modifying the Distinguished Name
16. Working with the Verity Search Interface
16.1. Creating Collections
16.1.1. Creating Collections with the ColdFusion Administrator16.1.2. Creating Collections with the cfcollection Tag
16.2. Populating Collections
16.2.1. Indexing Files16.2.1.1. Indexing files with the ColdFusion Administrator16.2.1.2. Indexing files programmatically with cfindex16.2.2. Indexing Query Results16.2.2.1. Indexing database query results16.2.2.2. Indexing cfldap query results16.2.2.3. Indexing cfpop query results
16.3. Searching Collections
16.3.1. Building a Search Interface16.3.1.1. Searching file collections16.3.1.2. Searching database collections
16.4. The Verity Search Language
16.4.1. Simple Versus Explicit Searches16.4.1.1. Operators16.4.1.1.1. Order of evaluation16.4.1.1.2. Prefix and infix notation16.4.1.1.3. Quotation marks16.4.1.1.4. Special characters16.4.1.1.5. Concept operators16.4.1.1.6. Evidence operators16.4.1.1.7. Proximity operators16.4.1.1.8. Relational operators16.4.1.1.9. Score operators16.4.1.1.10. Modifiers16.4.2. Building an Advanced Search Interface
16.5. Updating Collections
16.5.1. Adding New Records to a Collection16.5.2. Deleting Records from a Collection
16.6. Maintaining Collections
16.6.1. Optimizing Collections16.6.2. Repairing Collections16.6.3. Purging Collections16.6.4. Deleting Collections
16.7. Advanced Techniques
16.7.1. Creating a Top-Ten List16.7.2. Custom Attributes16.7.2.1. Populating the custom attributes16.7.2.2. Searching the custom attributes16.7.2.3. Extending the usefulness of custom attributes16.7.3. Modifying the Verity Summary Attribute16.7.4. Tweaking Verity’s XML Filter16.7.5. Searching Database and Document Collections Simultaneously
17. Graphing and Charting
17.1. Creating a Simple Graph
17.2. Working with Dates
17.3. Charting Dynamic Data
17.4. Charting Multiple Data Series
17.4.1. Multiple Data Point Colors in a Single Series
17.5. Drilling Down on Graph Data
17.5.1. Passing Chart Parameters to JavaScript
17.6. Saving Charts to a Variable
17.7. Working with the Chart Cache
18. Regular Expressions in ColdFusion
18.1. Regular-Expression Syntax
18.1.1. Commenting Regular Expressions18.1.2. Operators18.1.3. POSIX Classes18.1.4. Character Classes18.1.5. Unsupported Perl Regular-Expression Conventions
18.2. Finding Strings
18.2.1. Maximal Versus Minimal Matching
18.3. Replacing Strings
18.4. Backreferences
18.4.1. Replacement String Case Conversion18.4.2. Excluding Subexpressions from Backreferences
18.5. Useful Regular Expressions
18.6. Regular Expression Tester
19. Scripting
19.1. Scripting Syntax
19.1.1. Working with Variables19.1.2. Commenting Your Code
19.2. Writing Output
19.3. Flow Control and Looping
19.3.1. if/else19.3.2. switch/case19.3.3. for Loops19.3.4. for/in Loops19.3.5. while Loops19.3.6. do/while Loops19.3.7. Using break Within a Loop19.3.8. Using continue
19.4. Error and Exception Handling
20. User-Defined Functions
20.1. UDF Basics
20.1.1. Function Arguments in Tag-Based UDFs20.1.2. Local Function Variables (The Function Scope)20.1.3. Returning Data from a Function
20.2. Calling User-Defined Functions
20.2.1. A Note About Datatypes
20.3. Advanced Topics
20.3.1. Recursion20.3.2. Error and Exception Handling20.3.3. Assigning UDFs to Other Variable Scopes20.3.4. UDFs and Custom Tags
20.4. Function Libraries
20.5. Script-Based UDFs
21. Creating Custom Tags
21.1. Getting Started
21.1.1. Why Custom Tags?21.1.2. Custom Tags Versus Other Options
21.2. Calling Custom Tags
21.3. Passing Data
21.4. Returning Data
21.4.1. Returning Multiple Values from a Custom Tag
21.5. Attribute Validation and Error Handling
21.5.1. Handling Required Attributes21.5.2. Handling Optional Attributes21.5.3. Validating Datatypes21.5.4. Error and Exception Handling
21.6. Advanced Techniques
21.6.1. Calling Custom Tags Via cfmodule21.6.2. Importing Custom Tags as a Tag Library21.6.2.1. A noteworthy cfimport bug21.6.3. Adaptive Tags21.6.4. Passing Attributes via Structures21.6.5. Creating Tag Pairs21.6.6. Nesting Custom Tags21.6.6.1. Extending cf_sitewrapper with child tags21.6.7. Aborting Tag Processing
21.7. Protecting Your Tags
21.8. CFX Tags
21.8.1. Registering CFX Tags21.8.1.1. Registering C++ CFX tags21.8.1.2. Registering Java CFX tags21.8.2. Calling CFX Tags21.8.3. Additional Resources
22. ColdFusion Components
22.1. Basic Concepts
22.2. Creating Components
22.2.1. Adding Metadata to Components22.2.2. Component Methods22.2.2.1. Method arguments22.2.2.2. Returning data from methods22.2.2.3. Method includes22.2.3. Variable Scope in CFCs22.2.4. Saving Components
22.3. Using Components
22.3.1. Using cfinvoke22.3.2. Using cfobject and createObject( )22.3.3. Calling a CFC Method Via URL22.3.4. Calling a CFC Method Via Form Post
22.4. Advanced CFC Topics
22.4.1. Introspection22.4.2. Inheritance22.4.2.1. Global component inheritance with component.cfc22.4.3. Component Security22.4.3.1. Securing access using HTTP Basic Authentication22.4.3.2. Securing access using ColdFusion’s built-in security framework22.4.4. Assigning Component Instances to Shared Variable Scopes
23. XML and WDDX
23.1. Working with XML
23.1.1. A 30-Second XML Primer23.1.2. XML Document Object23.1.3. XML DOM Nodes23.1.4. Generating Your Own XML23.1.5. Matching XML Data with XPath23.1.6. Transforming XML with XSLT
23.2. Using WDDX
23.2.1. What Can You Do with WDDX?23.2.2. How Does It Work?23.2.3. Show Me the WDDX!23.2.4. Serializing and Deserializing Data23.2.4.1. Serializing and deserializing simple values23.2.4.2. Datatype conversion issues23.2.4.3. Testing for well-formed WDDX23.2.4.4. Serializing and deserializing complex datatypes23.2.4.4.1. Record sets23.2.4.4.2. Arrays23.2.4.4.3. Structures23.2.4.4.4. Binary data23.2.5. Storing WDDX Packets23.2.5.1. Storing packets in a text file23.2.5.2. Storing packets in a database23.2.6. Server-to-Browser WDDX Using JavaScript23.2.6.1. Passing data to JavaScript on the browser23.2.6.2. Simplifying the process23.2.6.3. Passing data from JavaScript to ColdFusion
24. Web Services
24.1. Web Services Overview
24.2. Consuming Web Services
24.2.1. Registering Web Services in the ColdFusion Administrator24.2.2. Consuming a ColdFusion MX Web Service24.2.3. Dealing with Complex Datatypes24.2.3.1. Complex types as return values24.2.3.2. Complex types as input parameters
24.3. Producing Web Services
24.3.1. Handling Datatype Mapping in ColdFusion-Produced Web Services24.3.2. Creating Custom Datatypes
24.4. Web Services Security
24.4.1. Securing Access Using HTTP Basic Authentication24.4.2. Securing Access Using ColdFusion’s Built-in Security Framework
25. Working with the System Registry
25.1. Getting Registry Keys and Values
25.2. Setting Registry Keys and Values
25.3. Deleting Registry Keys and Values
26. Using the ColdFusion Scheduler
26.1. Scheduling Tasks with the ColdFusion Administrator
26.1.1. Logging Scheduled Tasks26.1.2. Adding a Task26.1.3. Manually Executing a Task26.1.4. Updating and Deleting Tasks26.1.4.1. Updating a task26.1.4.2. Deleting a task
26.2. Scheduling Tasks with cfschedule
26.2.1. Adding Tasks26.2.2. Updating Tasks26.2.3. Deleting a Task26.2.4. Running Tasks
26.3. Additional Considerations
27. Interacting with COM, CORBA, and Java
27.1. Working with COM
27.2. Calling CORBA Objects
27.3. Integrating ColdFusion and Java
27.3.1. Calling Java Objects27.3.1.1. Overloading methods27.3.1.2. Handling exceptions27.3.1.3. The Java API27.3.1.4. Taking advantage of the PageContext object27.3.2. Communicating with Servlets and JSP Pages27.3.2.1. Sharing data between ColdFusion and servlets/JSP pages27.3.3. Using JSP Tags and Tag Libraries
28. Flash Remoting
28.1. Getting Started with Flash Remoting for ColdFusion MX
28.1.1. Setting Up Flash Remoting28.1.2. Working with the Flash MX Editor28.1.3. Writing ActionScript for Flash Remoting
28.2. Interacting with ColdFusion Pages
28.3. Interacting with ColdFusion Components
28.3.1. Introspecting CFCs in Flash MX28.3.2. Securing Flash Remoting Applications
28.4. Interacting with Server-Side ActionScript
28.5. Flash Remoting with Java Objects Hosted on the ColdFusion MX Server
A. Tag Reference
A.1. Tags by Type
A.1.1. Custom Tag TagsA.1.2. Database TagsA.1.3. Error, Exception-Handling, and Debugging TagsA.1.4. Extensibility TagsA.1.5. Filesystem TagsA.1.6. Flow Control TagsA.1.7. Form TagsA.1.8. Miscellaneous TagsA.1.9. Output TagsA.1.10. Protocol TagsA.1.11. Security TagsA.1.12. System TagsA.1.13. UDFs/CFCs/Web Services TagsA.1.14. Variable Manipulation TagsA.1.15. Verity Search Engine Tags
A.2. Alphabetical List of Tags
cfabort
cfadminsecurity
cfapplet
cfapplication
cfargument
cfassociate
cfauthenticate
cfbreak
cfcache
cfcase
cfcatch
cfchart
cfchartdata
cfchartseries
cfcol
cfcollection
cfcomponent
cfcontent
cfcookie
cfdefaultcase
cfdirectory
cfdump
cfelse
cfelseif
cferror
cfexecute
cfexit
cffile
cfflush
cfform
cfftp
cffunction
cfgraph
cfgraphdata
cfgrid
cfgridcolumn
cfgridrow
cfgridupdate
cfheader
cfhtmlhead
cfhttp
cfhttpparam
cfif
cfimpersonate
cfimport
cfinclude
cfindex
cfinput
cfinsert
cfinternaldebug
cfinvoke
cfinvokeargument
cfldap
cflocation
cflock
cflog
cflogin
cfloginuser
cflogout
cfloop
cfmail
cfmailparam
cfmailpart
cfmodule
cfnewinternaladminsecurity
cfnewinternalregistry
cfobject
cfobjectcache
cfoutput
cfparam
cfpop
cfprocessingdirective
cfprocparam
cfprocresult
cfproperty
cfquery
cfqueryparam
cfregistry
cfreport
cfrethrow
cfreturn
cfsavecontent
cfschedule
cfscript
cfsearch
cfselect
cfservlet
cfservletparam
cfset
cfsetting
cfsilent
cfslider
cfstoredproc
cfswitch
cftable
cftextinput
cfthrow
cftrace
cftransaction
cftree
cftreeitem
cftry
cfupdate
cfwddx
cfxml
B. Function Reference
B.1. Functions by Category
B.1.1. Array FunctionsB.1.2. Date/Time FunctionsB.1.3. Decision/Evaluation FunctionsB.1.4. Encoding/Encryption FunctionsB.1.5. File/Directory FunctionsB.1.6. Formatting FunctionsB.1.7. Internationalization/Localization FunctionsB.1.8. List FunctionsB.1.9. Mathematical FunctionsB.1.10. Miscellaneous FunctionsB.1.11. Query FunctionsB.1.12. Security FunctionsB.1.13. String FunctionsB.1.14. Structure FunctionsB.1.15. Undocumented FunctionsB.1.16. Verity FunctionsB.1.17. XML Functions
B.2. Alphabetical List of Functions
Abs
ACos
ArrayAppend
ArrayAvg
ArrayClear
ArrayDeleteAt
ArrayInsertAt
ArrayIsEmpty
ArrayLen
ArrayMax
ArrayMin
ArrayNew
ArrayPrepend
ArrayResize
ArraySet
ArraySort
ArraySum
ArraySwap
ArrayToList
Asc
Asin
Atn
AuthenticatedContext
AuthenticatedUser
BitAnd
BitMaskClear
BitMaskRead
BitMaskSet
BitNot
BitOr
BitSHLN
BitSHRN
BitXor
Ceiling
CFusion_DBConnections_Flush
CFusion_Decrypt
CFusion_Disable_DBConnections
CFusion_Encrypt
CFusion_GetODBCDSN
CFusion_GetODBCINI
CFusion_SetODBCINI
CFusion_Settings_Refresh
CFusion_VerifyMail
CF_GetDataSourceUserName
CF_IsColdFusionDataSource
CF_SetDataSourcePassword
CF_SetDataSourceUserName
Chr
CJustify
Compare
CompareNoCase
Cos
CreateDate
CreateDateTime
CreateObject
CreateODBCDate
CreateODBCDateTime
CreateODBCTime
CreateTime
CreateTimeSpan
CreateUUID
DateAdd
DateCompare
DateConvert
DateDiff
DateFormat
DatePart
Day
DayOfWeek
DayOfWeekAsString
DayOfYear
DaysInMonth
DaysInYear
DE
DecimalFormat
DecrementValue
Decrypt
DeleteClientVariable
DirectoryExists
DollarFormat
Duplicate
Encrypt
Evaluate
Exp
ExpandPath
FileExists
Find
FindNoCase
FindOneOf
FirstDayOfMonth
Fix
FormatBaseN
GetAuthUser
GetBaseTagData
GetBaseTagList
GetBaseTemplatePath
GetClientVariablesList
GetCurrentTemplatePath
GetDirectoryFromPath
GetException
GetFileFromPath
GetFunctionList
GetHTTPRequestData
GetHTTPTimeString
GetK2ServerCollections
GetK2ServerDocCount
GetK2ServerDocCountLimit
GetLocale
GetMetaData
GetMetricData
GetNumericDate
GetPageContext
GetProfileSections
GetProfileString
GetTempDirectory
GetTempFile
GetTickCount
GetTimeZoneInfo
GetToken
Hash
Hour
HTMLCodeFormat
HTMLEditFormat
IIf
IncrementValue
InputBaseN
Insert
Int
IsArray
IsAuthenticated
IsAuthorized
IsBinary
IsBoolean
IsCustomFunction
IsDate
IsDebugMode
IsDefined
IsK2ServerABroker
IsK2ServerDocCountExceeded
IsK2ServerOnline
IsLeapYear
IsNotMap
IsNumeric
IsNumericDate
IsObject
IsProtected
IsQuery
IsSimpleValue
IsStruct
IsUserInRole
IsWDDX
IsXmlDoc
IsXmlElem
IsXmlRoot
JavaCast
JSStringFormat
Lcase
Left
Len
ListAppend
ListChangeDelims
ListContains
ListContainsNoCase
ListDeleteAt
ListFind
ListFindNoCase
ListFirst
ListGetAt
ListInsertAt
ListLast
ListLen
ListPrepend
ListQualify
ListRest
ListSetAt
ListSort
ListToArray
ListValueCount
ListValueCountNoCase
LJustify
Log
Log10
LSCurrencyFormat
LSDateFormat
LSEuroCurrencyFormat
LSIsCurrency
LSIsDate
LSIsNumeric
LSNumberFormat
LSParseCurrency
LSParseDateTime
LSParseEuroCurrency
LSParseNumber
LSTimeFormat
LTrim
Max
Mid
Min
Minute
Month
MonthAsString
Now
NumberFormat
ParagraphFormat
ParseDateTime
Pi
PreserveSingleQuotes
Quarter
QueryAddColumn
QueryAddRow
QueryNew
QuerySetCell
QuotedValueList
Rand
Randomize
RandRange
REFind
REFindNoCase
ReleaseCOMObject
RemoveChars
RepeatString
Replace
ReplaceList
ReplaceNoCase
REReplace
REReplaceNoCase
Reverse
Right
RJustify
Round
RTrim
Second
SetEncoding
SetLocale
SetProfileString
SetVariable
Sgn
Sin
SpanExcluding
SpanIncluding
Sqr
StripCR
StructAppend
StructClear
StructCopy
StructCount
StructDelete
StructFind
StructFindKey
StructFindValue
StructGet
StructInsert
StructIsEmpty
StructKeyArray
StructKeyExists
StructKeyList
StructNew
StructSort
StructUpdate
Tan
TimeFormat
ToBase64
ToBinary
ToString
Trim
Ucase
URLDecode
URLEncodedFormat
URLSessionFormat
Val
ValueList
Week
Wrap
WriteOutput
XmlChildPos
XmlElemNew
XmlFormat
XmlNew
XmlParse
XmlSearch
XmlTransform
Year
YesNoFormat
C. Example Database Tables
D. ColdFusion Resources
D.1. Official Macromedia Resources
D.2. Magazines
D.3. Mailing Lists
D.4. Blogs
D.5. Community Resources
D.6. User Groups
Index
About the Author
Colophon
Copyright

Content preview from Programming ColdFusion MX, 2nd Edition

Configuring Data Sources

In ColdFusion, the term data source refers to a connection between ColdFusion and an information source, such as a database, LDAP server, flat file, etc. This chapter focuses on connecting with one specific type of data source: databases. Before you can use ColdFusion to interact with a database, the database has to be set up as a data source that the ColdFusion server can recognize. Unlike previous version of ColdFusion, which used ODBC, OLEDB, and native drivers to connect to databases, ColdFusion MX handles all database connections via JDBC (Java Database Connectivity). There are currently four distinct types of JDBC drivers, appropriately named type 1, 2, 3, and 4. Each JDBC type works in a slightly different way:

JDBC to ODBC Bridge (Type 1): JDBC calls are translated to appropriate ODBC calls and sent through an ODBC driver.
Native-API Partly Java Technology-Enabled Driver (Type 2): A JDBC call is converted to a client-specific API call.
Net-Protocol Fully Java Technology-Enabled Driver (Type 3): A JDBC call is first translated to an independent net protocol, then to a database-specific call.
Native-Protocol Fully Java Technology-Enabled Driver (Type 4 ): A JDBC call is converted to the network protocol used by the specific database.

ColdFusion MX comes with JDBC drivers for connecting to several popular databases. Depending on the version of ColdFusion MX you have, drivers may include MS Access, MS SQL Server, Oracle, various flavors of DB2, Informix, ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 0596003803Errata Page

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Programming ColdFusion MX, 2nd Edition

by Rob Brooks-Bilson

Configuring Data Sources

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

More than 5,000 organizations count on O’Reilly

Julian F.

Addison B.

Amir M.

Mark W.

You might also like

Programming ColdFusion

Adobe ColdFusion 9 Web Application Construction Kit, Volume 2: Application Development

Adobe ColdFusion 8 Web Application Construction Kit, Volume 1: Getting Started

macromedia® Coldfusion® MX 7 Web Application Construction Kit

Publisher Resources