order by 2 things?

[davellaman]

Ok, I want my output to look similiar to this:

------------------------------------------------------------
May 16th 2005,

Animals

-download animal clip 1
-download animal clip 2

automobile

-download car clip 1

random

-download random clip 1

May 15th 2005,

Animals

-download animal clip 1
-download animal clip 2

automobile

-download car clip 1

random

-download random clip 1

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

I am having a problem looping out query. I loop it, but the date is displayed
everytime it is looped and i was thinking about putting it in a cfif but i
wasnt sure what value to check it against. also, they are never organised by
category, they simply just show each value one by one no matter what
category...this is currently how it is displaying:

ex.

May 16th
animal
-download clip 1

May 16th
animal
-download clip2


if anyone has any idea how to do this i would greatly appreciate it.


thank you

[OldCFer]

I think what you're after is grouped cfoutput, which has to be grouped by the
query sort order

Select * from the table order by TheDate

<cfoutput query="queryname" group="TheDate">
#TheDate#
<cfoutput> #Category# #OtherFields#
</cfoutput>
</cfoutput>