How to Insert in ColdFusion

Adobe ColdFusion is a rich web application development platform designed for the easy integration of dynamic HTML web pages and the databases to which they are linked. With it, you can perform operations upon the records in a database using tags that appear very similar to common HTML elements. Using ColdFusion, you can insert the results of an HTML form into a database as a new record with one line of code.

Instructions

1

Create a new web page in your preferred text editor. Insert an HTML form into the page with textboxes, radio buttons, and other form elements that contain name values equal to the names of the column headers in the table to which you wish to insert a new record, as in the following format:

Customer Name:

Customer Email:

Opt-In? Yes No

2

Save your web page and close it.

3

Create a new web page with the same file name as the value of the "action" parameter in the code from Step 1.

4

Insert the following code into your new web page:

Substitute the names of your datasource and table for the values above.

5

Save and publish both of your web pages. When the form of the first web page is submitted, the second one will insert the values of the form into their respective table columns as a new record.