User Guide
cfgridrow 167
<cfif isdefined("form.gridentered") is true>
<cfgridupdate grid="FirstGrid" datasource="cfsnippets"
tablename="CourseList" keyonly="Yes">
</cfif>
<!--- query the database to fill up the grid --->
<cfquery name="GetCourses" datasource="cfsnippets">
select Course_ID, Dept_ID, CorNumber, CorName, CorLevel, CorDesc
FROM CourseList
ORDER by Dept_ID ASC, CorNumber ASC
</cfquery>
<html>
<head>
<title>cfgridrow example</title>
</head>
<body>
<h3>cfgridrow Example</h3>
<I>Try adding a course to the database, and then deleting it.</I>
<!--- call the cfform to allow us to use cfgrid controls --->
<cfform action="cfgridrow.cfm">
<!--- When inserting rows while running under UNIX, you must also specify
a value for Course_ID --->
<!--- cfgridcolumn tags are used to change the parameters involved in
displaying each data field in the table--->
<cfgrid name="FirstGrid" width="600" query="GetCourses" insert="yes"
delete="yes" sort="yes" font="tahoma" bold="no" italic="no"
appendkey="no" highlighthref="no" griddataalign="left" gridlines="yes"
rowheaders="yes" rowheaderalign="left" rowheaderitalic="no"
rowheaderbold="no" colheaders="yes" colheaderalign="left"
colheaderitalic="no" colheaderbold="no" selectcolor="red"
selectmode="edit" picturebar="no" insertbutton="to insert"
deletebutton="to delete" sortascendingbutton="sort asc"
sortdescendingbutton="sort desc">
<cfgridcolumn name="Dept_ID" header="Department" headeralign="left"
dataalign="left" bold="yes" italic="no" select="yes"
display="yes" headerbold="no" headeritalic="yes">
<cfgridcolumn name="CorNumber" header="Course ##" headeralign="left"
dataalign="left" bold="no" italic="no" select="yes"
display="yes" headerbold="no" headeritalic="no">
<cfgridcolumn name="CorName" header="Name" headeralign="left"
dataalign="left" font="times" bold="no" italic="no" select="yes"
display="yes" headerbold="no" headeritalic="no">
<cfgridcolumn name="CorLevel" header="Level" headeralign="left"
dataalign="left" bold="no" italic="no" select="yes" display="yes"
headerbold="no" headeritalic="no">
<cfgridcolumn name="CorDesc" header="Description" headeralign="left"
dataalign="left" bold="no" italic="no" select="yes" display="yes"
headerbold="no" headeritalic="no">
<cfgridcolumn name="Course_ID" header="Course ID (Do Not Specify on NT)"
dataalign="left" bold="no" italic="no" select="yes" display="yes"
headerbold="no" headeritalic="no">
</cfgrid>
<!--- send the grid back to this page, where we determine whether anything has
changed, and thus whether to run the cfgridupdate --->
<input type="Submit" name="submit" value="Apply Changes">
<input type="hidden" name="gridEntered" value="yes">
<h3>Example Two</h3>