I have a function within a CFC that reads like this:
<cffunction name="getCalendar" access="remote" output="false"
returntype="query">
<cfargument name="calendar" required="No" type="string"
default="Full Year">
<cfquery name="qYear" datasource="#application.stconfig.DSN#">
Select i.dtStartDate,
i.dtEndDate,
i.strEvent,
i.txtDescription
From tblCalendarItems i,
tblCalendar c
Where c.strCalendarName = <cfqueryparam
value="#arguments.calendar#" cfsqltype="CF_SQL_VARCHAR"> and
i.intCalID = c.intCalendar
Order by i.dtStartDate,
i.strEvent
</cfquery>
<cfreturn qYear>
</cffunction>
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
April
<hr>
dd And Even Another
If more clarification is needed let me know.
Cutter
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
