2 Replies Latest reply on May 29, 2009 7:27 AM by Lumpia

    Grouping database column output with separator

    Lumpia Level 1

      Using Coldfusion MX 7 with SQL Server 2005.  I'm outputting the results from SQL Server in a table in which I want to group one of the columns with a separator between the like values, like so:

       

      1  Bobby

      1  Thomas

      1  Jason

      -----------------

      2  Harold

      2  George

      ----------------

      5  Mark

      5  Alex

      5  Wes

       

      I can group them fine, but my output normally just puts the separator at the end of the total results like so:

       

      1  Bobby

      1  Thomas

      1  Jason

      2  Harold

      2  George

      5  Mark

      5  Alex

      5  Wes

      ----------------

       

      I know this is a simple solution, but I can't wrap my thoughts around it.