1 Reply Latest reply on May 3, 2006 3:16 PM by imstillatwork

    Altering Displayed Data

    hlywd7
      I have a query that returns the following data:

      Meta_subject | Releaseid | Title
      1000 381 Blah
      2275 381 Blah
      1000 291 Foo
      2585 291 Foo

      How do I get it so that the title will only print once when I display the title. I tried using an <cfif> statement, but it didn't work. I only want the title to appear once if the releaseid is the same

      Any ideas?
        • 1. Re: Altering Displayed Data
          imstillatwork
          Meta_subject | Releaseid | Title
          1000 381 Blah
          2275 381 Blah
          1000 291 Foo
          2585 291 Foo

          ok

          <cfoutput query="yourQuery" group="title">
          <h3>#title#</h3>
          <cfoutput>
          #Meta_subject# #Releaseid #<br/>
          </cfoutput>
          </cfoutput>

          will output
          <h3>Blah</h3>
          1000 381<br/>
          2275 381<br/>
          <h3>Foo</h3>
          1000 291<br/>
          2585 291<br/>

          Something like that?