<cfquery name="worthATry" datasource="whatever">
SELECT
courseoutline.coursetitle, courseoutline.coursesummary,
courseoutline.coursepath,
iteccourse.coursestart, iteccourse.duration, iteccourse.availability
(to_char(coursestart, "YYYY") || to_char(coursestart, "MM")) AS
eventmonth,
count(courseoutline.coursetitle) AS noofcourses
FROM
courseoutline, iteccourse
WHERE
courseoutline.id = iteccourse.courseoutlineid
AND iteccourse.courseoutlineid ='1'
GROUP BY
courseoutline.coursetitle, courseoutline.coursesummary,
courseoutline.coursepath,
iteccourse.coursestart, iteccourse.duration, iteccourse.availability,
(to_char(coursestart, "YYYY") || to_char(coursestart, "MM"))
</cfquery>
concantenating the year and month will give you something to group on
properly....
I'm guessing would bring back every course in the month then you can do
<cfoutput group="eventmonth">
--
dc
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
