In this chapter you'll learn more about this course and the environment we will be creating in order to work with ColdFusion.
Introduction
In this video you'll get an overview of this ColdFusion 9 and ColdFusion Builder course. We will be building a dynamic database-driven website using ColdFusion 9 and working in the ColdFusion Builder environment.
In this video we'll take a look at the various pieces we will be working with in our ColdFusion environment. We will be installing the ColdFusion application server, the CFML language, a JRUN web server, and an Apache Derby database. All of these separate items will be installed when we install ColdFusion 9. We will also be using ColdFusion Builder 2, the interface designed specifically by Adobe to work with ColdFusion.
There are a number of steps involved in setting up the testing environment for this course. This chapter will cover what is needed and walk through setting up the dynamic environment.
Setting Up the Dynamic Environment
This video looks at the difference between static and dynamic page requests and the various pieces required to communicate with a database.
We will modify a couple of settings in the ColdFusion Administrator in this video so we do not need to enter a password every time we want to access this area during development.
In this video we'll walk through the installation process for ColdFusion Builder 2 and look at the welcome screen and the ColdFusion Builder interface.
In this chapter we'll begin to work on ColdFusion web pages and set up our template page. You'll also learn more about ColdFusion tags and how to perform basic ColdFusion tasks.
Working with ColdFusion
This video looks at the difference between an HTML page and a ColdFusion page. We'll also discuss why ColdFusion pages are referred to as "templates" and how to create new ColdFusion pages in ColdFusion Builder.
In this lesson you'll learn more about what a variable scope is and how you define a scope. We'll also discuss what a variable is and what characters can be used in a variable name in ColdFusion.
Most dynamic websites use database data to store information that appears on a web page. In this chapter you'll learn how to set up ColdFusion so it can communicate with the database and print database data onto your ColdFusion pages.
Creating Data-Driven Pages
In order for ColdFusion to be able to communicate with the database, we must set up a datasource. In this video we will set up a datasource and use RDS to view the database data from within ColdFusion Builder. You'll also learn a little more about the ColdFusion Builder interface, how to access the ColdFusion Administrator, and how to use the help documentation.
To set up a datasource in the ColdFusion Administrator and make ColdFusion aware of the database, we need to give the datasource a name and specify a driver. This video will show you how.
This video looks at how to display database data using ColdFusion tags. We'll also talk about how to be sure that you are displaying all of the data returned from a query.
Every time you create a query in ColdFusion, you can use properties of that query in your code. In this video we'll look at a few of these properties that we can use on our page.
ColdFusion offers a handy tag, CFDUMP, that allows you to view the data stored in a variable or scope at a given time. This is a handy tool for debugging purposes. In this video we will look at how to use this tag and what the data looks like when you do so.
In this lesson we'll turn on debugging in the ColdFusion Administrator in order to view more information about our ColdFusion pages as we work in the development environment. You'll learn how to turn this feature on and what you can see once you've done so.
Due to the statelessness of the web and HTML, it is important to understand how to pass information from one page to another using a hyperlink. This chapter will demonstrate how to work with URL variables to pass data between pages.
Passing Data Between Pages
In this lesson you'll learn more about why you need to pass data from one page to another and how you can create and reference URL variables.
In this video we'll set up an example that uses URL variables in ColdFusion to pass data from one page to another. We'll also look at a common error that can occur when working with URL variables.
An error sometimes occurs when you try to work with a variable that does not exist in ColdFusion. In this video we will use a built-in ColdFusion function to take care of this issue.
We will now set up the Scuba Vacations website to give users more information about each of our tours. In this lesson we will build a tour area where users can select a tour from a listing of all of our tours and pass a querystring to the second page so it can display details about each tour.
In this lesson you'll learn how to use querystring information to query the database in order to get all the tour details for the user and print that information onto our web page.
In this video we will complete the tours process by outputting all the information about each tour and printing it onto the page. We will also address an error that can occur if the user does not start on the correct page in this process.
In this chapter you will see how to convert an HTML form into a ColdFusion form in order to take advantage of the features that ColdFusion can offer. You'll also learn about the special tags that are used in ColdFusion when working with forms.
Using ColdFusion Forms
In this lesson you'll learn more about the form process and what is required to process form data from a user.
In this lesson you'll learn the benefits of ColdFusion forms and get a brief overview of why you might want to convert your HTML forms into ColdFusion forms.
In this video we'll review the contactUs.cfm page for Scuba Vacations to see what we need to modify. We will also convert this form to a ColdFusion form so we can take advantage of the benefits of using ColdFusion forms.
In this lesson we'll modify all of our HTML form fields so we can take advantage of ColdFusion features for form field validation. We'll also look at an issue that can occur when you convert your forms and how to correct that issue.
In this chapter you'll learn more about form validation, what it means, and the various options available. You'll also see how to let ColdFusion add form validation to your forms. We'll complete the Contact Us form process for Scuba Vacations by creating an action page that will email the form data.
Form Data Validation
In this lesson you'll learn more about form validation and the difference between client-side and server-side validation so you can make a decision about what kind of validation to use on your forms. We'll also look at the options that are available for client-side validation.
You'll learn how to handle drop-down menu and radio button form field validation in this video. We'll also take a look at server-side validation in ColdFusion.
In this lesson you'll learn how to send a user to another page with ColdFusion coding. We will use this coding to send users to a "thank you" page once a form has been submitted.
In this video we will use the CFMAIL tag to convert our action page so it sends an email with the information instead of printing the form data to the page.
Now we'll take a look at the final Contact Us form process to be sure that everything is working correctly. In this video we'll look over the final email that is sent to see if the HTML tags will be honored by the recipient of the email, and we'll consider where to go from here with testing this process.