select 1 as futurePastSorter, * from qryEvents where upper(companyName) like or upper(eventName) like or upper(eventType) like or eventstartdate like union select 2 as futurePastSorter, * from qryEventsPast where upper(companyName) like or upper(eventName) like or upper(eventType) like or eventstartdate like order by futurePastSorter, #url.sortby#
  • #numberformat(_totalOriginalRecords,"9,999")# Events Found
    • Current / Upcoming Events
    Past Events
    Past Events
    #dateformat(eventStartDate,"mmmm")# #year(eventStartDate)#
    #month(eventStartDate)#/#day(eventStartDate)#
    #ucase(dateformat(eventStartDate,"ddd"))#     		#htmlEditFormat(companyName)# - #htmlEditFormat(eventName)#
    #eventType#
    #htmlEditFormat(companyName)# - #htmlEditFormat(eventName)#
    #eventType#
#_lowerPagerDisplay#