Coldfusion Sql查询分组输出

时间:2021-11-07 03:09:39

<cfoutput query="myQry" group="date">
  #date#
  <cfoutput>
    #detail#
  </cfoutput>
</cfoutput>
<cfoutput query="myQry" group="date">
  <cfoutput group="category">
    <cfoutput group="description">
      #date# #category# #description#
      <cfoutput>
        #detail#
      </cfoutput>
    </cfoutput>
  </cfoutput>
</cfoutput>

<cfloop
  query = "query name"
  startRow = "row number"
  endRow = "row number"
  group = "Query column">
</cfloop>