User Guide

60 Developing Web Applications with ColdFusion

Inserting Data

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 (see “Creating Forms with the

CFFORM Tag” on page 124) 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.

Creating an HTML Insert Form

To create an insert form:

1. Create a new application page in Studio.

2. Edit the page so that it appears as follows:

<HTML>

<HEAD>

<TITLE>Insert Data Form</TITLE>

</HEAD>

<BODY>

<H2>Insert Data Form</H2>

Employee ID:

First Name:

Last Name:

Department Number:

<INPUT TYPE="text" NAME="Department_ID" SIZE="4"

MAXLENGTH="4"><BR>

Start Date:

Salary:

Contractor:

<INPUT TYPE="checkbox" name="Contract" value="Yes"

checked>Yes<BR><BR>

</FORM>

</BODY>