WHATS ON ABOUT US DIRECTIONS & MAP CONTACT US

STONELEIGH EVENTS

WHAT'S ON
<% Event_Date=MONTHNAME(Month(now()),true) Next_Month=MONTHNAME(Month(DateAdd("m",1,now()) ),true) Sql="SELECT *, SP_EP_WHATSON.Event_Number AS EvnetNo FROM SP_EP_WHATSON LEFT OUTER JOIN SP_EP_WHATSONINFO ON SP_EP_WHATSON.Event_Number = SP_EP_WHATSONINFO.Event_Number WHERE (From_Date like '%"&Event_Date&"%') OR (To_Date like '%"&Next_Month&"%') ORDER BY To_Date ASC, From_Date ASC" Title="" 'response.write Event_Date ConnString = Application("FASTHOSTS_ConnectionString") Set ObjDB = Server.CreateObject("ADODB.Connection") ObjDB.Open ConnString Sql2="SELECT count(Event_Number) AS counter FROM SP_EP_WHATSONINFO" Set objrs2 = ObjDB.Execute(Sql2) counter=objrs2("counter") Sql2="SELECT Event_Number FROM SP_EP_WHATSONINFO" Set objrs2 = ObjDB.Execute(Sql2) If objrs2.EOF Then else Do While Not objrs2.EOF RecArray=RecArray & objrs2("Event_Number")&"|" objrs2.MoveNext Loop end if objrs2.Close Set objrs2 = Nothing RecArray=Left(RecArray, (Len(RecArray)-1)) MyArray = Split(RecArray, "|", -1, 1) 'response.write Sql Set objrs = ObjDB.Execute(Sql) If objrs.EOF Then Response.Write("No events available at this time.") else Do While Not objrs.EOF For i = 0 to counter-1 step 1 if trim(objrs("Event_Number"))=trim(MyArray(i)) then Link="Yes" exit for else Link="No" end if next FromDate = objrs("From_Date") ToDate = objrs("To_Date") FromDateDay = Day(FromDate) FromDateMonth = Left(MonthName(Month(FromDate)), 3) FromDateYear = Year(FromDate) ToDateDay = Day(ToDate) ToDateMonth = left(MonthName(Month(ToDate)), 3) ToDateYear = Year(ToDate) If FromDateYear = ToDateYear then If FromDateMonth = ToDateMonth then If FromDateDay = ToDateDay then displaydate=FromDateDay &" "& FromDateMonth &" "& FromDateYear else displaydate=FromDateDay & " - "&ToDateDay &" "& ToDateMonth &" "& ToDateYear end if else displaydate=FromDateDay &" "& FromDateMonth &"-"&ToDateDay &" "& ToDateMonth &" "& ToDateYear end if else displaydate=FromDateDay &" "& FromDateMonth &" "& FromDateYear &"-"&ToDateDay &" "& ToDateMonth &" "& ToDateYear end if Event_Number=objrs("EvnetNo") %> <% objrs.MoveNext Loop end if objrs.Close objDB.Close Set objrs = Nothing Set objDB = Nothing %>

<%=displaydate%>

<%=objrs("Event_Name")%>

Privacy

Who we are

The Royal Agricultural Society of England (RASE) is a registered charity based at Stoneleigh Park, Warwickshire. Its registered address is Royal Agricultural Society of England, Stoneleigh Park, Warwickshire. CV8 2LZ. RASE are committed to providing users with an Internet experience which respects their privacy. We adhere strictly to the requirements of the UK Data Protection Act 1998. RASE have an up-to-date entry under the Data Protection Register. This can be seen at: http://www.esd.informationcommissioner.gov.uk/esd/search.asp, when you reach this page simply use the search function provided and type Royal Agricultural Society of England to locate our specific page.

About this statement - Your consent

The purpose of this statement is to explain to you how we may use your personal information. By submitting your information to us, you consent to the use of that information as set out in this policy. If we change any details of our Privacy Policy, we will post the changes on this page.

Information you provide

Web usage information to develop and improve our website.
Registration information to keep you informed.
Name, address, e-mail, credit card and order details.
Other data, from time to time, to help us provide you with improved products and/or services.

How we use personal information

To process any orders you make and administer your account (including fraud prevention).
To enable us to review, develop and improve the products, services, special offers and events that we offer.
To provide access to privileged areas of the website and provide additional information.
To administer contests, competitions and news email service.
To carry out market research and personalise your visit to our website.

Who do we pass personal information to?

We may provide information about you as follows:

To employees, partners and agents of the RASE to administer any accounts, products and services provided to you by the RASE now or in the future.
Other than as necessary to fulfil your order, we will not provide your personal information (i.e. information you supply that identifies you) to any third party without your consent or unless we are required to do so by law or unless we have asked your permission first.

Data Security

We endeavour to take all reasonable steps to protect your personal information. To this end, we apply our internal data protection policy to processing your data, and ensure any third party that processes your data signs a security contract. Appropriate physical and logical security measures are taken to ensure your data remains safe.

Your use of this site

In order that we can monitor and improve the site, we may gather certain information about you when you use it, including details of your domain name and IP address, operating system, browser, version, cookie details and the web site that you visited prior to our site.

Cookies

Cookies are small pieces of information stored by your browser on your computer's hard drive. We use cookies to allow us to understand who has seen which pages, to determine how frequently particular pages are visited and to determine the most popular areas of our website. Most web browsers automatically accept cookies, though you do not have to. If you wish to disable cookies please refer to your user manual although please remember that by disabling cookies you may not be able to access certain features on this website.

3rd party information

We may supplement the information that you provide to us with information that we receive from third parties, for example, collected from other members of your household.

Our terms

Please note that all products and services are supplied subject to our terms and conditions.

Contact Us

If you have any comments or queries in connection with our privacy policy, or if you need to update or amend any personal information you may contact us via the following methods:-
Email: info@rase.org.uk
Telephone: +44(0)24 7669 6969 between the hours of 9am-5pm GMT (Monday-Friday excluding Public/Bank Holidays)
Writing: The Royal Agricultural Society of England, Stoneleigh Park, Warwickshire, CV8 2LZ. United Kingdom

Please note that our VAT number is: GB 646 9219 08.
Registered Charity Number: 209961

When you contact us regarding a purchase over the internet, please state clearly the details of the transaction and if possible a reference number, the nature of the enquiry, and a method of contacting you back should that be required.