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

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

    kt03

      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----

      </cfoutput>

       

      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">

                  <cfgrid

                      name="gridOutages"

                      format="HTML"

                      query="myquery">

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

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

      </cfgrid>

              </cfform>

       

      Thanks