Updating data in a database is usually done with two pages:
You can create an update form with CFFORM tags or HTML form tags. The update form calls an update action page, which can contain either a CFUPDATE tag or a CFQUERY tag with a SQL UPDATE statement. The update action page should also contain a message for the end user that reports on the update completion.