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
Sebastiaan 's Gravatar Akbarsait, Unfortunately the collapsible thing only works for non-dynamic grids, so not for grids being populated via a Bind. Otherwise it would have been a great feature.
# Posted By Sebastiaan | 9/12/11 9:54 AM
jack's Gravatar Hi Akbarsait, I need to create a purchase order
that gives the user the ability to add multiple items to it, The user enters the data, clicks on the "Add Another" Button, or "enter"
, and a new row is added to the form and the previous data entered is kept intact, how can do this?
# Posted By jack | 1/13/12 11:22 PM



About Me

ColdFusion Enthusiast, Web Developer and Consultant, Travel, Technology, Android, Xbox, Movies and Music Fan boy. more
     Twitter Akbarsait's Blog RSS Feed Facebook Twitter Facebook


  Chennai Adobe ColdFusion User Group    Snagit - Screen Capture Software



  


Archives

Aggregated by

 Aggregated by ColdFusionBloggers
 Aggregated by MXNA
 Aggregated by CFBLOGS.COM