If you have the menus in an Array numbered 1 through 5, you could do something like:
<cfset thisWeeksMenu=weeklyMenu[Week(Now()) MOD 5 + 1]> > -----Original Message----- > From: Kennerly, Rick H CIV [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 08, 2003 9:44 AM > To: CF-Talk > Subject: 5 week rotation > > > Seems like someone did this sometime in the recent past, but > I couldn't find > it in the archives. > > I have 5 fixed-text items in a database that need to rotate > display on a > weekly basis, rotating weekly on Monday (week one: item one; > week two, item > two). Obviously the purpose of having 5 items is so that the > same piece is > not displayed on the same week of the month every month (they > rotate forward > one week each month). It's not an ad, it's a lunch menu. I > can't work out > an query that will work. > > Any elegant query ideas? Okay, any ideas at all? > > Rick > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
