% strCnn = "DBQ=" & Server.MapPath ("/db/chaseevans.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};" Set conn = server.CreateObject("ADODB.Connection") conn.Open strCnn, 1, 1 Set rs = Server.CreateObject("ADODB.Recordset") rs.Open "SELECT count(id) as totalhomes FROM property where on_market = 'Yes';", conn, 0, 1 totalhomes = rs("totalhomes") Set rs = Server.CreateObject("ADODB.Recordset") rs.Open "SELECT count(id) as totalflats FROM lettings where on_market = 'Yes';", conn, 0, 1 totalflats = rs("totalflats") Set rs = Server.CreateObject("ADODB.Recordset") rs.Open "SELECT min(price) as minprice FROM lettings where price is not null and on_market = 'Yes';", conn, 0, 1 minprice = rs("minprice") Set rs = Server.CreateObject("ADODB.Recordset") rs.Open "SELECT count(id) as tnew FROM property where (date_posted - Date() > 10) and on_market = 'Yes';", conn, 0, 1 tnew = rs("tnew") %>
| Discover the history of
Royal Arsenal, London SE18 Since about 1518 Woolwich had been the location of the Royal Dockyard and ordnance storehouses but development of the present site of Royal Arsenal West, then known as Woolwich Warren, began in 1671 when the Crown purchased the old mansion known as Tower Place together with 31 acres of land, for use as an ordnance storage depot. The change from storage depot to munitions factory began in 1 696 when the Royal Laboratory was constructed for the purpose of manufacturing ammunition, fuses and gun-powder. Up
to 1716 all guns for government service were cast at the foundry of Mr John Bagley in
Moorfields The new foundry, known as the Royal Brass
Foundry, was designed by Sir John Vanbrugh and New development, also to the designs of
Vanbrugh, included the Great Pile of Buildings now Further expansion and the introduction of
substantial improvements in weapon design and During the 2nd World War, with the Royal
Arsenal Woolwich working to the limit of its capacity Over 11,000 railway trucks were produced
in the Arsenal together with automatic and multiple Although some action to this end was
taken, the Arsenal continued to decline until the Woolwich Two small areas remained in MOD use though
known as Royal Arsenal West and Royal Arsenal |
| ^^ |