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 to title to print once if the releaseid is the same.

Any ideas?

[paross1 · Accepted solution]

Order by Title and Releaseid in your query, then use the GROUP attribute in CFOUTPUT to group by Title.

Phil