ColdFusion MX Essential Training

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.

Table of contents

Introduction

• welcome 1:23 1.0 MB

1. Introducing ColdFusion

• understanding ColdFusion 3:25 2.5 MB
• installing 11:51 11.8 MB
• using the ColdFusion administrator 3:35 6.2 MB
• setting up the web server 3:53 3.3 MB
• selecting an editor 4:43 5.1 MB

2. Learning CFML Basics

• working with variables 11:07 11.1 MB
• using numbers 2:55 3.8 MB
• setting variables 8:22 8.8 MB
• using strings 4:02 4.9 MB
• viewing variable values 2:02 2.4 MB
• retrieving query string variables 5:16 5.8 MB
• retrieving form variables 9:58 11.1 MB
• building a storyteller application 13:59 27.0 MB
• adding conditional logic 10:45 12.6 MB
• checking if variables are defined 5:22 6.5 MB
• self posting form 7:06 10.4 MB
• amending the storyteller application part 2 8:02 15.8 MB
• dynamically including templates 4:55 6.2 MB
• amending the storyteller application part 3 4:01 7.7 MB
• ColdFusion parameters 8:39 13.3 MB
• defining default values 3:40 5.0 MB
• understanding default values in context 4:43 7.8 MB
• using CFPARAM 2:12 3.2 MB
• using default values with text inputs 3:25 5.4 MB
• amending the storyteller application part 4 7:59 13.7 MB

3. Managing Code

• adding code comments 4:43 5.5 MB
• debugging code 3:59 8.0 MB

4. Working with Databases

• understanding databases 1:53 1.1 MB
• designing databases 11:36 10.4 MB
• selecting database management system 3:50 2.4 MB
• creating a database 8:11 6.5 MB
• registering a ColdFusion datasource 4:51 5.4 MB
• configuring the database 2:08 1.6 MB

5. Using SQL

• understanding SQL 3:47 5.3 MB
• using SELECT statements 8:47 13.0 MB
• selecting fields 2:17 3.1 MB
• adding WHERE clauses 4:22 9.1 MB
• selecting data from more than one table 6:14 12.1 MB
• outputting query data 3:07 3.8 MB
• building a user list application 7:35 13.4 MB
• viewing details 7:28 10.6 MB
• building user list details 7:28 14.5 MB
• adding ORDER BY clauses 6:06 9.0 MB
• ordering the user list 8:09 14.9 MB
• making pageable record sets 9:35 16.3 MB
• making the userlist pageable 6:39 13.4 MB
• ordering the user list 6:29 12.7 MB
• adding a records per page feature 12:30 24.2 MB
• cleaning up the user list 7:29 13.8 MB
• cleaning up the user list part 2 4:46 9.3 MB
• matching partial values 5:44 8.1 MB
• matching partial values note 2:54 3.5 MB
• searching the user list 13:18 26.2 MB
• selecting multiple list items 7:13 11.9 MB
• using IN 9:22 14.9 MB
• filtering the user list 16:14 32.5 MB
• caching queries 5:48 7.9 MB
• caching the user list query 4:01 8.3 MB
• inserting records 7:05 8.8 MB
• registering users 10:20 19.8 MB
• registering users part 2 5:51 10.9 MB
• registering users part 3 3:08 5.0 MB
• pre-filling a form 2:56 4.6 MB
• registering users part 4 3:09 5.9 MB
• registering users part 5 3:34 7.1 MB
• validating form input 5:50 8.4 MB
• registering users part 6 5:00 10.2 MB
• updating records 7:36 10.7 MB
• redirecting pages 2:27 3.4 MB
• looping through queries 4:52 7.4 MB
• editing user information 6:29 12.0 MB
• editing user information part 2 7:57 15.7 MB
• editing user information part 3 5:37 11.1 MB
• deleting records 3:16 4.7 MB
• delete confirmation screen 9:20 18.2 MB
• deleting users 8:46 17.4 MB

6. Managing Applications

• adding an application framework 8:34 11.8 MB
• specifying a datasource variable 4:07 7.5 MB
• adding login functionality 4:35 5.9 MB
• adding login functionality part 2 7:36 10.8 MB
• building a login application 2:25 4.7 MB
• building a login application part 2 6:34 9.2 MB
• getting the user information 1:25 1.8 MB
• adding conditional logic based on user 2:22 4.5 MB
• logging out 3:25 5.5 MB
• checking for roles 2:06 3.0 MB
• making the administrator role 4:36 7.9 MB
• hiding the register option for users that are logged in 6:24 8.9 MB
• adding administrator subnavigation 4:27 8.0 MB
• adding a user update form 10:46 20.8 MB

7. Dates and Times

• creating a dates and times 5:27 7.4 MB
• formatting dates and times 5:34 8.1 MB
• parsing dates and times 5:02 7.1 MB
• introducing CFLOOP 7:22 10.6 MB
• creating a calendar 13:21 21.9 MB
• creating a calendar part 2 13:26 24.9 MB
• inserting dates and times into a database 15:00 28.1 MB
• adding events to the calendar application 13:56 27.2 MB
• adding events to the calendar application part 2 5:17 10.1 MB
• using BETWEEN in SQL 2:56 5.1 MB
• listing events in the calendar application 5:54 11.8 MB
• adding an event details page 8:01 13.8 MB
• adding an event update form 12:09 23.5 MB
• adding an event update form part 2 9:05 17.9 MB
• adding an event delete option 5:10 8.3 MB

8. Storing Client-side Data

• using CFCOOKIE 7:43 10.6 MB
• building a color panel feature 3:11 6.0 MB
• building a color panel feature part 2 3:42 7.2 MB
• building a color panel feature part 3 2:31 4.0 MB
• building a color panel feature part 4 6:31 12.6 MB
• understanding MOD 4:11 6.6 MB
• building a color panel feature part 5 2:25 4.5 MB
• adding automatic apply JavaScript 6:41 12.4 MB

9. Ordered Data

• introducing arrays 8:27 12.5 MB
• looping through arrays 5:53 9.3 MB
• sorting arrays 5:27 8.1 MB
• using lists 5:44 7.3 MB
• filtering user list data 3:56 7.5 MB
• working with structures 5:13 6.7 MB
• using array access notation with structures 3:55 4.8 MB
• looping through structures 4:45 6.7 MB
• creating arrays of structures 5:19 8.1 MB
• enabling sessions 5:10 6.6 MB
• adding session variables 4:31 6.1 MB
• building a store application 2:54 4.6 MB
• adding a store product list 6:08 11.5 MB
• building an add to cart feature 5:22 7.7 MB
• listing the cart items 4:58 8.1 MB
• managing duplicate items 4:33 7.3 MB
• deleting items 6:57 13.0 MB
• updating items 7:25 14.6 MB
• checking out 9:06 16.4 MB
• listing the order 3:11 5.8 MB
• deleting the order 4:02 6.6 MB

10. Advanced SQL and Charting

• using SQL function 3:50 5.2 MB
• working with GROUP BY 3:09 3.8 MB
• using additional SQL functions 2:07 3.1 MB
• charting data 4:26 7.0 MB
• adding a user report chart 8:48 17.0 MB
• applying chart styles 7:19 14.0 MB
• 11. Email
• using CFMAIL 4:51 7.4 MB
• adding a password retrieval feature 6:46 11.8 MB

12. Working with Files

• using the ExpandPath() function 3:15 4.2 MB
• using file fields 3:26 5.1 MB
• uploading files 6:16 10.8 MB
• adding an update image feature 6:36 12.5 MB
• adding an update image feature part 2 10:32 18.6 MB
• writing new files 2:53 4.6 MB
• emailing charts 3:02 5.5 MB
• writing charts to files 6:37 13.1 MB
• emailing attachments 2:47 4.3 MB
• emailing charts as attachments 3:01 6.0 MB

Conclusion

• goodbye