This should work, if I understand the result correctly (alternate
color by day, not by row).
<!--- Fake Query --->
<cfset qEvents = queryNew("label,event_date") />
<cfset queryAddRow(qEvents, 11) />
<cfset querySetCell(qEvents, "label", "Mon - event 1", 1) />
<cfset querySetCell(qEvents, "label", "Mon - event 2", 2) />
<cfset querySetCell(qEvents, "label", "Mon - event 3", 3) />
<cfset querySetCell(qEvents, "label", "Tue - event 1", 4) />
<cfset querySetCell(qEvents, "label", "Tue - event 2", 5) />
<cfset querySetCell(qEvents, "label", "Tue - event 3", 6) />
<cfset querySetCell(qEvents, "label", "Tue - event 4", 7) />
<cfset querySetCell(qEvents, "label", "Thu - event 1", 8) />
<cfset querySetCell(qEvents, "label", "Thu - event 2", 9) />
<cfset querySetCell(qEvents, "label", "Thu - event 3", 10) />
<cfset querySetCell(qEvents, "label", "Thu - event 4", 11) />
<cfset querySetCell(qEvents, "event_date", "3/28/2005", 1) />
<cfset querySetCell(qEvents, "event_date", "3/28/2005", 2) />
<cfset querySetCell(qEvents, "event_date", "3/28/2005", 3) />
<cfset querySetCell(qEvents, "event_date", "3/29/2005", 4) />
<cfset querySetCell(qEvents, "event_date", "3/29/2005", 5) />
<cfset querySetCell(qEvents, "event_date", "3/29/2005", 6) />
<cfset querySetCell(qEvents, "event_date", "3/29/2005", 7) />
<cfset querySetCell(qEvents, "event_date", "3/31/2005", 8) />
<cfset querySetCell(qEvents, "event_date", "3/31/2005", 9) />
<cfset querySetCell(qEvents, "event_date", "3/31/2005", 10) />
<cfset querySetCell(qEvents, "event_date", "3/31/2005", 11) />
<!--- Output --->
<cfset colors = arrayNew(1) />
<cfset colors[1] = "##EAEAEA" />
<cfset colors[2] = "##CCCCCC" />
<cfset currentColor = 1 />
<table>
<cfoutput query="qEvents">
<cfif qEvents.currentRow gt 0
and qEvents.event_date neq qEvents.event_date[qEvents.currentRow - 1]>
<cfif currentColor eq 1><cfset currentColor=2><cfelse><cfset
currentColor=1></cfif>
</cfif>
<tr style="background:#colors[currentColor]#">
<td>#dateformat(event_date, "mmmm d, yyyy")#</td>
<td>#label#</td>
</tr>
</cfoutput>
</table>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200394
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
