Getting Started with ColdFusion 10

Create Dynamic, Database-Driven Websites

In this course, expert web developer and trainer Candyce Mairs teaches you how to build a dynamic, database-driven website using ColdFusion 10 and ColdFusion Builder. You’ll learn how to set up a testing environment — including installing ColdFusion, ColdFusion Builder, and a database — and be introduced to the basics of dynamic websites. Then you’ll work along with Candyce as she creates a complete database-driven ColdFusion website. Along the way you’ll learn how to work with forms, scoped variables, queries, ColdFusion functions, and more, and get up to speed on ColdFusion 10 features such as function enhancements for queries, new forms of looping, and new attributes.

Trainer: Candyce Mairs

August 2012

Duration: 5 hrs

Ready for iPad, Android, and HTML5

Powerful, Feature-Rich Interface

HD Video

ColdFusion

Add to Cart Downloads

Similar Courses

Welcome to Getting Started with ColdFusion 10

In this chapter we'll explore such basics as what ColdFusion is and what it does. You'll also learn how to install ColdFusion, modify its settings, and set up a new project to get started with.

ColdFusion Fundamentals
- The process of working with a server-side language and making dynamic page requests is very different from using a static page request. In this video you'll learn more about the differences between static and dynamic page requests and why a server-side language is needed in this process.
  
  Understanding Static vs. Dynamic Requests
  
  05:22
- What is ColdFusion and why would you want use it? This lesson explains what ColdFusion does when a user requests a web page and describes why it is needed in this process.
  
  What Is ColdFusion?
  
  06:40
- This video walks you through the steps involved in downloading and installing ColdFusion and explains the various screens you'll see during the installation process.
  
  Installing ColdFusion
  
  08:48
- Once you have installed ColdFusion, the ColdFusion Administrator is opened so you can modify ColdFusion settings as needed. In this lesson we will take a look at the ColdFusion Administrator and modify a couple of settings to prepare for our work in this course.
  
  Using the ColdFusion Administrator
  
  07:34
- Once ColdFusion is installed, there is a folder where all of the ColdFusion server files are located on the local system. This is where you will want to put the course files for the Travel Adventures website that will be built throughout this course, and this lesson will show you how to do so.
  
  Installing the Course Files
  
  02:39
- ColdFusion Builder is an interface created by Adobe specifically for use with ColdFusion. This video walks you through the steps required to install ColdFusion Builder on your system to use for this course.
  
  Installing ColdFusion Builder
  
  07:21
- In order to work in ColdFusion Builder, you need to set up a project. This lesson walks you through the process of setting up our course files as a project in ColdFusion Builder.
  
  Setting Up a Project
  
  07:31
This chapter gets you started creating ColdFusion template pages and working with ColdFusion variables and include files. You'll also become familiar with debugging in ColdFusion.

ColdFusion Basics
- In this lesson you'll learn how to create a new ColdFusion template page and become familiar with the ColdFusion Builder interface. We'll also look at why we use the term "template" when referring to a ColdFusion page.
  
  ColdFusion Templates
  
  08:08
- ColdFusion stores information using variables, and in this video you'll learn what a variable is and how to create and display variables on a web page.
  
  Creating and Displaying Variables
  
  08:32
- ColdFusion allows you to store variables based on how long you want them to exist within your application. In this lesson you'll become familiar with this process, which is called "variable scoping," and learn more about what happens if you reference a variable that does not exist in ColdFusion.
  
  Scoping Variables
  
  05:32
- Include files are a very handy feature that allow you to pull coding from other ColdFusion pages onto a web page as if that coding existed on the page. In this video we will use this technique to create a new master page that can be used as a base page for our Travel Adventures website.
  
  Working with Include Files
  
  08:23
- Debugging your code is an important part of the process of creating web pages. In this lesson you'll learn how to access the ColdFusion Administrator from within ColdFusion Builder and turn on additional debugging information for your development environment.
  
  Debugging Your Code
  
  06:60
This chapter looks at working with ColdFusion queries to pull data out of a database, including how to create a datasource in ColdFusion. We will also look at query properties that are available to you when a query is performed and how they can be used on your web pages.

Pulling Data from a Database
- In order to work with a database, you need to install the database and set up a datasource so ColdFusion knows what type of database it is and where it is located. This lesson walks you through the process of installing a database and setting up a datasource in ColdFusion.
  
  Creating a Datasource
  
  07:11
- In order to pull data out of a database, you need to write SQL that is sent to the database by ColdFusion. In this lesson you'll learn how to do so.
  
  Building a Query
  
  05:14
- ColdFusion offers you a way to preview the results of a query without having to create a table or any additional code other than a single line. This involves using the CFDUMP tag, as you'll see in this video.
  
  Viewing Query Results Using CFDUMP
  
  05:56
- Every query you run has properties automatically assigned by ColdFusion that are available for you to use within your code. We'll take a look at some of these properties and output them to the page in this lesson.
  
  Properties of a Query
  
  05:07
- It is a good idea to be aware of various errors that can occur within your query code, especially if you are not familiar with debugging. In this lesson we'll intentionally create query errors so you can see what happens if an error occurs.
  
  Debugging Queries
  
  06:00
Once data has been pulled out of the database, it must be displayed on the page in some manner. In this chapter you'll learn how to display database data and work with query properties in a web page.

Displaying Database Data
- ColdFusion code is read from top to bottom on the page. In this lesson you'll learn how to tell ColdFusion to display all of the results of a query on a web page.
  
  Outputting Query Results
  
  08:43
- ColdFusion Builder offers features that can assist you with building and formatting your code. In this lesson you'll learn how to use those features to organize the coding on the page and make working in Code view easier and more organized.
  
  Fine Tuning Query Output
  
  06:57
- It is often easier to display query data in a table rather than as text sitting on the page. This lesson covers how to display query data in a table for the user and have ColdFusion add a table row for each record returned from the database.
  
  Displaying Data Using a Table
  
  08:55
In this chapter you'll learn how to use a querystring to pass URL variables between pages. We will also correct link issues within our navbar area and create a two-page tours interface that will allow the user to click a hyperlink for a tour and view the details about that tour on the next page.

Passing Data Between Pages
- In this lesson you'll learn how to create a URL variable within a querystring to pass ColdFusion variables from one web page to another.
  
  Working with URL Variables
  
  09:03
- Most URL variables are not hard-coded values, but rather are created dynamically by ColdFusion. You'll learn how to create dynamic URL variables in this lesson.
  
  Dynamic URL Variables
  
  08:27
- At this point in the project, the navbar area is not linking to the correct file extension. In this lesson we'll use ColdFusion Builder's Find and Replace feature to easily correct this file extension issue across the entire project.
  
  Correcting the Tours Link
  
  06:31
- In this lesson we'll build the tours page that will list each tour in the Travel Adventures database. Each tour will be listed as a hyperlink that will display the details about that specific tour when the user clicks the hyperlink.
  
  Creating a Tours Interface
  
  09:15
- Now that the tours page has the tours being pulled from the database, we need to create a querystring that will send the specific tour the user chose to the details page. In this lesson we will complete the tours page, adding the tour ID for each tour to the hyperlink so the details page knows which tour details to display.
  
  Completing the Tours Listing
  
  08:48
- When it comes time to display the tour details page, we want to query the database to retrieve the information for the specific tour the user has chosen. In this lesson we'll use a cfquery tag to accomplish this.
  
  Creating the Tour Details Page
  
  09:23
- The tours page now lists all of our tours and is passing information to the tour details page so we can query the database for the details about a specific tour. In this lesson we'll complete the page that will display the tour details for each tour and correct errors that may occur if the user does not begin on the tours page.
  
  Displaying the Tour Details
  
  10:28
In this chapter we will begin to work with form data for the Travel Adventures "Contact Us" page. You'll see how the forms process works and learn how to reference and display data the user enters into a form.

Working with Form Data
- This lesson is designed for users who have never created an HTML form. You'll learn how the forms process works and become familiar with form terminology.
  
  Understanding the Forms Process
  
  07:03
- In this lesson we will look at the form pages that have already been created for the Travel Adventures website so you become familiar with them before we work on displaying form data on a form action page.
  
  Reviewing the Contact Us Form Pages
  
  03:29
- In this lesson we will take the "Contact Us" page for Travel Adventures and display the data a user enters into the form on an action page using ColdFusion.
  
  Displaying Form Information
  
  08:08
- This lesson shows you how to send the user to another web page using ColdFusion coding and looks at what you need to consider when redirecting with this tag.
  
  Redirecting the User
  
  05:06
It is important for the admin to be able to insert new tours into the database via the web, and in this chapter we'll create the pages and processes that make this possible.

Inserting New Tours into the Database
- This lesson looks at the difference between the SQL statements used to pull data out of the database and the SQL statement required to insert data into the database. You'll also see how to view database field information using RDS in ColdFusion.
  
  Viewing SQL Statements
  
  06:36
- In this lesson we'll add the ColdFusion code to insert a new tour into the database provided the user has filled out the Insert Tour form and clicked the Submit button. We will build the SQL statement to insert new tours into the database and confirm that the information was inserted correctly into the database.
  
  Inserting Database Data
  
  09:41
- Now that the insert statement has been added to our tours form, we need to send the user to another page so they can see that the tour has been added to the database. This lesson reviews our Insert Tour form and confirms that our tour insertion code is working and tours are being added to the website.
  
  Reviewing the Insert Form
  
  08:01
- ColdFusion offers the ability to add form validation to your form fields very easily using ColdFusion form tags which provides additional attributes for your form field coding. These additional attributes allow you to set fields as required and add messages to provide to the user if they do not fill in a form field. We will look over the Travel Adventures insert form modified with ColdFusion form validation added by using ColdFusion form tags.
  
  Adding ColdFusion Form Validation
  
  09:43
In this chapter we will look at how to modify existing data in a database using a SQL UPDATE statement. We will also look at using ColdFusion code to prevent SQL injections from occurring when data is inserted into a database with a web form. Finally, we'll create a page that the admin can use as a home page to insert new tours or update existing tour information.

Modifying Database Data
- In this lesson we will go over the steps involved in creating an update area for the Travel Adventures website so administrators can modify data that already exists within the database.
  
  Creating an Update Area
  
  04:06
- In order to set up for our update area, we need to add a form to our update page, make sure THE form validation is working on this form, and add the SQL to query the database for a single tour. In this lesson we'll build the form, check its validation features, and set up the coding to make use of the tourID that is being passed to this page.
  
  Setting Up to Populate Form Fields
  
  11:03
- This lesson describes how to populate form fields with query data. We will use the tour ID to query the database and populate the form fields in our form with the database data.
  
  Populating Form Fields with Query Data
  
  08:03
- The Travel Adventures website update form has one remaining form field to correct. In this lesson you'll learn how to add a ColdFusion function to correct form display and address a couple of minor issues in our form.
  
  Using ColdFusion Functions
  
  05:13
- In order to modify data that already exists within a database we need to create an UPDATE statement. This lesson walks you through the coding necessary to update the information for any tour in the database. We will add the ColdFusion code to prevent SQL injections from occurring by using a ColdFusion tag that will process the form information and validate the datatype for this information before it is inserted into the database.
  
  Adding the Update SQL Coding
  
  11:46
- Now that the tours area is complete and we have created the pages and coding to insert and update the tours in the database, we will create the admin page to bring it all together in this video. We will also provide access for admins to insert new tour information or update the existing tours in the database.
  
  Creating the Admin Home Page
  
  02:12

Welcome to Getting Started with ColdFusion 10

In this workshop you’ll learn how to how to build a complete dynamic, database-driven website using ColdFusion 10 and ColdFusion Builder. The contents of this course include:

ColdFusion Fundamentals
In this chapter we’ll explore such basics as what ColdFusion is and what it does. You’ll also learn how to install ColdFusion, modify its settings, and set up a new project to get started with.

ColdFusion Basics
This chapter gets you started creating ColdFusion template pages and working with ColdFusion variables and include files. You’ll also become familiar with debugging in ColdFusion.

Pulling Data from a Database
This chapter looks at working with ColdFusion queries to pull data out of a database, including how to create a datasource in ColdFusion. We will also look at query properties that are available to you when a query is performed and how they can be used on your web pages.

Displaying Database Data
Once data has been pulled out of the database, it must be displayed on the page in some manner. In this chapter you’ll learn how to display database data and work with query properties in a web page.

Passing Data Between Pages
In this chapter you’ll learn how to use a querystring to pass URL variables between pages. We will also correct link issues within our navbar area and create a two-page tours interface that will allow the user to click a hyperlink for a tour and view the details about that tour on the next page.

Working with Form Data
In this chapter we will begin to work with form data for the Travel Adventures “Contact Us” page. You’ll see how the forms process works and learn how to reference and display data the user enters into a form.

Inserting New Tours into the Database
It is important for the admin to be able to insert new tours into the database via the web, and in this chapter we’ll create the pages and processes that make this possible.

Modifying Database Data
In this chapter we will look at how to modify existing data in a database using a SQL UPDATE statement. We will also look at using ColdFusion code to prevent SQL injections from occurring when data is inserted into a database with a web form. Finally, we’ll create a page that the admin can use as a home page to insert new tours or update existing tour information.

The lessons are wrapped in a feature-rich interface that lets you jump to any topic and bookmark individual sections for later review. Full-Screen mode provides a hi-def, immersive experience, and Watch-and-Work mode shrinks the video into a small window so you can play the videos alongside your application. Also included are exercise files that give you an easy way to try out the techniques you learn.

System Requirements

Broadband internet connection
Up-to-date browser with Flash plug-in
Screen resolution 1024x768 or higher
Sound card with speakers or headphones attached
Pentium 4 2.6 GHz or higher, or Apple Mac G5
512 MB RAM

Ready for iPad, Android, and HTML5

It's easy to watch this course from your Android device, iPad, or iPhone (4 or later). Access videos straight from your browser, or, for Android devices or iPads, use this course in one of our free apps.

Project Files (Downloadable Feature)

Project files are included with this course so you can practice what you learn and work right along with the videos.

Powerful, Feature-Rich Interface

This course features video2brain’s interactive interface. As you navigate the course, rolling over a chapter or video brings up text describing that item.

Full-Screen mode provides a hi-def, immersive experience. And Watch-and-Work mode puts the video into a resizable window that you can shrink so you can watch the lessons on one side of your screen while you’re following along and applying what you’ve learned on the other.

HD Video

This course comes in crisp 1280 x 720 high definition video.

Bookmarks (Downloadable Feature)

Available in the downloadable version of our courses, this feature makes it easy to create a custom bookmark in any lesson to mark where you left off or to make note of something you want to refer back to later. You can even add a name or short note to remind yourself what the bookmark is for.

No comments yet

Recommended Courses

Getting Started with ColdFusion 10

Create Dynamic, Database-Driven Websites

About this lesson

Welcome to Getting Started with ColdFusion 10

System Requirements

Welcome to video2brain!

Other sites. Andere Seiten. Otros sitios. Autres sites.