I'm a bit rusty on my coding and need some guidance. I am trying to
create a calendar of events and I cannot get my groupings working
correctly and I'm hoping I can get some help on this issue.
I want my output to look like so:
MONDAY, NOVEMBER 13, 2006
Event Department Name
Test 1 Mathematics
Date: 11-13-06
Time: 11:30 AM
Location: Student Center
TUESDAY, NOVEMBER 14, 2006
Event Department Name
Test 2 Biology
Date: 11-14-06
Time: 10:30 AM
Location: Library, 1st floor
Robotics Technology Conference Computer Science
Date: 11-14-06
Time: 3:30 PM
Location: Computer Science Lab 5
and so on where events on the same day show up under that day (in this
example, Tuesday has 2 events).
My query is:
<CFQUERY NAME="GetEvents" DATASOURCE="#Application.DSN#">
SELECT DepartmentName,
EventName,
CONVERT(datetime, EventStart, 101) AS DateStart,
CONVERT(datetime, EventStart, 108) AS TimeStart,
EventStart, EventEnd, EventLocation,
EventDescription, EventContact
FROM tblEvents
</CFQUERY>
and then for my output I have:
<CFOUTPUT QUERY="GetEvents" GROUP="DateStart">
(output here)
</CFOUTPUT>
Right now, my two Tuesday header is repeating for each of the Tuesday
events. I've tried several different solutions and haven't found one
that works correctly. I am obviously missing something. Can someone
help? Thanks so much!
|
