User Guide Cancel

cfinsert

Last updated on Feb 25, 2025 | Also applies to ColdFusion

ColdFusion

Open app

CFML Reference User Guide
ColdFusion functions
ColdFusion tags
1. ColdFusion tag summary
2. ColdFusion tags by category
  1. Application framework tags
    1. cfapplication
    2. cfassociate
    3. cferror
    4. cfimport
    5. cfinterface
    6. cflock
    7. cfscript
    8. cfthread
  2. Communications tags
  3. Database manipulation tags
  4. Data output tags
    1. cfchart
    1. cfchartdata
    2. cfchartseries
    3. cfchartset
    4. cfcol
    5. cfcontent
    6. cfdocument
    7. cfdocumentitem
    8. cfdocumentsection
    9. cfflush
    10. cfheader
    11. cflog
    12. cfoutput
    13. cfpresentation
    14. cfpresentationslide
    15. cfpresenter
    16. cfprocessingdirective
    17. cfprint
    18. cfreport
    19. cfreportparam
    20. cfsilent
    21. cftable
  5. Debugging tags
    1. cfdump
    2. cftimer
    3. cftrace
  6. Exception handling tags
    1. cfcatch
    2. cferror
    3. cffinally
    4. cfrethrow
    5. cfthrow
    6. cftry
  7. Extensibility tags
    1. cfchart
    2. cfchartdata
    3. cfchartseries
    4. cfcollection
    5. cfcomponent
    6. cfexecute
    7. cfftp
    8. function
    9. cfindex
    10. cfinterface
    11. cfinvoke
    12. cfinvokeargument
    13. cfobject
    14. cfproperty
    15. cfreport
    16. cfreportparam
    17. cfreturn
    18. cfsearch
    19. cfsharepoint
    20. cfspreadsheet
    21. cfwddx
    22. cfxml
  8. File management tags
    1. cfdirectory
    2. cffile
    3. cffileupload
    4. cfftp
    5. cfzip
    6. cfzipparam
  9. Flow-control tags
    1. cfabort
    2. cfbreak
    3. cfcase
    4. cfcontinue
    5. cfdefaultcase
    6. cfelse
    7. cfelseif
    8. cfexecute
    9. cfexit
    10. cfif
    11. cfinclude
    12. cflocation
    13. cfloop
    14. cfrethrow
    15. cfswitch
    16. cfthrow
    17. cftry
  10. Forms tags
    1. cfapplet
    2. cfcalendar
    3. cffileupload
    4. cfform
    5. cfformgroup
    6. cfformitem
    7. cfgrid
    8. cfgridcolumn
    9. cfgridrow
    10. cfgridupdate
    11. cfinput
    12. cfpdf
    13. cfpdfform
    14. cfpdfformparam
    15. cfpdfparam
    16. cfpdfsubform
    17. cfselect
    18. cfslider
    19. cftextarea
    20. cftree
    21. cftreeitem
  11. Internet Protocol tags
    1. cfajaximport
    2. cfajaxproxy
    3. cfftp
    4. cffeed
    5. cfimap
    6. cfhttp
    7. cfhttpparam
    8. cfldap
    9. cfmail
    10. cfmailparam
    11. cfmailpart
    12. cfpop
    13. cfsprydataset
  12. Page processing tags
    1. cfcache
    2. cfcontent
    3. cfflush
    4. cfheader
    5. cfhtmlhead
    6. cfinclude
    7. cfprocessingdirective
    8. cfsetting
    9. cfsilent
  13. Security tags
  14. Variable manipulation tags
    1. cfcookie
    2. cfdump
    3. cfparam
    4. cfregistry
    5. cfsavecontent
    6. cfschedule
    7. cfset
    8. cfsetting
  15. Other tags
    1. cfimage
    2. cflog
    3. cfregistry
3. Tags a-b
4. Tags c
5. Tags f
6. Tags g-h
  1. cfgraph
  2. cfgraphdata
  3. cfgrid
  4. cfgridcolumn
  5. cfgridrow
  6. cfgridupdate
  7. cfheader
  8. cfhtmlhead
  9. cfhtmltopdf
  10. cfhtmltopdfitem
  11. cfhttp
  12. cfhttpparam
7. Tags i
  1. cfif
  2. cfimage
  3. cfimap
  4. cfimapfilter
  5. cfimpersonate
  6. cfimport
  7. cfinclude
  8. cfindex
  9. cfinput
  10. cfinsert
  11. cfinterface
  12. cfinvoke
  13. cfinvokeargument
8. Tags j-l
9. Tags m-o
10. Tags p-q
  1. cfparam
  2. cfpdf
  3. cfpdfform
  4. cfpdfformparam
  5. cfpdfparam
  6. cfpdfsubform
  7. cfpod
  8. cfpop
  9. cfpresentation
  10. cfpresentationslide
  11. cfpresenter
  12. cfprint
  13. cfprocessingdirective
  14. cfprocparam
  15. cfprocresult
  16. cfprogressbar
  17. cfproperty
  18. cfquery
  19. cfqueryparam
11. Tags r-s
  1. cfregistry
  2. cfreport
  3. cfreportparam
  4. cfrethrow
  5. cfreturn
  6. cfsavecontent
  7. cfschedule
  8. cfscript
  9. cfsearch
  10. cfselect
  11. cfservlet
  12. cfservletparam
  13. cfset
  14. cfsetting
  15. cfsharepoint
  16. cfsilent
  17. cfslider
  18. cfspreadsheet
  19. cfsprydataset
  20. cfstoredproc
  21. cfswitch
12. Tags t
  1. cftable
  2. cftextarea
  3. cftextinput
  4. cfthread
  5. cfthrow
  6. cftimer
  7. cftooltip
  8. cftrace
  9. cftransaction
  10. cftree
  11. cftreeitem
  12. cftry
13. Tags u-z
  1. cfupdate
  2. cfwddx
  3. cfwebsocket
  4. cfwindow
  5. cfxml
  6. cfzip
  7. cfzipparam
CFML Reference
1. Reserved words and variables
2. Ajax JavaScript functions
3. ColdFusion ActionScript functions
4. ColdFusion mobile functions
5. Application.cfc reference
6. Script functions implemented as CFCs
7. ColdFusion Flash Form style reference
8. ColdFusion event gateway reference
9. ColdFusion C++ CFX Reference
10. ColdFusion Java CFX reference
11. WDDX JavaScript Objects
Cloud services

Note:

This tag is unsupported in CFFiddle.

Description

Inserts records in data sources from data in a ColdFusion form or form Scope.

Syntax

<cfinsert 
dataSource = "data source name" 
tableName = "table name" 
fetchClientInfo = "true|false" 
formFields = "formfield1, formfield2, ..." 
password = "password" 
tableOwner = "owner" 
tableQualifier = "table qualifier" 
username = "user name">

Note:

You can specify this tag's attributes in an attributeCollection attribute whose value is a structure. Specify the structure name in the attributeCollection attribute and use the tag's attribute names as structure keys.

History

ColdFusion (2025 release): Removed connectString, dbName, dbServer, dbType, provider, and providerDSN attributes.
ColdFusion 10: Added the attribute fetchClientInfo and clientInfo.
ColdFusion MX: Deprecated the connectString, dbName, dbServer, dbtype, provider, and providerDSN attributes. They do not work, and might cause an error, in releases later than ColdFusion 5.

Attributes

Attribute	Req/Opt	Default	Description
dataSource	Optional		Data source; contains table.
clientInfo	Optional		Structure containing properties of the client to be set on the database connection.
tableName	Required		Table in which to insert form fields.ORACLE drivers: must be uppercase.Sybase driver: case-sensitive. Must be the same case used when table was created
fetchClientInfo	Optional	false	If set true, returns a struct with the key-value pair passed by the last query.
formFields	Optional	(all on form, except keys)	Comma-delimited list of form fields to insert. If not specified, all fields in the form are included. If a form field is not matched by a column name in the database, ColdFusion throws an error. The database table key field must be present in the form. It may be hidden.
password	Optional		Overrides password specified in ODBC setup.
tableOwner	Optional		For data sources that support table ownership (such as SQL Server, Oracle, and Sybase SQL Anywhere), use this field to specify the owner of the table.
tableQualifier	Optional		For data sources that support table qualifiers, use this field to specify qualifier for table. The purpose of table qualifiers varies among drivers. For SQL Server and Oracle, qualifier refers to name of database that contains table. For Intersolv dBASE driver, qualifier refers to directory where DBF files are located.
username	Optional		Overrides username specified in ODBC setup.

Example

<!--- This example shows how to use cfinsert instead of cfquery to put data in a 
datasource. ---> 
<!--- If form.POSTED exists, we insert new record, so begin cfinsert tag. ---> 
<cfif IsDefined ("form.posted")> 
<cfinsert dataSource = "cfdocexamples" 
tableName = "COMMENTS" 
formFields = "Email,FromUser,Subject,MessText,Posted"> 
<h3><I>Your record was added to the database.</i></h3> 
</cfif> 

<cfif IsDefined ("form.posted")> 
<cfif Server.OS.Name IS "Windows NT"> 
<cfinsert datasource="cfdocexamples" tablename="COMMENTS" 
formfields="EMail,FromUser,Subject,MessText,Posted"> 
<cfelse> 
<cfinsert datasource="cfdocexamples" tablename="COMMENTS" 
formfields="CommentID,EMail,FromUser,Subject,MessText,Posted"> 
</cfif> 
<h3><i>Your record was added to the database.</i></h3> </cfif> 

<!--- Use a query to show the existing state of the database. ---> 
<cfquery name = "GetComments" dataSource = "cfdocexamples"> 
SELECT 
CommentID, EMail, FromUser, Subject, CommtType, MessText, Posted, Processed 
FROM 
COMMENTS 
</cfquery> 

<html> 
<head></head> 
<h3>cfinsert Example</h3> 
<p>First, show a list of the comments in the cfdocexamples datasource. 
<!--- Show all the comments in the db. ---> 
<table> 
<tr> 
<td>From User</td><td>Subject</td><td>Comment Type</td> 
<td>Message</td><td>Date Posted</td> 
</tr> 
<cfoutput query = "GetComments"> 
<tr> 
<td valign = top><a href = "mailto:#Email#">#FromUser#</A></td> 
<td valign = top>#Subject#</td> 
<td valign = top>#CommtType#</td> 
<td valign = top><font size = "-2">#Left(MessText, 125)#</font></td> 
<td valign = top>#Posted#</td> 
</tr> 
</cfoutput> 
</table> 
<p>Next, well offer the opportunity to enter a comment: 
<!--- Make a form for input. ---> 
<form action = "cfinsert.cfm" method = "post"> 
<pre> 
Email: <input type = "Text" name = "email"> 
From: <input type = "Text" name = "fromUser"> 
Subject: <input type = "Text" name = "subject"> 
Message: <textarea name = "MessText" COLS = "40" ROWS = "6"></textarea> 
Date Posted: <cfoutput>#DateFormat(Now())#</cfoutput> 
<!--- Dynamically determine today's date. ---> 
<input type = "hidden" 
name = "posted" value = "<cfoutput>#Now()#</cfoutput>"> 
</pre> 
<input type = "Submit" 
name = "" value = "insert my comment"> 
</form>

Note:

The cfinsert tag internally uses parameterized queries.

Get help faster and easier

New user?

cfinsert

Description

Category

Syntax

See also

History

Attributes

Example

Get help faster and easier

Share this page

Ask the Community

Contact Us