It looks like you are already using a group by in the query to group by month, just use a second group by, this one on the day. In the second group by set the bg color.
Patrick McGeehan Applications Developer DIT <CF_DIT>#mcg#</CF_DIT> -----Original Message----- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Monday, March 28, 2005 4:44 PM To: CF-Talk Subject: Alternating Row Colour - Sorta Here's the page in question: http://www.stpaulscolumbia.com/calendar.cfm Client is asking for alternating colors for DAYS - not rows. At first, I figured, OK, Odd Dates one colour, Even Dates another. Nope, don't work because there may be something on the 5th and 7th, both odd dates - but not the 6th ... and then you'd get two groups of events - those on the 5th and 7th, the same colour. I'm looking at various convoluted ideas for this, but bet the list can comeup with something a little more compact than I... Ideas? -- ----------- Les Mizzell ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:200281 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
