navigate site menu

Become a member and get unlimited access to every course in the library. Try it free for 7 days

ColdFusion MX Essential Training

ColdFusion MX Essential Training

with Joey Lott



ColdFusion is a technology that enables you to build sophisticated Web applications quickly and efficiently. It uses a markup language similar to HTML, so the learning curve is short, but don't let that fool you. In this comprehensive introduction to ColdFusion MX, expert Joey Lott shows how to use this powerful program to build scalable, durable web applications. Working along with Joey, you'll not only review skills such as working with databases, using forms, storing persistent data, creating dynamic charts, uploading files, and using email features, but you'll also get a chance to apply this knowledge by building specific applications. This in-depth tutorial illustrates how you can make the most of ColdFusion's common workflow and best practices in your own web development.
Topics include:
  • Introduction to ColdFusion
  • Learning CFML basics
  • Managing code
  • Working with databases
  • Using SQL
  • Managing applications
  • Working with dates and times
  • Storing client-side data
  • Ordered data
  • Advanced SQL and charting

show more

author
Joey Lott
subject
Developer, Web
software
ColdFusion MX
level
Beginner
duration
15h 16m
released
Oct 25, 2004

Share this course

Learn more about lynda.com

Start learning today. Lynda explains how.

Ready to join? subscribe

Keep up with news, tips, and latest courses.

submit Course details submit clicked more info

Please wait...

Search the closed captioning text for this course by entering the keyword you’d like to search, or browse the closed captioning text by selecting the chapter name below and choosing the video title you’d like to review.



Introduction
welcome
Collapse this transcript
1. Introducing ColdFusion
understanding ColdFusion
Collapse this transcript
installing
Collapse this transcript
using the ColdFusion administrator
Collapse this transcript
setting up the web server
Collapse this transcript
selecting an editor
Collapse this transcript
2. Learning CFML Basics
working with variables
Collapse this transcript
using numbers
Collapse this transcript
setting variables
Collapse this transcript
using strings
Collapse this transcript
viewing variable values
Collapse this transcript
retrieving query string variables
Collapse this transcript
retrieving form variables
Collapse this transcript
building a storyteller application
Collapse this transcript
adding conditional logic
Collapse this transcript
checking if variables are defined
Collapse this transcript
self posting form
Collapse this transcript
amending the storyteller application part 2
Collapse this transcript
dynamically including templates
Collapse this transcript
amending the storyteller application part 3
Collapse this transcript
ColdFusion parameters
Collapse this transcript
defining default values
Collapse this transcript
understanding default values in context
Collapse this transcript
using CFPARAM
Collapse this transcript
using default values with text inputs
Collapse this transcript
amending the storyteller application part 4
Collapse this transcript
3. Managing Code
adding code comments
Collapse this transcript
debugging code
Collapse this transcript
4. Working with Databases
understanding databases
Collapse this transcript
designing databases
Collapse this transcript
selecting database management system
Collapse this transcript
creating a database
Collapse this transcript
registering a ColdFusion datasource
Collapse this transcript
configuring the database
Collapse this transcript
5. Using SQL
understanding SQL
Collapse this transcript
using SELECT statements
Collapse this transcript
selecting fields
Collapse this transcript
adding WHERE clauses
Collapse this transcript
selecting data from more than one table
Collapse this transcript
outputting query data
Collapse this transcript
building a user list application
Collapse this transcript
viewing details
Collapse this transcript
building user list details
Collapse this transcript
adding ORDER BY clauses
Collapse this transcript
ordering the user list
Collapse this transcript
making pageable record sets
Collapse this transcript
making the userlist pageable
Collapse this transcript
ordering the user list
Collapse this transcript
adding a records per page feature
Collapse this transcript
cleaning up the user list
Collapse this transcript
cleaning up the user list part 2
Collapse this transcript
matching partial values
Collapse this transcript
matching partial values note
Collapse this transcript
searching the user list
Collapse this transcript
selecting multiple list items
Collapse this transcript
using IN
Collapse this transcript
filtering the user list
Collapse this transcript
caching queries
Collapse this transcript
caching the user list query
Collapse this transcript
inserting records
Collapse this transcript
registering users
Collapse this transcript
registering users part 2
Collapse this transcript
registering users part 3
Collapse this transcript
pre-filling a form
Collapse this transcript
registering users part 4
Collapse this transcript
registering users part 5
Collapse this transcript
validating form input
Collapse this transcript
registering users part 6
Collapse this transcript
updating records
Collapse this transcript
redirecting pages
Collapse this transcript
looping through queries
Collapse this transcript
editing user information
Collapse this transcript
editing user information part 2
Collapse this transcript
editing user information part 3
Collapse this transcript
deleting records
Collapse this transcript
delete confirmation screen
Collapse this transcript
deleting users
Collapse this transcript
6. Managing Applications
adding an application framework
Collapse this transcript
specifying a datasource variable
Collapse this transcript
adding login functionality
Collapse this transcript
adding login functionality part 2
Collapse this transcript
building a login application
Collapse this transcript
building a login application part 2
Collapse this transcript
getting the user information
Collapse this transcript
adding conditional logic based on user
Collapse this transcript
logging out
Collapse this transcript
checking for roles
Collapse this transcript
making the administrator role
Collapse this transcript
hiding the register option for users that are logged in
Collapse this transcript
adding administrator subnavigation
Collapse this transcript
adding a user update form
Collapse this transcript
7. Dates and Times
creating a dates and times
Collapse this transcript
formatting dates and times
Collapse this transcript
parsing dates and times
Collapse this transcript
introducing CFLOOP
Collapse this transcript
creating a calendar
Collapse this transcript
creating a calendar part 2
Collapse this transcript
inserting dates and times into a database
Collapse this transcript
adding events to the calendar application
Collapse this transcript
adding events to the calendar application part 2
Collapse this transcript
using BETWEEN in SQL
Collapse this transcript
listing events in the calendar application
Collapse this transcript
adding an event details page
Collapse this transcript
adding an event update form
Collapse this transcript
adding an event update form part 2
Collapse this transcript
adding an event delete option
Collapse this transcript
8. Storing Client-side Data
using CFCOOKIE
Collapse this transcript
building a color panel feature
Collapse this transcript
building a color panel feature part 2
Collapse this transcript
building a color panel feature part 3
Collapse this transcript
building a color panel feature part 4
Collapse this transcript
understanding MOD
Collapse this transcript
building a color panel feature part 5
Collapse this transcript
adding automatic apply JavaScript
Collapse this transcript
9. Ordered Data
introducing arrays
Collapse this transcript
looping through arrays
Collapse this transcript
sorting arrays
Collapse this transcript
using lists
Collapse this transcript
filtering user list data
Collapse this transcript
working with structures
Collapse this transcript
using array access notation with structures
Collapse this transcript
looping through structures
Collapse this transcript
creating arrays of structures
Collapse this transcript
enabling sessions
Collapse this transcript
adding session variables
Collapse this transcript
building a store application
Collapse this transcript
adding a store product list
Collapse this transcript
building an add to cart feature
Collapse this transcript
listing the cart items
Collapse this transcript
managing duplicate items
Collapse this transcript
deleting items
Collapse this transcript
updating items
Collapse this transcript
checking out
Collapse this transcript
listing the order
Collapse this transcript
deleting the order
Collapse this transcript
10. Advanced SQL and Charting
using SQL function
Collapse this transcript
working with GROUP BY
Collapse this transcript
using additional SQL functions
Collapse this transcript
charting data
Collapse this transcript
adding a user report chart
Collapse this transcript
applying chart styles
Collapse this transcript
11. Email
using CFMAIL
Collapse this transcript
adding a password retrieval feature
Collapse this transcript
12. Working with Files
using the ExpandPath() function
Collapse this transcript
using file fields
Collapse this transcript
uploading files
Collapse this transcript
adding an update image feature
Collapse this transcript
adding an update image feature part 2
Collapse this transcript
writing new files
Collapse this transcript
emailing charts
Collapse this transcript
writing charts to files
Collapse this transcript
emailing attachments
Collapse this transcript
emailing charts as attachments
Collapse this transcript
Conclusion
goodbye
Collapse this transcript


Suggested courses to watch next:

ColdFusion 9 Essential Training (7h 21m)
David Gassner

ColdFusion 9 New Features (2h 40m)
Daniel Short


ColdFusion Builder Essential Training (2h 57m)
Daniel Short

ColdFusion 9: AJAX Controls and Techniques (3h 33m)
Daniel Short


Are you sure you want to delete this bookmark?

cancel

Bookmark this Tutorial

Name

Description

{0} characters left

Tags

Separate tags with a space. Use quotes around multi-word tags. Suggested Tags:
loading
cancel

bookmark this course

{0} characters left Separate tags with a space. Use quotes around multi-word tags. Suggested Tags:
loading
cancel

Error:

go to playlists »

Create new playlist

name:
description:
save cancel

You must be a lynda.com member to watch this video.

Every course in the lynda.com library contains free videos that let you assess the quality of our tutorials before you subscribe—just click on the blue links to watch them. Become a member to access all 100,984 instructional videos.

start free trial learn more

If you are already an active lynda.com member, please log in to access the lynda.com library.

Get access to all lynda.com videos

You are currently signed into your admin account, which doesn't let you view lynda.com videos. For full access to the lynda.com library, log in through iplogin.lynda.com, or sign in through your organization's portal. You may also request a user account by calling 1 1 (888) 335-9632 or emailing us at cs@lynda.com.

Get access to all lynda.com videos

You are currently signed into your admin account, which doesn't let you view lynda.com videos. For full access to the lynda.com library, log in through iplogin.lynda.com, or sign in through your organization's portal. You may also request a user account by calling 1 1 (888) 335-9632 or emailing us at cs@lynda.com.

Access to lynda.com videos

Your organization has a limited access membership to the lynda.com library that allows access to only a specific, limited selection of courses.

You don't have access to this video.

You're logged in as an account administrator, but your membership is not active.

Contact a Training Solutions Advisor at 1 (888) 335-9632.

How to access this video.

If this course is one of your five classes, then your class currently isn't in session.

If you want to watch this video and it is not part of your class, upgrade your membership for unlimited access to the full library of 1,943 courses anytime, anywhere.

learn more upgrade

You can always watch the free content included in every course.

Questions? Call Customer Service at 1 1 (888) 335-9632 or email cs@lynda.com.

You don't have access to this video.

You're logged in as an account administrator, but your membership is no longer active. You can still access reports and account information.

To reactivate your account, contact a Training Solutions Advisor at 1 1 (888) 335-9632.

Need help accessing this video?

You can't access this video from your master administrator account.

Call Customer Service at 1 1 (888) 335-9632 or email cs@lynda.com for help accessing this video.


site feedback

Thanks for signing up.

We’ll send you a confirmation email shortly.

By signing up, you’ll receive about four emails per month, including

We’ll only use your email address to send you these mailings.

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

By signing up, you’ll receive about four emails per month, including

We’ll only use your email address to send you these mailings.

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked