Hi nic, Thanks for the reply. Here is the query:
<cfquery name="caller.sel_FriendStoryActivity" datasource="#request.db#"> SELECT Story.storyID, Story.title, Story.dateAdded FROM Story ORDER BY Story.dateAdded DESC </cfquery> The tricky part here is in the output, see below, I'm trying to add headers per days with results from the query. January 12 ---- result results result results January 11 - HEADER would not appear, no results January 10 ---- result results result results And so on. Take a look at facebook for an example the mini-feed on the profile. Have you ever done this or have ideas on how to achieve? Thanks N --- Nicholas M Tunney <[EMAIL PROTECTED]> wrote: > 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:296494 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
