356
Chapter 2: ColdFusion Tags
Example
<!--- This example shows the use of CFUPDATE to change
records in a datasource. --->
<!--- if course_ID has been passed to this form, then
perform the update on that record in the datasource --->
<cfif IsDefined("form.Course_ID")>
<!--- check that course_id is numeric --->
<cfif Not IsNumeric(form.Course_ID)>
<cfabort>
</cfif>
<!--- Now, do the update --->
<cfupdate datasource="cfsnippets"
tablename="Courses"
formfields="Course_ID,Number,Descript">
</cfif>
<!--- Perform a query to reflect any updated information if Course_ID is passed
through a url, we are selecting a record to update ... select only that
record with the WHERE clause. --->
<cfquery name="GetCourseInfo" DATASOURCE="cfsnippets">
SELECT Course_Number, Course_ID, Descript
FROM Courses
<cfif IsDefined("url.Course_ID")>
WHERE Course_ID = #Trim(url.Course_ID)#
</cfif>
ORDER by Course_Number
</cfquery>
<html>
<head>
<title>CFUPDATE Example</title>
<cfset css_path = "../../css">
<cfinclude template="../../resource/include/mm_browsersniff.cfm">
</head>
<body>
<H3>CFUPDATE Example</H3>
<!--- If we are updating a record, don't show the entire list. --->
<cfif IsDefined("url.Course_ID")>
<form method="post" action="index.cfm">
<H3>You can alter the contents of this record, and then click "Update"
to use CFUPDATE and alter the database</H3>
<P>Course Number <INPUT TYPE="Text" name="Number"
value="<cfoutput>#Trim(GetCourseInfo.Course_Number)#</cfoutput>">
<P>Course Description<BR>
<textarea name="Descript" cols="40" rows="5">
<cfoutput>#Trim(GetCourseInfo.Descript)#</cfoutput>
</textarea><br>
<input type="Hidden" NAME="Course_ID"
value="<cfoutput>#Trim(GetCourseInfo.Course_ID)#</cfoutput>">
<p><input type="Submit" value="Click to Update">
</form>
<cfelse>
<!--- Show the entire record set in CFTABLE form --->
<cftable query="GetCourseInfo" htmltable colheaders>
<cfcol text="<a href='index.cfm?Course_ID=#Trim(Course_ID)#'>Edit Me</a>"
width=10 header="Edit<br>this Entry">
<cfcol text="#Trim(Course_Number)#" WIDTH="4" HEADER="Course Number">
<cfcol text="#Trim(Descript)#" WIDTH=100 HEADER="Course Description">
Summary of Contents for COLDFUSION MX 61-CFML
Page 1: ...CFML Reference...
Page 16: ...16 Contents...
Page 32: ...32 Chapter 1 Reserved Words and Variables...
Page 160: ...160 Chapter 2 ColdFusion Tags html...
Page 245: ...cfmail 245 p input type Submit name form...
Page 299: ...cfreturn 299 cffunction cfcomponent...
Page 354: ...354 Chapter 2 ColdFusion Tags cfoutput cfcatch cftry...
Page 357: ...cfupdate 357 cftable cfif body html...
Page 362: ...362 Chapter 2 ColdFusion Tags cfloop MyDoc cfxml cfdump var MyDoc...
Page 397: ...ASin 397 br input type Text name sinNum size 25 p input type Submit name input type RESET form...
Page 486: ...486 Chapter 3 ColdFusion Functions input type Submit NAME form...
Page 492: ...492 Chapter 3 ColdFusion Functions b http_content x content b cfoutput...
Page 504: ...504 Chapter 3 ColdFusion Functions tr table form...
Page 519: ...IIf 519 cfoutput b...
Page 534: ...534 Chapter 3 ColdFusion Functions input type Submit name form...
Page 542: ...542 Chapter 3 ColdFusion Functions cfif cfif...
Page 547: ...IsStruct 547 cfcase cfswitch...
Page 550: ...550 Chapter 3 ColdFusion Functions IsWDDX returns IsWDDX packet br cfoutput...
Page 559: ...Left 559 option value 9 9 select input type Submit name Remove characters form...
Page 620: ...620 Chapter 3 ColdFusion Functions cfoutput cfloop...
Page 681: ...SetVariable 681 p Your variable varName p The value of varName is varNameValue cfoutput cfif...
Page 724: ...724 Chapter 3 ColdFusion Functions cfelse h3 Conversion error h3 cfif...
Page 743: ...XmlNew 743 cfscript cfdump var MyDoc...
Page 786: ...786 Chapter 5 ColdFusion Java CFX Reference...
Page 798: ...798 Chapter 6 WDDX JavaScript Objects...
Page 806: ...806 Chapter 7 ColdFusion ActionScript Functions...