ColdFusion: Database Driven Websites
Level 2
Aims of the One-Day Course
This course has been designed to introduce trainees to the syntax, functions,
tags, and possible development solutions they're likely to encounter as
they begin to develop ColdFusion applications. Trainees will learn how
to create dynamic Web sites that interact with databases and user input.
Course Content
- Design Considerations
- Choosing the Right Formatting
- Creating dynamic tables
- Exploring CFTABLE
- Creating a Date Stamp
- ColdFusion functions
- The Now() function
- The DateFormat() function
- Applying masks
- Creating drill-down applications
- Passing URL parameters
- Passing multiple parameters
- Outputting images dynamically
- Storing image filenames
- Managing “data gaps” with conditional expressions
- The Trim() function
- The Len() function
- Updating Records
- Creating database front-ends
- Populating form controls with existing data
- Populating text fields
- Populating a textarea field
- Using hidden form fields to pass variables
- Updating records with CFUPDATE
- Recording the date and time of an update
- Capturing and storing date values
- Updating data not passed from a form
- The TimeFormat() function
- Performing SQL updates
|
- Inserting and deleting records
- Inserting records with <CFINSERT>
- Inserting data into multiple tables
- Inserting data conditionally
- Using the “AutoNumber” data type to create
ID values
- The CreateODBCDateTime() function
- Using the SQL INSERT INTO statement
- Deleting records
- Confirming a deletion request with JavaScript
- Validating data entry fields
- Exploring client-side vs server-side validation
- <CFFORM> and <CFINPUT>
- Embedding form validation rules
- Applying multiple rules
- A more customised approach to form field validation
- Using conditional expressions to test for valid data
- Applying <CFABORT>
- Initialising variables with <CFPARM>
- Re-using a variable
- Testing for multiple conditions
- Comparison Operators
- The IsNumeric() function
- The IsDate() function
- Redirecting a user with <CFLOCATION>
- Passing parameters via <CFLOCATION>
- The IsDefined() function
- The URLEncodedFormat() function
- Re-populating form after submission
- Re-using forms
- Nesting CFOUTPUT blocks
- Passing multiple parameters via CFLOCATION
- Alternative methods for re-populating forms
- Creating a keyword search application
- Database search applications
- Exploring the Verity Search engine
- Looping with <CFLOOP>
- Index loops
- ColdFusion list functions
- The ListGetAt() function
- The ListLen() function
- Creating dynamic SQL statements
- Testing applications; enabling ColdFusion debugging
|
Prerequisites
Trainees taking this course should be experienced with HTML, Internet
concepts, SQL fundamentals, and database fundamentals.
Course Duration
Six hours (9.30am to 12.30pm and 1.30pm to 4.30pm).
Next Course
ColdFusion: Creating Database-driven Web
Sites Level 3
Prices
|
