2 Replies Latest reply on May 16, 2012 1:12 PM by ion

    cfgrid and <cfoutput query="myQuery" group="GROUP">

    kt03 Level 1

      i want to display the records in the cfgrid with cfgridcolumn but wonder if it is possible to use the group by query by any ways?


      <cfoutput query="myquery"  group="column">

      .....display records here----



      instead of above cfoutput query, I wan to display them in the cfgrid below but how can i groupd by the ID field here?

      <cfform name="frmGrid" id="frmGrid">





                      <cfgridcolumn name="id" header="Message ID" width="50" href="entry_form.cfm?action=edit" hrefkey="id" />

                      <cfgridcolumn name="title" header="Title" width="100" />