Akbarsait's Blog

ColdFusion 9: New Attributes in CFGrid

ColdFusion 9 introduces 4 new attributes in CFGrid tag. These attributes are great addition to CFGrid which allows us to expand or collapse the entire grid, we can group the rows in CFGrid by mentioning the group column name which generates a collapsible group of rows in the grid, we can insert a new row in the Grid and we can give a title to the entire CFGrid.


<cfquery name="qGetBooks" datasource="cfbookclub">
   select   title, genre
   from   books
</cfquery>

<cfform name="gridform">
   
   <cfgrid
      name="BooksGrid"
      format="HTML"
      query="qGetBooks"
      title="CF 9 CFGrid Enhancements"
      collapsible="true"
      groupfield="genre"
      selectmode="edit"
      insert="true"
      insertbutton="Insert Book"
      width="250">

      
         <cfgridcolumn name="title" header="Book Title" />
         <cfgridcolumn name="genre" header="Genre" />
   </cfgrid>

</cfform>

All these new attributes are available only for HTML type grids. In the above code I have defined the collapsible as true and assigned a value for the title attribute. The insert and insertbutton attributes will take effect only when the selectmode is true. On clicking the Insert Book button at the bottom of the grid will introduce a new row at the end and user can add a new record.

Here are the screen-shots of the above code output.
CFGrid with Title, Group, Collapsible

CFGrid with New Record Insertion

CFGrid with Collapsible Feature



Steve's Gravatar Hiya Akbarsait!

I see that your article is form last year but I have been looking around everywhere and thought I would drop you a line to ask you a question.'

I have been using cfgrid and I love the layouts especially some of the newer features you point out above.

I was wondering if you had any knowledge of how to make the grouped rows, using the groupfield attribute, show up as collapsed by default. Right now the default behavior is for all of the groups to be expanded. If I could have them collapsed by default it would help my layout tremendously.

If you have any info it would be greatly appreciated. If not thanks anyway and have a good one.

Steve
# Posted By Steve | 7/16/10 10:21 AM

About Me

ColdFusion Enthusiast, Web Developer and Consultant in Chennai, Mobile & Technology freak. more
     Twitter Akbarsait's Blog RSS Feed Facebook Twitter Facebook


  Chennai Adobe ColdFusion User Group    Snagit - Screen Capture Software