You can group within a group by grouping again, like this.
<cfoutput query="myQuery" group="DayOfWeek">
Day: #DayOfWeek#
<cfoutput group="HourOfDay">
Hour: #HourOfDay#
<cfoutput>
#any other variables#
</cfoutput>
</cfoutput>
</cfoutput>
Just make sure that you order by what your grouping, or it won't come
out as you expect.
_____________________________
steve oliver
senior internet developer
atnet solutions, inc.
http://www.atnetsolutions.com
-----Original Message-----
From: CF_JONNY [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 10:18 AM
To: CF-Talk
Subject: RE: Database and Query issues.......YIKES!
STEVE You Are Awesome!
Could I group with in a group? or can I ORDER BY something such as AM or
PM?
THANKS
-----Original Message-----
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 12, 2002 9:07 PM
To: CF-Talk
Subject: RE: Database and Query issues.......YIKES!
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
