5 week rotation

2003-01-08 Thread Kennerly, Rick H CIV
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 s

RE: 5 week rotation

2003-01-08 Thread Everett, Al
If you have the menus in an Array numbered 1 through 5, you could do something like: > -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 > > > See

Re: 5 week rotation

2003-01-08 Thread John Paul Ashenfelter
H CIV" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 08, 2003 9:43 AM 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 fixe

Re: 5 week rotation

2003-01-08 Thread jochemd
Quoting "Kennerly, Rick H CIV" <[EMAIL PROTECTED]>: > > 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 displa

Re: 5 week rotation

2003-01-08 Thread Casey C Cook
I posted an approach to solving the problem, I did not post a code solution. Here what I had to say in a previous post: Have a table with the fields, ItemID, AdBeginDate, AdEndDate, ItemDetail, AdDate (if needed) Then just write a query to check what todays date is and what Ad/item should be dis