Before I post all my existing code (nothing seems to work yet) hopefully I'll explain myself well enough that someone (ANYONE!) can help me.
I'm working with VBScript, a table of events in a Microsoft SQL Database, creating ASP pages. The page was previously built by another programmer and it loops through all records with "event_date" field of today or greater. Now we've added 5 more event_date columns so we can have one row for an event with the same title, same description, etc, just recurring/multiple events dates. So I added columns "event_date1" "event_date2" "event_date3" etc.
Is there ANY way to continue to loop and pull in my event rows, listed in chronological order of the event dates, pulling in the rows with multiple event_dates multiple times but only pulling in the events with one date once? I actually did this simply with a bunch of if/thens, but they don't stay in chronological/date order. The events with multiple dates just stack, then move on to the next event_date1.
I've tried creating a few stored procedures, lots of loops, and now I'm dead in the water, tons of if/then statements, and I feel a bit logically dead... Please help, any advice or tips on where to look for the answer would be GREATLY appreciated.