INTRODUCTION
GETTING STARTED
Course objectives
Static vs. dynamic pages
Introducing ColdFusion
Developing dynamic pages
Including common code
Setting up a home page
Creating template files
Creating headers and footers
USING THE DATABASE PANEL
Creating a database connection
Using the database panel
Creating a connection to an Access database
Using the Bindings panel
Creating a simple recordset
Creating an advanced recordset (areas and locations)
BINDING DATA TO A PAGE
Using Live Data View
Formatting data using the Bindings panel
Inserting a dynamic image
CUSTOMISING RECORDSET DISPLAY
Introducing Server Behaviours
Displaying all rows in a recordset
Introducing Application Objects
Using the Recordset Navigation Bar to browse through recordsets
Display recordset navigations status
Using Server Debug View
CREATING DRILL-DOWN INTERFACES
Generating dynamic links
Using dynamic filters in SQL
Using the Dynamic Table Application Object
Creating a master-detail page set
CREATING A SEARCH INTERFACE
Reviewing HTML forms
Dynamically populated dropdown menus
Creating filtered recordsets
Using form data to filter a recordset
INSERTING ROWS INTO A TABLE
Creating a form and using Insert Record Server Behaviour
Validating form data using behaviours
Creating dynamic form elements
Using the Recordset Insertion Form Application Object
UPDATING ROWS
Creating an interface for updating data
Displaying results in a table
Creating pre-filled forms
Using URL parameters
Using the Record Update Form AO
Manually creating a form
DELETING ROWS
Understanding the delete process
The delete confirmation page
Passing hidden data in a form
Using and SQL Delete statement
Using the Delete Row Application Object
AUTHENTICATING USERS
Setting and retrieving cookies
User authentication as a web application
Building the registration pages
Building the log-in page
Creating an Application.cfm
Restricting access to pages
QUESTIONS AND ANSWERS
|