User Guide

136 Developing Web Applications with ColdFusion
Populating a grid from a query
To populate a grid from a query:
1. Open a new file named grid1.cfm in Studio.
2. Edit the file so that it appears as follows:
<CFQUERY NAME="empdata" DATASOURCE="CompanyInfo">
SELECT * FROM Employees
</CFQUERY>
<CFFORM NAME="Form1" ACTION="submit.cfm" METHOD="Post">
<CFGRID NAME="employee_grid" QUERY="empdata"
SELECTMODE="single">
<CFGRIDCOLUMN NAME="Employee_ID">
<CFGRIDCOLUMN NAME="LastName">
<CFGRIDCOLUMN NAME="Department_ID">
</CFGRID>
<BR><INPUT TYPE="Submit" VALUE="Submit">
</CFFORM>
Note Use the CFGRIDCOLUMN DISPLAY="No" attribute to hide columns
you want to retrieve from a data source but not expose to an end
user.
3. Save the file and view it in your browser.