CF10: Updating Data

Summary

·Generally, you need three pages to perform an update:

¨A page to choose a row to update

¨A page to display and update the row

¨A page to process the update

·Use ColdFusion variables to pre-fill a form.

·Server-side validation involves checking for required fields after a form has been submitted. Client-side validation validates input before the form is submitted.

·Client-side validation can only be accomplished with a scripting language such as JavaScript.

·Use CFUPDATE or CFQUERY with an SQL UPDATE statement to update database tables.