This is classic me. I've promised myself into a corner and demoed something hard coded without thinking about how to construct an elegant query to feed it in production-mode via a database.
Query 1. 5 separate "ads" that run for a week each and rotate each Monday morning. I need to run ad 1 for a week, then ad 2 for a week, ....ad 5 for a week, and then recycle to ad 1 for a week again. These are actually meal menus that progress forward a week with each cycle. Query 2. I need to feed a scroller with "this week" information from a db with the table columns itemdate, itemdetail. I've thought of some kluges (particularly for number 2, which has resulted in some truly epic, Byzantine queries), but I'd like something elegant. Any ideas? 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 Get the mailserver that powers this list at http://www.coolfusion.com