Select Show <% Do Until rsShowNames.EOF %> <%=rsShowNames("showname")%> <% rsShowNames.MoveNext Loop %>

Which date are you available?
Pick your favorite or one that fits your schedule:

Select Date <%'Loop through rs Do Until rsShowDates.EOF dtFormattedDate = niceDate( rsShowDates("showdate") )%> "><%= dtFormattedDate %> <% rsShowDates.MoveNext Loop %> <% rsShowDates.Close %>

Which range of dates are you available?
If you're only in town for a few days, see what's taping during that time:

Start Date <% rsShowDates.Open sql, oEventsConn 'Loop through rs Do Until rsShowDates.EOF dtFormattedDate = niceDate( rsShowDates("showdate") ) %> "><%= dtFormattedDate %> <% rsShowDates.MoveNext Loop rsShowDates.Close %> thru End Date <% rsShowDates.Open sql, oEventsConn 'Loop through rs Do Until rsShowDates.EOF dtFormattedDate = niceDate( rsShowDates("showdate") )%> "><%= dtFormattedDate %> <% rsShowDates.MoveNext Loop %>