MACROMEDIA COLDFUSION 4.5-DEVELOPING WEB Applications - page 166
of
380
140
Developing Web Applications with ColdFusion
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]#
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]#)