> -----Original Message----- > From: Mike D. Johnson > Sent: Wednesday, July 06, 2005 5:15 PM > > I have items that are reserved for certain dates. > > In my database, I have reservationStartDate and > reservationEndDate. How > do I get an array with all of the days an item is unavailable? Mike, At the end of May we had a lengthy discussion on scheduling, which is similar to this problem. Check out the thread titled "Iterate through result set - Is this possible? (SQL)" http://lists.evolt.org/archive/Week-of-Mon-20050530/172876.html <><><><><><><><><><> Joshua L. Olson WAE Tech Inc. http://www.waetech.com/ Phone: 706.210.0168 Fax: 413.812.4864 Monitor bandwidth usage on IIS6 in real-time: http://www.waetech.com/services/iisbm/