lemme see your CQUERY code, and an output of your results please -----Original Message----- From: Ang�l Stewart [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 07, 2001 1:16 PM To: CF-Talk Subject: Simple Way To Output Month/Year as Header, and corresponding info below, Grouped. Hi there! I am trying to do this: March 2001 07-Mar-2001 (console)10:41 AM Former Sega Employees Form Online Gaming Network -Kayode (console)07:03 AM Analyst's Outlook On MS Xbox: MS Will Lose US$2Billion-Gel (Tech)03:44 AM Windows XP's Copyprotection May Disadvantage Developing Countries.-Gel 05-Mar-2001 (Tech) 09:44 PM Warning! New PC Virus:My Naked Wife... -Gel (Tech) 02:44 AM Intel Cuts Prices Again -Gel ..... ..... February 2001 etc. etc. Currently,I've managed to group the Month and the Genre by using nested CFOUTPUTs.. <cfoutput query="Allnews" group="Date"> #Dateformat(Date,"ddd,mmmm,yyyy")#<BR> <CFOUTPUT group="Genre"> But of course this displays the Month over and over and over. I know one of you really smart people here can probably give a rough draft of a CFOUTPUT nest off the top of their heads to do this..it seems like something very common that a user would want to do with a report,so if you can..will you? :) http://www.carigamer.com/default.cfm?page=news/newsarchives.cfm I don't want to embark on a series of CFLOOPS and <CFIF CurrentDate eq OldDate> and all that stuff..I feel there must be an SQL based solution to this..is there? -Gel ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
