cfgrid and <cfoutput query="myQuery" group="GROUP">
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
