site designed by MiMat.com
Clubs and Classes
SELECT * FROM regularevent WHERE 1=2 OR UCASE(CalendarDate) LIKE '%#UCase(Form.SearchRecords)#%' OR UCASE(EventDescription) LIKE '%#UCase(Form.SearchRecords)#%' OR UCASE(Location) LIKE '%#UCase(Form.SearchRecords)#%' OR UCASE(Cost) LIKE '%#UCase(Form.SearchRecords)#%' OR UCASE(Email) LIKE '%#UCase(Form.SearchRecords)#%' OR UCASE(Website) LIKE '%#UCase(Form.SearchRecords)#%' OR UCASE(EventName) LIKE '%#UCase(Form.SearchRecords)#%' OR UCASE(Contact) LIKE '%#UCase(Form.SearchRecords)#%' OR UCASE(Phone) LIKE '%#UCase(Form.SearchRecords)#%' OR UCASE(ShowTime) LIKE '%#UCase(Form.SearchRecords)#%' OR UCASE(Town) LIKE '%#UCase(Form.SearchRecords)#%' OR UCASE(Day) LIKE '%#UCase(Form.SearchRecords)#%' OR UCASE(EventPeriod) LIKE '%#UCase(Form.SearchRecords)#%' OR UCASE(DayofWeek) LIKE '%#UCase(Form.SearchRecords)#%' event - Search Records Search for Events, Clubs and Classes-
 
Search
There are #GetRecords.RecordCount# records that match #Form.SearchRecords#
#EventName#  #Location#  Display Edit

You can search by:-

  • town
  • Date
  • People
  • event name
  • in fact anything!
  • If you want weekly events - just type in Weekly
  • If you want Monthly events - just type in Monthly