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
