Employee database

This example provides the ability to list, view, add, edit, and delete employees, all using generic code you can reuse on other projects. Click the link to add records to the database. You can now also upload an image for each record.

1. Employee database

Note that we have used the cf_terrarule tag to check that the start and end dates are in order (i.e. to check that the end date is after the start date). TerraRule is ideal for adding relatively simple multi-field validation to your forms. See the code of frm_record.cfm for a full explanation.

Techniques demonstrated

• Listing, viewing, adding, editing, and deleting database records
• Prefilling a form with data from a query
• Using TerraRule
• Using the enhancedFile format/datatype
• Uploading images