User Guide

cfgrid 195
Using the href attribute
When specifying a URL with grid items using the
href attribute, the selectMode attribute value
determines whether the appended key value is limited to one grid item or extends to a grid
column or row. When a user clicks a linked grid item, a
cfgridkey variable is appended to the
URL, in this form:
http://myserver.com?cfgridkey=selection
If the appendKey attribute is set to no, no grid values are appended to the URL.
The value of selection is determined by the value of the
selectMode and attribute:
• If you specify a hrefKey attribute, selection is the field value of the column specified by the
attribute. Otherwise, it is one of the following:
• If selectMode="Single", selection is the value of the column clicked.
• If selectMode="Row", selection is a comma-delimited list of column values in the clicked row,
beginning with the value of the first cell in the row.
• If selectMode="Column", selection is a comma-delimited list of row values in the clicked
column, beginning with the value of the first cell in the column.
Example
The following example creates a Flash form that displays a set of available courses from the
CourseList table in the cfdocexamples database. For more complex examples that use the
cfgrid
tag, see
cfgridcolumn, cfgridrow, and cfgridupdate.
<!--- Query the database to fill up the grid. --->
<cfquery name = "GetCourses" dataSource = "cfdocexamples">
SELECT Course_ID, Dept_ID, CorNumber,
CorName, CorLevel
FROM CourseList
ORDER by Dept_ID ASC, CorNumber ASC
</cfquery>
<h3>cfgrid Example</h3>
<I>Currently available courses</i>
<!--- cfgrid must be inside a cfform tag. --->
<cfform>
<cfgrid name = "FirstGrid" format="Flash"
height="320" width="580"
font="Tahoma" fontsize="12"
query = "GetCourses">
</cfgrid>
</cfform>