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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
