MACROMEDIA COLDFUSION MX 61-DEVELOPING COLDFUSION MX, Руководство по разработке

Страница: 597 / 860

Creating data grids with cfgrid 597
To populate a grid from a query:
1
Create a new ColdFusion page named grid1.cfm with the following contents:
<cfquery name="empdata" datasource="CompanyInfo">
SELECT * FROM Employee
</cfquery>
<cfform name="Form1" action="submit.cfm" >
<cfgrid name="employee_grid" query="empdata"
selectmode="single">
<cfgridcolumn name="Emp_ID">
<cfgridcolumn name="LastName">
<cfgridcolumn name="Dept_ID">
</cfgrid>
<br><input type="Submit" value="Submit">
</cfform>
Note: Use the cfgridcolumn
display="No"
attribute to hide columns that you want to include in
the grid but not expose to an end user. You typically use this attribute to include columns such as
the table’s primary key column in the results returned by
cfgrid .
2
Save the file and view it in your browser. The following figure shows the output of this code:
Editing a grid cell Double-click the cell. You must press Return when you finish entering
the data.
Deleting a row Click any cell in the row and click the Delete button.
Inserting a row Click the Insert button. An empty row appears at the bottom of the
grid. To enter a value in each cell, double-click the cell, enter the value,
and click Return.
Action Procedure