<cfgrid> has been around for a long time. It started life as a Java applet, then in CFMX7 we added a Flash grid and XML generation, and in Scorpio we plan on adding an Ajax powered DHTML grid.
You'll be able to pass a query to the grid as you did previously, like this:
<cfquery datasource="myDSN" name="myQuery">
SELECT * FROM myTable
</cfquery>
...
<cfgrid name="staticgrid" query="myQuery" format="html" />
But where things get really interesting are when data is retrieved asynchronously (in much the same way as in the auto-suggest example I mentioned earlier this week). Look at this example:
<cfgrid name="asynchgrid"
format="html"
pageSize="10"
bind="cfc:data.getData({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection})" />
The bind attribute specifies the CFC and method to be invoked, and the current page, page size, and sort information get passed to the CFC method which then returns the appropriate query data. And yes, this does mean that paging is supported, the grid contains paging controls and when you move through pages (or resort columns) the CFC method is asynchronously invoked and the grid is updated accordingly.
And of course there is more, for example:
<cfgrid name="asynchgrid"
format="html"
pageSize="10"
bind="cfc:data.getData({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection})"
stripeRows="true"
stripeRowColor="##e0e0e0">
<cfgridcolumn name="firstName" header="First Name">
<cfgridcolumn name="lastName" header="Last Name">
<cfgridcolumn name="phone" header="Phone">
</cfgrid>
Of course, this is all subject to change. :-)
There are no comments for this entry.
[Add Comment]