MACROMEDIA COLDFUSION MX 61-DEVELOPING COLDFUSION MX, Develop Manual

Page: 601 / 860

Creating data grids with cfgrid 601
Editing data in cfgrid
To enable grid editing, specify the
selectmode="edit"
attribute. When enabled, a user can edit
cell data and insert or delete grid rows. When the user submits a
cfform
tag containing a
cfgrid
tag, data about changes to grid cells gets returned in the one-dimensional arrays described in the
preceding section. You can reference these arrays as you would any other ColdFusion array.
Note: For code brevity, the following example handles only three of the fields in the Employee table.
A more realistic example would include, at a minimum, all seven table fields. You might also consider
hiding the contents of the Emp_ID column and automatically generating its value for new records, and
displaying the Department name, from the Departmt table, in place of the Department ID.
To make the grid editable:
1
Create a new ColdFusion page with the following contents:
<cfquery name="empdata" datasource="CompanyInfo">
SELECT * FROM Employee
</cfquery>
<cfform name="GridForm"
action="handle_grid.cfm">
<cfgrid name="employee_grid"
height=425
width=300
vspace=10
selectmode="edit"
query="empdata"
insert="Yes"
delete="Yes">
<cfgridcolumn name="Emp_ID"
header="Emp ID"
width=50
headeralign="center"
headerbold="Yes"
select="No">
<cfgridcolumn name="LastName"
header="Last Name"
width=100
headeralign="center"
headerbold="Yes">
<cfgridcolumn name="Dept_ID"
header="Dept"
width=35
headeralign="center"
headerbold="Yes">
</cfgrid>
<br>
<input type="Submit" value="Submit">
</cfform>
2
Save the file as grid2.cfm and view it in your browser.