I typically do my own groupings
<cfset curMonth="">
<cfset curDay="">
<cfloop query="">
<cfif month(date) neq curMonth>
#month#
<cfset curmonth=month(date)>
<cfset curDate="">
</cfif>
<cfif day(date) neq curDay>
#day#
<cfset curDay=day(date)>
</cfif>
#date line#
</cfloop>
On 4/20/06, Ray Champagne <[EMAIL PROTECTED]> wrote:
> I have an event table that I need to output the data in a specific
> fashion, based on dates, like so:
>
> April
> 19th
> event1
> event2
> event3
> 26th
> event4
> event5
> 30th
> event6
> event7
> event8
> May
> 1st
> event10
> event11
> 17th
> event12
>
> June
>
> etc
>
> I have the date stored as a date type in the DB. What's the best way to
> go about outputting the events, grouped as above? I've come up with
> some elaborate workarounds, but they seem clunky and not very
> maintenance-friendly.
>
> For argument's sake, let's say the current select statement looks like this:
>
> SELECT startdate, event_title
> FROM events
> WHERE active=1
> ORDER BY startdate ASC
>
> Thanks,
>
> Ray
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238282
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
