<% class Quotes Public Function GetQuotes() Dim sSQL, oSQL Dim nRecordsAffected Set oSQL = New DB_IO sSQL = "Select * from Quotations " Set GetQuotes = oSQL.RunSQLWithRS(sSQL) Set oSQL = nothing End Function Public Function GetQuote(rNum) Dim sSQL, oSQL Dim nRecordsAffected Set oSQL = New DB_IO sSQL = "Select * from Quotations WHERE Id =" & rNum & " " 'response.write sSQL 'response.end Set GetQuote = oSQL.RunSQLWithRS(sSQL) Set oSQL = nothing End Function end class %> <% Dim oQuote, oQuoteRS Dim rNum, totQuotes, Quote, Author Set oQuote = New Quotes set oQuoteRS = oQuote.GetQuotes() totQuotes = oQuoteRS.recordCount Randomize rNum = Int((totQuotes - 1 + 1) * Rnd + 1) set oQuoteRS = oQuote.GetQuote(rNum) Quote = oQuoteRS("Quotation") Author = oQuoteRS("Author") %>
<%= quote%> - <%= author%>
    Home     Community     Shops and Trade     About the village     Contact            
 
     
 
An online tour of Chew Magna .....

 
 
 

The village is about 10 miles from Bristol, 14 miles from Bath and 13 miles from the city of Wells. It is just on the northern edge of the Mendip Hills (a designated Area of Oustanding Natural Beauty) and is in the general area known as the Chew Valley. The village is a conservation area which has meant that Chew Magna has retained its character, friendliness and quiet charm.

There are two Primary schools and a Secondary school, several shops, three churches, three pubs serving the area. The community has about 1200 residents and there are several other nearby villages and hamlets.

Chew Magna has an interesting history that provides a backdrop to today's vibrant society... a little more is described in our history page.

The logo at the top of the page is from the new road boundary stones, installed April 2003, that welcome every one to the village.


  
 
Next>>>
  
 
 



 
  Level A conformance icon, W3C-WAI Web Content Accessibility Guidelines 1.0  
Visit our Sponsors
 Managed by and copyright of Abitas Ltd based in the UK.

All content, photographic material, art work and design on this site are covered by copyright, please ask permission if you wish to use or purchase copies of material for any purpose commercial or private.

Click to email chewmagna