>A cfdump tells me that the query is returning the correct results. My
>question is this, how do I get my output to display like this:
>
>February
><hr>
>dd Event Name
>dd Another Event Name
>
>March
><hr>
>dd And the Next Event
>dd And Another
Here are some basics, with very little formatting, which should get you what you're
looking for:
<cfoutput query="qYear" group="dtStartDate">
#DateFormat(qYear.dtStartDate,"MMMM")#
<hr />
<cfoutput>
#qYear.strEvent#<br />
</cfoutput>
</cfoutput>
Scott
--------------------------------
Scott Brady
http://www.scottbrady.net/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4