MACROMEDIA COLDFUSION MX 61-CFML, Reference

Page: 156 / 806

156 Chapter 2: ColdFusion Tags
Usage
You can populate a
cfgrid
with data from a
cfquery
. If you do not specify any
cfgridcolumn
entries, ColdFusion generates a default set of columns, which includes each column in the query.
A default header for each column is created by replacing hyphen or underscore characters in the
table column name with spaces. The first character, and any character after a space, are changed to
uppercase; all other characters are lowercase.
This tag requires the client to download a Java applet; therefore, this tag might be slightly slower
than using an HTML form element or the
cfinput
tag to get the same information.
For this tag to work properly. the browser must be JavaScript-enabled.
This tag requires an end tag.
How data is returned from cfgrid
This tag returns data by setting form variables in the data submitted to the form's action page, as
an HTML form control does. Because the data can vary, depending on the tag’s
SelectMode
attribute value, the form variables that are returned also vary depending on this value.
In general, the data returned falls into one of these categories:
•
Simple data, returned from simple select operations
•
Complex data, returned from insert, update and delete operations
selectMode Optional Browse Selection mode for items in grid control.
•
Edit: user can edit grid data. Selecting a cell
opens the editor for the cell type.
•
Single: user selections are limited to selected
cell.
• Row: user selections automatically extend to
the row that contains selected cell.
•
Column: user selections automatically extend
to column that contains selected cell.
•
Browse: user can only browse grid data
maxRows Optional Maximum number of rows to display in grid.
notSupported Optional (See
Description) Text to display if page that contains Java
applet-based cfform control is opened by a
browser that does not support Java or has Java
support disabled.
Default: "<b> Browser must support Java to view
ColdFusion Java Applets</b>"
pictureBar Optional No
•
Yes: images for Insert, Delete, Sort buttons
•
No
insertButton Optional Insert Insert button. Takes effect only if
selectmode="edit"
.
deleteButton Optional Delete Text of Delete button text. Takes effect only if
selectmode="edit"
.
sortAscendingButton Optional A -> Z Sort button text
sortDescendingButton Optional Z -> A Sort button text
Attribute Req/Opt Default Description