Inserting data
441
Reviewing the code
The following table describes the code and its function:
Note:
If you use form variables in
cfinsert
or
cfupdate
tags, ColdFusion automatically validates
any form data it sends to numeric, date, or time database columns. You can use the hidden field
validation functions for these fields to display a custom error message. For more information, see
Chapter 26, “Retrieving and Formatting Data,” on page 559
.
Creating an insert action page with cfquery
For more complex inserts from a form submittal, you can use a SQL INSERT statement in a
cfquery
tag instead of using a
cfinsert
tag. The SQL INSERT statement is more flexible
because you can insert information selectively or use functions within the statement.
The following procedure assumes that you have created the insert_action.cfm page, as described
in
“Creating an insert action page with cfinsert” on page 440
.
To create an insert action page with cfquery:
1
In insert_action.cfm, replace the
cfinsert
tag with the following highlighted
cfquery
code:
<html>
<head>
<title>Input form</title>
</head>
<body>
<!--- If the Contractor check box is clear),
set the value of the Form.Contract to "No" --->
<cfif not isdefined("Form.Contract")>
<cfset Form.Contract = "No">
</cfif>
<!--- Insert the new record --->
<cfquery name="AddEmployee" datasource="CompanyInfo">
INSERT INTO Employee
VALUES (#Form.Emp_ID#, '#Form.FirstName#',
'#Form.LastName#', #Form.Dept_ID#,
'#Form.StartDate#', #Form.Salary#, '#Form.Contract#')
</cfquery>
<h1>Employee Added</h1>
<cfoutput>You have added #Form.FirstName# #Form.Lastname# to the
employee database.
Code
Description
<cfif not isdefined("Form.Contract")>
<cfset Form.Contract = "No">
</cfif>
Sets the value of Form.Contract to No if it is not
defined. If the Contractor check box is unchecked,
no value is passed to the action page; however, the
database field must have some value.
<cfinsert datasource="CompanyInfo"
tablename="Employee">
Creates a new row in the Employee table of the
CompanyInfo database. Inserts data from the form
into the database fields with the same names as the
form fields.
<cfoutput>You have added
#Form.FirstName# #Form.Lastname#
to the employee database.
</cfoutput>
Informs the user that values were inserted into the
database.
Содержание ColdFusion MX
Страница 1: ...Developing ColdFusion MX Applications...
Страница 22: ...22 Contents...
Страница 38: ......
Страница 52: ...52 Chapter 2 Elements of CFML...
Страница 162: ......
Страница 218: ...218 Chapter 10 Writing and Calling User Defined Functions...
Страница 250: ...250 Chapter 11 Building and Using ColdFusion Components...
Страница 264: ...264 Chapter 12 Building Custom CFXAPI Tags...
Страница 266: ......
Страница 314: ...314 Chapter 14 Handling Errors...
Страница 344: ...344 Chapter 15 Using Persistent Data and Locking...
Страница 349: ...About user security 349...
Страница 357: ...Security scenarios 357...
Страница 370: ...370 Chapter 16 Securing Applications...
Страница 388: ...388 Chapter 17 Developing Globalized Applications...
Страница 408: ...408 Chapter 18 Debugging and Troubleshooting Applications...
Страница 410: ......
Страница 426: ...426 Chapter 19 Introduction to Databases and SQL...
Страница 476: ...476 Chapter 22 Using Query of Queries...
Страница 534: ...534 Chapter 24 Building a Search Interface...
Страница 556: ...556 Chapter 25 Using Verity Search Expressions...
Страница 558: ......
Страница 582: ...582 Chapter 26 Retrieving and Formatting Data...
Страница 668: ......
Страница 734: ...734 Chapter 32 Using Web Services...
Страница 760: ...760 Chapter 33 Integrating J2EE and Java Elements in CFML Applications...
Страница 786: ...786 Chapter 34 Integrating COM and CORBA Objects in CFML Applications...
Страница 788: ......
Страница 806: ...806 Chapter 35 Sending and Receiving E Mail...