Recordset Loop 1

[highv0ltage]

Hello, I'm having a bit of issues. I'm running a query and then outputing it with the date and title. That part I have working. But sometimes there are more than one item per date and I would like to only list the date once instead of on each record. Here's an example:

05/01/06

-Todays News

04/27/06

-CEO Announcements
-Today's Schedule

04/26/06

- May is Fitness Month

Any help would be appreciated. Thanks.

 

[imstillatwork]

I though I just posted info about this in a recent thread?

anyways:

use cfoutput with the group attribute.

<cfoutput query="whatever" group="datefield">
<h3>#datefield#</h3>
<cfoutput>
- #newstitle#<br/>
</cfoutput>
</cfoutput>

double check that your query is sorted by the date field, or you might have dates repeat.

Kevin

http://www.lot-o-nothin.com/cfml/

 

[highv0ltage]

Thanks for replying imstillatwork. This doesn't seem to work correctly though. It stops after one record even though I know there should be more. I don't know if my query is incorrect or what. Any other ideas?

 

[imstillatwork]

<cfoutput query="whatever" group="datefield">
<h3>#datefield#</h3>
<cfoutput>
- #newstitle#<br/>
</cfoutput>
</cfoutput>

Is correct, with adjustments for your field names of course

this would assum data like

datefield | newstitle
----------------------
5/4/06 | News Title 1
5/4/06 | News Title 2
5/3/06 | News 3
5/3/06 | News 4
5/2/06 | News 5

wich would output like

<h3>5/4/06</h3>
News Title 1<br/>
Mews Title 2<br/>
<h3>5/3/06</h3>
News 3<br/>
News 4<br/>
<h3>5/2/06</h3>
News 5


So make sure that your datefield is date only, not time also, or the time part would make each date different, and not group together.





Kevin

http://www.lot-o-nothin.com/cfml/

 

[imstillatwork]

paste your query and code please!


Kevin

http://www.lot-o-nothin.com/cfml/

 

[highv0ltage]

That's how I have it. Here's a sample without the group and date formatting:

{ts '2006-05-04 00:00:00'}
ODTA Meeting on 10 May
{ts '2006-05-04 00:00:00'}
Senior Leader Announcement
{ts '2006-05-04 00:00:00'}
101 Critical Days of Summer Campaign Safety Fair
{ts '2006-05-04 00:00:00'}
E-Clippings

Here it is with the group:

{ts '2006-05-04 00:00:00'}
ODTA Meeting on 10 May

The dates are the same. There is no time, but the group isn't working.

 

[highv0ltage]

here's the Query and code:

<cfquery name="getDailyNews" datasource="ICBMPROD">
select * from daily_main
where view_date > to_date('#dateformat(DateDiff('d','1',now()))#','dd-mon-yy')
and active = 1
order by view_date desc, important desc
</cfquery>

<ul>
<cfoutput query="getDailyNews" group="view_date">
<li>
#view_date#
</li>
<li>
<a href="/updatecontent/bin/<cfif getDailyNews.html eq 0>daily<cfelse>html</cfif>/#file_location#" <cfif getDailyNews.html eq 1>target="_blank"</cfif>>
#link_name# </a>
</li>
</cfoutput>
</ul>

 

[r937]

you are missing the nested CFOUTPUT

r937.com | rudy.ca

 

[imstillatwork]

your missing the nested output that works inside the grouped output. check the example closely. post back how it goes!

Kevin

http://www.lot-o-nothin.com/cfml/

 

[highv0ltage]

Doh! Good call. I got it now. Thanks for the help.

 

[imstillatwork]

r937: down to the minute! You thought I was going to get that one wrong?

Kevin

http://www.lot-o-nothin.com/cfml/

 

[r937]

no, of course not, but people gots to eat, sleep, and other functions, and i was just helping out while you were gone ;-)

r937.com | rudy.ca

 

[imstillatwork]

ah, so ya got my back... ok, I'm off to eat and sleep and... well I think highv0ltage got it sorted now.

Kevin

http://www.lot-o-nothin.com/cfml/