MACROMEDIA COLFUSION MX 7 - INSTALLING AND USING COLDFUSION MX, Reference

Page: 195 / 1108

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>