You should do an
ORDER BY eventYear, eventMonth, iteccourse.coursestart asc
And then
<cfoutput query="getevents" group="eventYear">
#getevents.eventYear#<br/>
<cfoutput group="eventMonth">
#getevents.eventMonth#<br/>
<cfoutput>
#getevents.coursetitle#...<br/>
</cfoutput>
</cfoutput>
</cfoutput>
Pascal
> -----Original Message-----
> From: Ian Vaughan [mailto:[EMAIL PROTECTED]
> Sent: 16 July 2004 13:09
> To: CF-Talk
> Subject: Problem with SQL WHERE clause and CF ???
>
> I am trying to display a list of upcoming events grouped together by
> month. So for example it would show
>
> July 2004
>
> 23 Windows Course
> 25 Word Course
>
> August 2004
>
> 10 Windows Course
> 15 Excel Course
>
> etc......................
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
