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