Inserting data into a database is usually done with two application pages:
You can create an insert form with CFFORM tags (see "Creating Forms with the CFFORM Tag") or with standard HTML form tags. When the form is submitted, form variables are passed to a ColdFusion action page that performs an insert operation (and whatever else is called for) on the specified data source. The insert action page can contain either a CFINSERT tag or a CFQUERY tag with a SQL INSERT statement. The insert action page should also contain a message for the end user.