MACROMEDIA COLDFUSION MX 61-DEVELOPING COLDFUSION MX, Develop Manual

Page: 599 / 860

Creating data grids with cfgrid 599
Creating an editable grid
You can build grids to allow users to edit data within them. Users can edit individual cell data, as
well as insert, update, or delete rows. To enable grid editing, you specify
selectmode="edit"
in
the
cfgrid
tag.
To let users add or delete grid rows, you also have to set the
insert
or
delete
attributes in
cfgrid
to Yes. Setting
insert
or
delete
to Yes causes the
cfgrid
tag to display insert and delete
buttons as part of the grid, as the following figure shows:
You can use a grid in two ways to make changes to your ColdFusion data sources:
•
Create a page to which you pass the
cfgrid
form variables. In that page, perform
cfquery
operations to update data source records based on the form values returned by
cfgrid
.
•
Pass grid edits to a page that includes the
cfgridupdate
tag, which automatically extracts the
form variable values and passes that data directly to the data source.
Using
cfquery
gives you complete control over interactions with your data source. The
cfgridupdate
tag provides a much simpler interface for operations that do not require the same
level of control.
Controlling cell contents
The
value
,
valuesDisplay,
and
valuesDelimiter
attributes of the
cfgridcolumn
tag let you
control the data that a user can enter into a
cfgrid
cell in the following ways:
•
By default, a cell is not editable. Use the
cfgrid
attribute
selectmode="edit"
to edit cell
contents.
•
Use the
type
attribute to control sorting order, to make the fields check boxes, or to display an
image.
•
Use the
values
attribute to specify a drop-down list of values from which the user can chose.
You can use the
valuesDisplay
attribute to provide a list of items to display that differs from
the actual values that you enter in the database. You can use the
valuesDelimiter
attribute to
specify the separator between values in the
values valuesDisplay
lists.
•
While
cfgrid
does not have a
validate
attribute, it does have an
onvalidate
attribute that
lets you specify a JavaScript function to perform validation.
For more information on controlling the cell contents, see the attribute descriptions for
cfgridcolumn
in CFML Reference .