| CFUPDATE | |
| Description
Updates records in a data source from data in a ColdFusion form or form Scope. |
|
| Category
Database manipulation tags | |
Syntax<cfupdate dataSource = "ds_name" tableName = "table_name" tableOwner = "name" tableQualifier = "qualifier" username = "username" password = "password" formFields = "field_names"> |
|
| See also
cfinsert, cfprocparam, cfprocresult, cfquery, cfqueryparam, cfstoredproc, cftransaction; "Creating an update action page with cfupdate" in Chapter 21, "Updating Your Database," in ColdFusion MX Developer's Guide |
|
| History
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.
|
|
Example<!--- This example allows you to update a person's telephone number in the
employee table. --->
<cfif isDefined("form.phone")>
<cfupdate datasource="cfdocexamples" tablename="Employees">
</cfif>
<cfquery name="empTable" datasource="cfdocexamples">
select * from employees
</cfquery>
<!--- This code shows the contents of the employee table and allows you to
choose a row for updating. --->
<table border="1">
<cfoutput query="empTable">
<tr>
<td>#firstName#</td>
<td>#lastName#</td>
<td>#phone#</td>
<td><a href="cfupdate.cfm?id=#emp_id#">Edit</a></td>
</tr>
</cfoutput>
</table>
<cfif isDefined("url.id")>
<cfquery name="phoneQuery" datasource="cfdocexamples">
select * from employees where emp_id=#url.id#
</cfquery>
<!--- This code displays the row to edit for update. --->
<cfoutput query="phoneQuery">
<form action="cfupdate.cfm" method="post">
#phoneQuery.firstName# #phoneQuery.lastName#
<input name="phone" type="text" value="#phone#" size="12">
<input type="submit" value="Update">
<input name="emp_id" type="hidden" value="#emp_id#">
<!--- The emp_id is passed as a hidden field to be used as a primary key in
the CFUPDATE. --->
</form>
</cfoutput>
</cfif>
|
|