10 Replies Latest reply on Sep 20, 2007 3:59 AM by Newsgroup_User

    SQL / Coldfusion display question

    Level 7
      I am not sure if this can be done in one SQL pull / Coldfusion display or
      not. If a table has an employee name and department, can you list the people
      using the department in the title and listing the people below it.

      i.e.)

      Table: Employees

      employeeName department
      ---------------- -------------
      Steve Smith Admissions
      Susan Day Admissions
      Bob Turner HR
      Billy West HR
      Tom Jones Accounting


      And output this to a page:

      <b>Admissions</b>
      Steve Smith
      Susan Day

      <b>HR</b>
      Bob Turner
      Billy West

      <b>Accounting</b>
      Tom Jones

      Thanks.
      --
      Wally Kolcz
      MyNextPet.org
      Founder / Developer
      586.871.4126