SELECT zip FROM ZIPFilter WHERE user_id=#ZIPFilterUserID# AND zip <> '' SELECT * FROM event_2, artist_info, art_specs WHERE #PreserveSingleQuotes(ZIPWhereClause)# event_2.artist_id=artist_info.artist_id AND art_specs.artist_id=event_2.artist_id AND event_2.evnt_end_date >= #time# AND event_2.event_id NOT IN ( SELECT EventID FROM ClientEvents WHERE ClientEvents.UserID = #ZIPFilterUserID# AND ClientEvents.IsHidden = Yes ) ORDER BY evnt_end_date ASC, venue_name ASC
CALENDAR OF EVENTS
Search Events:
#eventinfo.RecordCount# events  found...     
#event_name#  

Taking Place at: #venue_name#
#artist_name#
SELECT * FROM artist_info WHERE artist_id=#art# #get_name.artist_name#
SELECT artist_name FROM artist_info WHERE artist_id=#eventinfo.event_part# #get_name.artist_name#
  #other_part#  

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")#
<<< previous     next >>>