User Guide
238 CFML Language Reference
--->
<CFQUERY NAME="GetCourseInfo" DATASOURCE="cfsnippets">
SELECT Number, Course_ID, Descript
FROM Courses
<CFIF IsDefined("url.course_ID") is True>
WHERE Course_ID = #url.course_ID#
</CFIF>
ORDER by Number
</CFQUERY>
<HTML>
<HEAD>
<TITLE>CFUPDATE Example</TITLE>
</HEAD>
<BODY bgcolor=silver>
<H3>CFUPDATE Example</H3>
<!--- if we are updating a record, don’t show
the entire list --->
<CFIF NOT IsDefined("url.course_ID")>
<P><H3><a href="cfupdate.cfm">Show Entire List</A></H3>
<FORM METHOD="POST" ACTION="cfupdate.cfm">
<H3>You can alter the contents of this
record, and then click "submit" to use
CFUPDATE and alter the database</H3>
<P>Course Number <INPUT TYPE="Text" NAME="number"
VALUE="<CFOUTPUT>#GetCourseInfo.number#</CFOUTPUT>">
<P>Course Description<BR>
<TEXTAREA NAME="Descript" COLS="40" ROWS="5">
<CFOUTPUT>#GetCourseInfo.Descript#</CFOUTPUT>
</TEXTAREA>
<INPUT TYPE="Hidden" NAME="course_id"
VALUE="<CFOUTPUT>#GetCourseInfo.Course_ID#</CFOUTPUT>">
<P><INPUT TYPE="Submit" NAME="">
</FORM>
<CFELSE>
<!--- Show the entire record set in CFTABLE form --->
<CFTABLE QUERY="GetCourseInfo" HTMLTABLE>
<CFCOL TEXT="<a href=’cfupdate.cfm?course_ID=#course_ID#’>Edit Me</a>"
WIDTH=10 HEADER="Edit<br>this Entry">
<CFCOL TEXT="#Number#" WIDTH="4" HEADER="Course Number">
<CFCOL TEXT="#Descript#" WIDTH=100 HEADER="Course Description">
</CFTABLE>
</CFIF>
</BODY>
</HTML>