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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
