User Guide

140 Developing Web Applications with ColdFusion
</CFQUERY>
<CFELSEIF form.employee_grid.rowstatus.action[Counter] IS "U">
<CFQUERY NAME="UpdateExistingEmployee"
DATASOURCE="CompanyInfo">
UPDATE Employees
SET
LastName=’#form.employee_grid.LastName[Counter]#’,
Department_ID=#form.employee_grid.Department_ID[Counter]#
WHERE
Employee_ID=#form.employee_grid.original.Employee_ID[Counter]#
</CFQUERY>
<CFELSEIF form.employee_grid.rowstatus.action[Counter] IS "I">
<CFQUERY NAME="InsertNewEmployee"
DATASOURCE="CompanyInfo">
INSERT into Employees
(Employee_ID, LastName, Department_ID)
VALUES (#form.employee_grid.Employee_ID[Counter]#,
’#form.employee_grid.LastName[Counter]#’,
#form.employee_grid.Department_ID[Counter]#)
</CFQUERY>
</CFIF>
</CFLOOP>
</CFIF>
</BODY>
</HTML>
3. Save the file as handle_grid.cfm.
4. View
grid2.cfm in your browser, make changes to the grid, and then submit them.
To update the data source with CFQUERY
1. Open a new file in Studio.
2. Modify the file so that it appears as follows:
<CFGRIDUPDATE GRID="Employee_grid"
DATASOURCE="CompanyInfo"
TABLENAME="Employees"
KEYONLY="NO">
3. Save the file as handle_grid.cfm.
4. View
grid2.cfm in your browser, make changes to the grid, and then submit them.