SELECT * FROM event_2 WHERE evnt_end_time > #time# ORDER BY evnt_st_date ASC, venue_name ASC SELECT * FROM event_2 WHERE evnt_end_time > #time# #PreserveSingleQuotes(temp_event_part_query)#) ORDER BY evnt_st_time ASC, venue_name ASC SELECT event_id, artist_id, event_part, other_part FROM event_2 WHERE evnt_end_date > #now()# SELECT artist_name FROM artist_info WHERE artist_id=#artist_id# SELECT artist_name FROM artist_info WHERE artist_id=#event_part# SELECT artist_name FROM artist_info WHERE artist_id=#art_id# INSERT INTO event_temp_data (event_id, artist_name) VALUES (#art_name_list.event_id#, '#art_name_list.art_name#') SELECT * FROM event_2 WHERE evnt_end_time > #Now()# ORDER BY evnt_st_date, venue_name
Event Search Results:
 Your Search Returned No Results, Go HERE to try another search. Your Search Returned No Results, Go HERE to try another search. The following #evnt_srch.recordcount# Events matches your search criteria.
Displaying Record s #starter# - #evnt_srch.recordcount# #ender# of #evnt_srch.recordcount#

venue=yes&genre=#genre2#&venue_name=#URLEncodedFormat("#venue_name#")#&starter=#pre_start#list=yes&genre=#genre2#&starter=#pre_start#artist=yes&genre=#genre2#&art_name=#URLEncodedFormat("#art_name#")#&starter=#pre_start#edate=yes&event_month=#event_month#&event_day=#event_day#&event_year=#event_year#&genre=#genre2#&starter=#pre_start#"><<< Previous 10 Events           venue=yes&genre=#genre2#&venue_name=#URLEncodedFormat("#venue_name#")#&starter=#next_start#list=yes&genre=#genre2#&starter=#next_start#artist=yes&genre=#genre2#&art_name=#URLEncodedFormat("#art_name#")#&starter=#next_start#edate=yes&event_month=#event_month#&event_day=#event_day#&event_year=#event_year#&genre=#genre2#&starter=#next_start#">Next 10 #remain_evnt_cnt# Events >>>
#event_name#  
Taking Place At: #venue_name#
SELECT * FROM artist_info WHERE artist_id=#artist_id# SELECT * FROM art_specs WHERE artist_id=#artist_id# Featuring:   #get_a_name.artist_name#
[#UCase("#get_a_name.art_type#")#, #Replace("#get_a_specs.art_style#", "_", " ", "ALL")# ]
 
Appearing with:
SELECT * FROM artist_info WHERE artist_id=#art_id# SELECT * FROM art_specs WHERE artist_id=#art_id# #get_b_name.artist_name# |  
 #other# |  
Registered Artists Appearing:
SELECT * FROM artist_info WHERE artist_id=#art_id# SELECT * FROM art_specs WHERE artist_id=#art_id# #get_b_name.artist_name# 
#other# |  
Date:
Daily
Mon
Mon, Tue
Tue, Wed
Wed, Thu
Thu, Fri
Fri, Sat
Sat, Sun
 #DateFormat("#evnt_st_date#", "m/d/yy")# - #DateFormat("#evnt_end_date#", "m/d/yy")#
Time:
#TimeFormat("#evnt_st_time#", "h:mmt")# - #TimeFormat("#evnt_end_time#", "h:mmt")#
 Date:
#DateFormat("#evnt_st_date#", "DDD")#
#DateFormat("#evnt_st_date#", "m/d/yy")#
 Time:
#TimeFormat("#evnt_st_time#", "h:mmt")# - #TimeFormat("#evnt_end_time#", "h:mmt")#
venue=yes&genre=#genre2#&venue_name=#URLEncodedFormat("#venue_name#")#&starter=#pre_start#list=yes&genre=#genre2#&starter=#pre_start#artist=yes&genre=#genre2#&art_name=#URLEncodedFormat("#art_name#")#&starter=#pre_start#edate=yes&event_month=#event_month#&event_day=#event_day#&event_year=#event_year#&genre=#genre2#&starter=#pre_start#"><<< Previous 10 Events           venue=yes&genre=#genre2#&venue_name=#URLEncodedFormat("#venue_name#")#&starter=#next_start#list=yes&genre=#genre2#&starter=#next_start#artist=yes&genre=#genre2#&art_name=#URLEncodedFormat("#art_name#")#&starter=#next_start#edate=yes&event_month=#event_month#&event_day=#event_day#&event_year=#event_year#&genre=#genre2#&starter=#next_start#">Next 10 #remain_evnt_cnt# Events >>>
DELETE * FROM event_temp_data