If you order by dayofweek in your query, you can group by that column. <cfquery name="myQuery" ....> SELECT * FROM table ORDER BY DayOfWeek </cfquery>
<cfoutput query="myQuery" group="DayOfWeek"> Day - #myQuery.DayOfWeek# <br> <cfoutput> Any other columns </cfoutput> </cfoutput> _____________________________ steve oliver senior internet developer atnet solutions, inc. http://www.atnetsolutions.com -----Original Message----- From: Jon CFTalk [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 11:57 PM To: CF-Talk Subject: RE: Database and Query issues.......YIKES! What is the best way to go about that? JON -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 1:41 PM To: CF-Talk Subject: RE: Database and Query issues.......YIKES! Have you looked at the group attribute of the cfoutput tag? That might help. Could you give us a sample of what you want your output to look like? Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -----Original Message----- From: Jon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 4:21 PM To: CF-Talk Subject: Database and Query issues.......YIKES! Hi, Any suggestions for the problem below? I need to show a page that returns a table of IDs sorted by a WeekOf ID - showing the most recent. Within that result set there needs to be details corresponding to those IDs. [so far that works]. The problem is, how can I return the details sorted by DayOfWeek and show multiple sets of details for the same DayOfTheWeek ID. As of now I have; History Table [shows the ID of the records I want to return] 4 detail Tables [Each has a Descriptions and an ID to the name of the day of the week] JOINED to the DayOfTheWeek Table [1 = Monday] a WeekOf Table [numbering the weeks of the year] _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
