I've created a simple calendar page which uses 2 cfoutput groups to put the
calendar events together into monthly sections, then orders the events within
that month into date order.

It works well, however, when there are more than one events on a specific
date, it will only display one of them, and ignore the rest.

This is the SQL

SELECT
year(date_start) as year_start
, month(date_start) as month_start
, date_start
, date_finish
, evt_name
, evt_detail
FROM calendar
<!---Use sql to set todays date--->
WHERE date_start >= current_date
order
by year_start
, month_start
,date_start

This is my Cf code:

<cfoutput query="calendar" group="month_start">
#MonthAsString(calendar.month_start)##calendar.yea r_start#"

<cfoutput group="date_start">

#DateFormat(calendar.date_start, "dd-mmm")#
#DateFormat(calendar.date_finish, "dd-mmm")#
#Trim(calendar.evt_name)#
#Trim(calendar.evt_detail)#
</cfoutput>
</cfoutput>

Is there something rather obvious I'm missing?