What does the query look like? Wouldn't it already only be returning only dates with results? Post the query and I'm sure we can help.
-Nic Nate Willard wrote: > I've been struggling with a desired output. I'm eager > to hear everyone's thoughts and ideas on how to > efficiently achieve my goal. Thanks... > > I have a query that returns the following data: > TITLE - dateTime > > The results span past a month. I would like a way to > output the results as follows > > January 9 > ---- > result results > result results > > January 8 > ---- > result results > result results > result results > result results > > January 1 > ---- > result results > > December 22 > ---- > result results > result results > result results > result results > > > Where the MONTH - Day header would only appear if > records exist for that date > > Ideas? Thanks > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296488 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
