What You'll Learn

 

• Understand ColdFusion architecture and applications
• Build database-driven pages with ColdFusion markup language
• Harness the power of ColdFusion server
• Debug and foolproof your ColdFusion applications
• Track user information from page to page
• Display your data creatively
• Generate graphs
• Write queries of queries
• Reference stored procedures
• Reuse your code
• Manipulate files on the server
• Handle errors and exceptions
• Validate data with regular expressions
• Integrate the Verity search engine with your site
• Schedule recurring tasks

Course Outline

 

1. Introduction to ColdFusion

• Overview
• Static
• Dynamic client/server model on the web using ColdFusion

2. Web-to-Database Integration Using ColdFusion

• JDBC data sources
• JDBC drivers and SQL
• ODBC Data Source Names (DSNs)
• The ColdFusion web-to-database integration model
• Database and files used in class

3. Writing ColdFusion Code

• ColdFusion templates
• Using ColdFusion Studio
• Viewing and editing the files for class in ColdFusion Studio
• Executing the files for class in a web browser
• Writing HTML tags using ColdFusion Studio
• Building an HTML page with ColdFusion Studio

4. Accessing the Date and Time in ColdFusion

• Date functions in ColdFusion
• Time functions in ColdFusion
• Date formats in ColdFusion
• Time formats in ColdFusion
• Date and time stamping the home page

5. Working with Variables in ColdFusion

• Setting variables with
• Displaying the value a variable contains with

6. Passing Variables Between Pages in ColdFusion

• Passing variables via links (URLs)
• Passing variables via forms

7. Building Forms with ColdFusion Studio

• Creating form elements
• Constructing a short form and response page

8. Distinguishing Among Variable Types in ColdFusion

• Conditionals in ColdFusion
• and conditionals
• ColdFusion conditional operators
• Using and to perform form validation
• and form validation
• Adding one or more blocks to a conditional
• Validating a form on the server with a simple conditional expression

9. Database Concepts

• The databases used in this class

10. An Introduction to SQL

• Issuing database commands with SQL
• Retrieving information with SELECT
• Inserting a row in a table with INSERT
• Editing records with UPDATE
• Delete records with DELETE
• SQL syntax

11. Querying a Database in ColdFusion

• The tag
• The tag and its query attribute
• Example: a sample database query
• Distinguishing query variables from other ColdFusion variables
• Counting the number of records returned from a query with query namerecordcount
• Querying the database for all artists

12. Displaying Multiple Records Returned by a Query in HTML Table Format93

• Creating HTML tables manually
• Creating HTML tables with the tag
• Displaying all artist in table format

13. Dynamically Populating Select Lists

• Example: dynamically populating a select list via
• Using to create auto-populating select lists
• Dynamically generating a select list

14. Implementing Basic Data Drill-Downs

• Explanation of drill-down code
• Drilling down to display an artist's works of art

15. Inserting Records into the Database

• Inserting a record into a database table with ColdFusion
• Inserting a work of art into the artworks table
• Using hidden fields to pass data in a form submission
• Inserting a work of art into the database
• The tag
• When not to use
• Implementing

16. Form Validation

• Client-side form validation
• Building a client-side validating account creation form
• Server-side form validation
• Building a server-side validating account creation form

17. Editing Records in the Database

• Editing records with UPDATE
• Building a editing application to edit works of art
• Using the tag's value attribute to show database values
• The UPDATE page
• Editing an atist's contact information
• The tag
• Implementing

18. Using the Tag to Redirect Users

• The tag
• The isdefined() function
• Automatically redirecting the browser

19. Deleting Records from the Database

• Removing records from a database with the SQL DELETE dtatement
• Deleting works of art from our database
• Deleting a work of art from the database

20. Generating Email Messages with the Tag

21. ColdFusion MX Administrator Configuration Information

• Accessing the ColdFusion administrator
• Using the ODBC data sources option
• Setting the mail server connection
• ColdFusion variable types
• Debugging advice
• Recommended resources

22. Introduction to Code Editors

• Our Database: the WestLake used car exchange

23. Specialized Output

• Output shortcuts
• The CFDUMP Tag
• Automating output with CFDUMP

24. Debugging Settings

• Limit debugging to certain IP addresses
• View debug information

25. Charts & Graphs with CFCHART

• Additional attributes of CFCHART and CFCHARTSERIES
• Caching charts
• Save charts for future use
• Building simple charts

26. Adding Links in Your Chart

• Adding data points individually with CFCHARTDATA
• Adding links to your graphs

27. Showing Portions of a Recordset

• Paging through a recordset
• Set up our variables
• Limit the loop for this page
• Insert links to move back or forward
• Hide the links at the beginning and the end
• Cache the query
• Paging through records

28. Dividing into Table Columns

• Set up the variables
• Create the table structure
• Limit the CFOUTPUT loops
• Listing owners in two columns

29. Reusing Content: Reduce, Reuse, Recycle

• Queries of queries
• Building queries of a query

30. The CFLOCATION Tag

• Where and how is CFLOCATION used?

31. The CFINCLUDE Tag

• Code shortcuts with CFINCLUDE

32. Custom Tags

• Where to find custom-tag files
• Transmitting variables as attributes
• What if the attribute is missing?
• Variable scope
• CALLER variables
• Using CFMODULE
• Custom tag shortcuts

33. Using Stored Procedures

• Advantages of stored procedures
• Calling a simple stored procedure

34. Stored Procedures with Parameters

• The CFPROCPARAM tag
• Using stored procedure parameters for safety
• Adding people with a stored procedure
• Deleting safely

35. Tracking User Information

• Working with cookies
• Cookie demonstration
• Identifying a visitor with cookies

36. Session Variables

• Application.cfm and OnRequestEnd.cfm
• Session and application
• Required CFAPPLICATION tag
• Locking session and application variables with CFLOCK

37. Password Protection with Sessions

• Example: pages with password protection
• Password protection

38. Advanced Form Validation

• Regular expressions
• REFind and REFindNoCase
• Regular expression example
• Special characters for pattern matching
• Escape sequences for special characters
• Specifying ranges in patterns
• Matching a specified number of occurrences
• Character-range escape sequences
• Matching at the beginning or end of a string with ^ and $
• The Word-boundary pattern anchors:\b and \B
• Validating a form with regular expressions

39. Error Handling

• Errors and exceptions
• Terminology: error versus exception

40. Identifying and Preventing the Problem

• The IsNumeric() function
• An ounce of prevention
• Preventing errors

41. Standard Error Handling

• The CFERROR tag
• Syntax of CFERROR
• The error page
• Sharing your CFERROR tag
• Building a CFERROR response

42. Structured Error Handling

• CFTRY and CFCATCH tags
• Creating exceptions with CFTHROW
• Using CFTHROW with custom tags
• Catching exceptions

43. Database Transactions

• The CFTRANSACTION tag
• CFTRANSACTION and CFTRY

44. Manipulating the File System

• Manipulating files with CFFILE
• Example: reading a text file
• The ExpandPath() function
• Syntax of CFFILE
• Example: writing to a text tile
• The FileExists() and DirectoryExists() functions
• CFFILE tags for writing and appending
• Writing text files

45. Using CFFILE for HTML Pages

• An HTML example
• Excessive quoted text: the CFSAVECONTENT solution
• The ParagraphFormat() function
• The replace() function
• Complicated line breaks on Windows computers
• Writing HTML files

46. Uploading Files

• Sample: uploading photos
• Step 1: form features
• Step 2: receiving the uploaded file
• Displaying the image in an IMG tag
• The CFFILE variables
• Uploading images

47. Manipulating Files and Directories on the Server

• Additional CFFILE features
• Directory manipulation with CFDIRECTORY
• Example: listing all files of a given type

48. Programming with ColdFusion

• Complex data objects: arrays, lists and structures
• Scalar variables
• Lists
• Arrays
• Structures
• Working with lists and arrays

49. CFLOOP: Another Looping Option

• Syntax of CFLOOP
• Weeding out the FIELDNAMES variable
• Using CFLOOP for automatic query output
• Display web-safe colors using CFLOOP
• Automating output with CFLOOP

50. CFSCRIPT

• Capabilities of CFSCRIPT
• Syntax rules
• Reserved words
• Looping with CFSCRIPT
• GetTickCount() - testing the speed of your code
• Use CFSCRIPT to set variables

51. User-Defined Functions (UDFs)

• Creating UDFs with CFSCRIPT
• Creating UDFs with the CFFUNCTION tag
• Create a user-defined function with CFFUNCTION

52. Using Components

• Creating components
• Calling or invoking components
• Passing arguments to components
• The main CFML page
• View a component directly in the browser
• Web services
• Selecting among ColdFusion code reuse methods
• Building components

53. Search Engine

• Create a search engine - Verity
• Creating a Verity collection
• Constructing the search interface
• Index your collection
• Warning: syntax error in auto-generated code
• Using the scheduler feature of the administrator
• Making your pages searchable

Virtual Classroom e-Learning Classroom Dates

Date	Times
Oct 4 - 8, 2010	11:00 AM - 5:00 PM ET	Register
Dec 13 - 17, 2010	11:00 AM - 5:00 PM ET	Register

 

Don’t see the location or date you need? No problem – just use our Request a date & location service.