Hi Folks,
So, I'm working on this project management system. We have projects and
tasks within projects. Both are in the same table. Not all projects have
tasks, but a task must be associated with a project. Output might look like
so:
PROJECT duedate
task1 duedate
task2 duedate
Okay, that's fine. But now they want to be able to order the output by the
nearest date in the group of duedates. In other words, if the project is due
next year, but one of the tasks is due tomorrow, they want the project to be
at the top of the list of items.
Here's the brief table:
projectid (num)
projectname (varchar2)
duedate (date)
parentid (num or null)
There's more in the table, but you get the idea. Thoughts on pulling grouped
data by the max(duedate) of the group?
Thanks!
-Deanna
Deanna Schneider
Interactive Media Developer
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
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
