SELECT Event_subtitle, the_realdate, Event_Title, the_enddate, category, Event_Description, ID FROM calendar WHERE Persist = 1 AND Category LIKE '#session.category#' ORDER BY the_realdate SELECT Event_subtitle, the_realdate, category, Event_Title, the_enddate, Event_Description, ID FROM calendar WHERE The_enddate >= Date() AND Category LIKE '#session.category#' ORDER BY The_Realdate SELECT ID FROM calendar ORDER BY The_Realdate SELECT Title, ID FROM CalTypes WHERE Title Not Like '' ORDER BY Title

#title#

There are no event in the calendar at this time.

Every #dayofweekasstring(dayofweek(The_realdate))#   #Dateformat(The_realdate,'mmm dd, yyyy')# - #Dateformat(The_enddate,'mmm dd, yyyy')#
#dayofweekasstring(dayofweek(The_realdate))# - #dayofweekasstring(dayofweek(The_enddate))#
#UCASE(category)# CALENDAR

#Event_Title#
#Event_subTitle#
#trim(Event_Description)#

#Dateformat(The_realdate,'mmm dd, yyyy')# #Dateformat(The_realdate,'mmm dd, yyyy')# to #Dateformat(The_enddate,'mmm dd, yyyy')#
#dayofweekasstring(dayofweek(The_realdate))# #left(dayofweekasstring(dayofweek(The_realdate)),3)# - #left(dayofweekasstring(dayofweek(The_enddate)),3)#	#Event_Title# #trim(Event_subtitle)# #trim(Event_Description)#

SELECT Title FROM CalTypes WHERE ID Like '#session.category#' #getQ.Title#