" & vbcrlf
'loop each of the returned records and output a table row.
do while not rs.eof and not rs.bof
'generate table row for selected record
tablehtml = tablehtml & "
" & vbcrlf
rs.movenext
loop
'close off table html
tablehtml = tablehtml & "
"
'return html
genSpeciesTable = "
This is a selection of the " & grp & " species that we care for at the Trust. Click on any picture for a larger version, and click on the name of the species to be taken to the application form.
If you are looking for a particular species that is not listed here please call our main office on 01264 773850.
Sorry, there are no " & grp & "s available for friends sponsorship in the list at present. If you call our main office on 01264 773850, they may be able to help.
"
' else
' currText = "Factoid number " & fnum
end if
activeText = currText
rs.close
set rs = Nothing
end function
function factoid()
dim clause, currText
'Store the SQL Query
strsql = "SELECT * FROM HCT_factoids ORDER BY RAND() LIMIT 0,1"
'Execute the query and save the resultset to rs.
set rs = dbconn.execute(strsql)
'Check rs is not begining/end of file (i.e. no records returned)
if not rs.eof and not rs.bof then
currText = "
" & vbcrlf
tr.movenext
loop
'return html
testimonialList = pagehtml
else
'return an error message
testimonialList = "
Sorry, there are no " & grp & " comments available to display at present.
"
end if
tr.close
set tr = Nothing
end function
'Function for outputing a single testimonial
function testimonialBox(grp)
dim pagehtml, clause, intRow, intRandomNumber
'if a group string is passed to the function
'then add an additional WHERE clause to
'SQL query.
pagehtml = ""
if not isnull(grp) and grp <> "" then
clause = " `T_Type` = '" & antiInject(grp) & "' AND "
end if
'Store the SQL Query
strsql = "SELECT * FROM HCT_testimonials WHERE " & clause & " T_Active=1 ORDER BY RAND() LIMIT 0,1"
'Execute the query and save the resultset to rs.
set T_record = dbconn.execute(strsql)
'Check shop_record is not begining/end of file (i.e. no records returned)
if not T_record.eof and not T_record.bof then
pagehtml = ""
pagehtml = pagehtml & "
" & vbcrlf
end if
'return html
testimonialBox = pagehtml
T_record.close
set T_record = Nothing
end function
'Function for outputing a single testimonial on the main page sector
function testimonialWide(grp)
dim pagehtml, clause, intRow, intRandomNumber
'if a group string is passed to the function
'then add an additional WHERE clause to
'SQL query.
pagehtml = ""
if not isnull(grp) and grp <> "" then
clause = " `T_Type` = '" & antiInject(grp) & "' AND "
end if
'Store the SQL Query
strsql = "SELECT * FROM HCT_testimonials WHERE " & clause & " T_Active=1 ORDER BY RAND() LIMIT 0,1"
'Execute the query and save the resultset to rs.
set T_record = dbconn.execute(strsql)
'Check shop_record is not begining/end of file (i.e. no records returned)
if not T_record.eof and not T_record.bof then
pagehtml = ""
' pagehtml = pagehtml & "
" & vbcrlf
end if
'return html
testimonialWide = pagehtml
T_record.close
set T_record = Nothing
end function
'Function for outputing a single message
function MOTD()
dim pagehtml, M_Record, todate
pagehtml = ""
todate = YEAR(Date()) & "-" & Month(date()) & "-" & DAY(date())
'Store the SQL Query
strsql = "SELECT * FROM HCT_MOTD WHERE M_Start <= '" & todate & "' AND M_End >= '" & todate & "' LIMIT 0,1"
'Execute the query and save the resultset to rs.
set M_record = dbconn.execute(strsql)
'Check shop_record is not begining/end of file (i.e. no records returned)
if not M_record.eof and not M_record.bof then
pagehtml = ""
pagehtml = pagehtml & "
" & vbcrlf
rs.movenext
loop
'return html
genEvents = eventhtml
else
'return an error message
genEvents = "
Sorry, there are no events available to display at present. If you call our main office on 01264 773850, they may be able to help.
"
end if
rs.close
set rs = Nothing
end function
function genCarol()
dim eventhtml
'Store the SQL Query
strsql = "SELECT * FROM HCT_events WHERE Event_BBE >= current_date() AND Event_ID= 13"
'Execute the query and save the resultset to rs.
set rs = dbconn.execute(strsql)
'Check rs is not begining/end of file (i.e. no records returned)
if not rs.eof and not rs.bof then
eventhtml = ""
'loop each of the returned records and output an event block.
do while not rs.eof and not rs.bof
'generate table row for selected record
eventhtml = eventhtml & "" & vbcrlf
eventhtml = eventhtml & "
" & rs.fields("Event_title") & "
" & vbcrlf
eventhtml = eventhtml & "
" & rs.fields("Event_dates") & "
" & vbcrlf
eventhtml = eventhtml & "
" & rs.fields("Event_text") & "
" & vbcrlf
rs.movenext
loop
'return html
genCarol = eventhtml
else
'return an error message
genCarol = "
"
end if
rs.close
set rs = Nothing
end function
function genAllEvents()
dim eventhtml
'Store the SQL Query
strsql = "SELECT * FROM HCT_events ORDER BY Event_start"
'Execute the query and save the resultset to rs.
set rs = dbconn.execute(strsql)
'Check rs is not begining/end of file (i.e. no records returned)
if not rs.eof and not rs.bof then
eventhtml = ""
'loop each of the returned records and output an event block.
do while not rs.eof and not rs.bof
'generate table row for selected record
eventhtml = eventhtml & "
" & vbcrlf
rs.movenext
loop
'return html
genNews = newshtml
end if
rs.close
set rs = Nothing
end function
function frontpageNews()
dim newsline
'Store the SQL Query
strsql = "SELECT * FROM HCT_news WHERE news_fp=1 AND (DATE_ADD(news_date, INTERVAL 7 DAY) >= current_date()) ORDER BY news_date DESC LIMIT 0,1"
'Execute the query and save the resultset to rs.
set newsitem = dbconn.execute(strsql)
newsline = ""
if not newsitem.eof and not newsitem.bof then
newsline = "
" & vbcrlf
end if
'return html
frontpageNews = newsline
newsitem.close
set newsitem = Nothing
end function
function staffPopup(d_ID)
dim pagehtml, strsql
pagehtml = ""
'Store the SQL Query
strsql = "SELECT * FROM staff as a WHERE a.ID = '" & antiInject(d_ID) & "'"
'Execute the query and save the resultset to rs.
set rs = dbconn.execute(strsql)
'Check rs is not begining/end of file (i.e. no records returned)
if not rs.eof and not rs.bof then
xID = rs.fields("ID")
pagehtml = pagehtml & ""
pagehtml = pagehtml & "
" & rs.fields("Name") & "
"
pagehtml = pagehtml & "
" & rs.fields("Job") & "
"
pagehtml = pagehtml & "
" & rs.fields("Descr") & "
"
end if
staffPopup = pagehtml
rs.close
set rs = Nothing
end function
'Function for outputing available dates table
function genDatesTable(mType)
dim tablehtml, clause, thismonth, testmonth, thisyear, testyear
'if a group string is passed to the function
'then add an additional WHERE clause to
'SQL query.
if not isnull(mType) and mType <> "" then
clause = " `D_Type` = '" & antiInject(mType) & "' AND "
end if
'Store the SQL Query
strsql = "SELECT D_Type AS dType, EXTRACT(YEAR FROM D_Date) AS dYear, EXTRACT(MONTH FROM D_Date) AS dMonth, EXTRACT(DAY FROM D_Date) AS dDay FROM HCT_dates WHERE " & clause & " D_Open = 'yes' AND D_Date >= current_date() ORDER BY D_Date ASC"
'Execute the query and save the resultset to rs.
set rs = dbconn.execute(strsql)
'Check rs is not begining/end of file (i.e. no records returned)
if not rs.eof and not rs.bof then
'output the start of the table.
tablehtml = "
" & vbcrlf
tablehtml = tablehtml & "
Dates currently available*
" & vbcrlf
'loop each of the returned records and output a table row.
do while not rs.eof and not rs.bof
'generate table row for selected record
thisyear = rs.fields("dYear")
testyear = rs.fields("dYear")
firstyear = 1
do while not rs.eof and CInt(thisyear) = CInt(testyear)
tablehtml = tablehtml & "
"
if firstyear = 1 then
tablehtml = tablehtml & thisyear
firstyear = 0
else
tablehtml = tablehtml & " "
end if
tablehtml = tablehtml & "
"
do while not rs.eof and CInt(thismonth) = CInt(testmonth)
if firstday = 1 then
tablehtml = tablehtml & rs.fields("dDay")
firstday = 0
else
tablehtml = tablehtml & ", " & rs.fields("dDay")
end if
rs.movenext
if not rs.eof then
thismonth = rs.fields("dMonth")
thisyear = rs.fields("dYear")
end if
loop
tablehtml = tablehtml & "
" & vbcrlf
loop
loop
'close off table html
tablehtml = tablehtml & "
"
'return html
genDatesTable = tablehtml & "
*Please check availability with the office before making firm plans
"
else
'return an error message
genDatesTable = "
Sorry, there are no dates available at present. If you call our main office on 01264 773850, they may be able to help.
"
end if
rs.close
set rs = Nothing
end function
function fullmonth(thismonth)
if thismonth = "1" then fullmonth = "January"
if thismonth = "2" then fullmonth = "February"
if thismonth = "3" then fullmonth = "March"
if thismonth = "4" then fullmonth = "April"
if thismonth = "5" then fullmonth = "May"
if thismonth = "6" then fullmonth = "June"
if thismonth = "7" then fullmonth = "July"
if thismonth = "8" then fullmonth = "August"
if thismonth = "9" then fullmonth = "September"
if thismonth = "10" then fullmonth = "October"
if thismonth = "11" then fullmonth = "November"
if thismonth = "12" then fullmonth = "December"
end function
%>
The Hawk Conservancy
The Hawk Conservancy Trust has managed to breed an African White-backed Vulture chick in captivity – a rare occurrence indeed! This is made all the more significant because the parents were birds confiscated by Italian authorities in 2006 and re-homed at the Trust – please see the press release.
June 2009
Rare UK visitor is rescued from the Solent. A Honey Buzzard, rare to the UK, was found floating in the Solent and saved in a dramatic rescue by a couple in an inflatable dingy. It is thought that the bird had become exhausted on its migratory route to Britain from its winter home in Africa. Read on.
April 2009
The UK's only Great Bustard aviary opens at the Hawk Conservancy Trust. The Hawk Conservancy Trust Trust has joined forces with Great Bustard Group in an effort to promote the Great Bustard, the world's heaviest flying bird, and the project to reintroduce the species back into the UK.
We have built the UK's only public Great Bustard aviary, which was launched on Monday 20th April 2009 by Hawk Conservancy Trustee and zoologist, Chris Packham. Read on
Oct 2008
Christmas offer. This Christmas the Hawk Conservancy Trust is giving you a Christmas gift for free. Buy any hands-on experience session as a Christmas Gift and receive admission tickets for the 2009 season at the Trust absolutely free. If you purchase a whole day experience you will recieve an admission ticket for 2 adults (worth £20), and for a half day experience you will receive an admission ticket for one adult (worth £10).
Don't forget that that the Trust is now open weekends throughout the whole of the winter, and our Trust shop has a wide range of gift ideas for the whole family, including luxury hampers with mouth-watering items, nature based educational games and toys, books, limited edition prints, cuddly toys and much more. As an extra Christmas gift, if you spend more than £50 in a single transaction in our Trust shop (excluding experience day vouchers) you will also receive a family admission ticket to the Trust for free.
Sep 2008
Help support Mark Anderson's Flamingos
Mark Anderson is one of South Africa's leading ornithologists - a man with whom the Hawk Conservancy Trust has worked closely for a number of years, carrying out vital research on African White-Backed Vultures.
Full details of our work with Mark can be found on the web site under research on the front page or by following this link.
Another project in which Mark is closely involved concerns the Lesser Flamingo. Within a few miles of where the colony of vultures resides is one of Africa's only breeding sites for Lesser Flamingos, and this is currently under threat.
Please follow the link below, read the article, sign the petition and help conserve these wonderful birds and the fish Eagles who need them as well!!
Throughout the Spring a Japanese film company followed Ashley Smith, Chief Executive, and other members of Trust staff and volunteers, through their day to day work at the Trust. From tracking released buzzards, commentating displays and giving talks to the local WI's every aspect of life at the Trust was filmed. The film was broadcast on the Japanese equivalent to the BBC on the 5th July. The Japanese translator was so taken with the Trust whilst she was recording the voiceover, on her next day off she travelled down from London to visit the Trust and meet up with Ashley. The film company are providing staff with a premier of the film at the Trust on the 15th July. We hope that it will prove a popular broadcast and we look forward to welcoming are new found Japanese friends to the Trust.
The Japanese film crew interviewing local farmer Harold about the Red Kite release that took place on his land
July 2008
Which is Andover's Most Family Friendly Business?
The Hawk Conservancy Trust is one of eight businesses nominated for this Award – each one recommended by local people – and the judge is…you! Vote for your favourite here.
The vote ends on 31 July 2008 and the Most Family Friendly Business in Andover, as voted for by the people of Andover, will be announced early in August.
June 2008
The Hawk Conservancy Trust on ITV
The Hawk Conservancy Trust has received another visit from the TV crews. This time it is for the Thursday 26th June edition of ITV Thames Valley magazine programme Thames Valley Tonight that runs from 6:00pm to 6:30pm.
Following on from the programme there will be a web cam link from the pre-release aviary to a web site www.hawkhospital.co.uk which has been set up by ITV Fixers, the major campaign where young people (16 - 25) can take action on any issue they feel strongly about - changing things for the better.
The web site should be available shortly after the programme has aired.
May 2008
Medieval weekend at the Trust 3/5 May 2008
The May Day Bank Holiday weekend, May 3rd, 4th and 5th, 2008 will be a themed Medieval Weekend at The Hawk Conservancy Trust featuring the Sir William Gasgoine Fellowship in their tented village.
Visitors can expect to see medieval cooking, herbalism and archery, in addition to the usual flying displays etc.
Apr 2008
Test Valley Business Award for the Trust
CEO Ashley Smith receiving the award from TV presenter Sally Taylor and HSA Managing Director Chris Harrison
Last night, 7th April 2008, the Trust won an award in the Test Valley Business Awards.
We had been nominated for the HSA Business Excellence through People award, a category in which the judges were looking for businesses that use and encourage innovative ways to ensure that business practices work for employer and employee alike.
The Trust was announced the winner, out of 20 entrants to this category. In selecting the Trust,
Chris Harrison - HSA Managing Director - stated:
Ashley pictured with Sally Taylor and Chris Harrison
"This award goes to an organization that recognises that their staff are one of its best assets, and that everyone - whatever their role - is important to the business. Staff are encouraged to take up opportunities in educational qualifications, and are fully supported by the Trustees. Everyone is included in the Trust's work from staff to volunteers, and all have been involved in the setting of the Trust's strategies for the next 5 years. The Trust is committed to the welfare and well-being of its staff. Staff also have the opportunity to travel overseas to work on the Trust's conservation projects."
Apr 2008
2008 Photographic Competition announced
For the 2008 season the Hawk Conservancy Trust is again running an international photographic competition to celebrate the beauty of Birds of Prey, giving photographers, amateur and professional, the chance to show off their talents.Click here for details.
Feb 2008
Easter Mad about Owls weekend
Friday 21st March - Mon 24th March
Hold a British Owl.
Meet our new baby burrowing Owl
Learn how to track released owls by radio transmittor.
Dissect an owl pellet to see what owls eat.
Take part in our Owl colouring competition, with fantastic prizes to win.
Get up close and personal and watch our owls flying through the trees in our unique Woodland Owl display.
Dec 2007
Charity Challenge, win a national poster campaign
Everyclick.com has teamed up with Clear Channel Outdoor (the UK's leading poster company) to offer charities like the Trust the chance to win a free national poster campaign on over 1,500 sites across the UK.
Entering the Charity Challenge could bring huge benefits to the Trust. No matter how big or small all charities entering the competition will be given:
The chance to win a free national poster campaign
The chance to win free advertising space on Everyclick.com
An Everyclick home page customised to promote our charity and provide desktop brand awareness for us every time our supporters use Everyclick
Saturday 19th January 2008. Evening talk by Mike Mockler, International Wildlife Photographer and Wildlife Tour guide. Mike is a well known safari guide and wildlife tour leader. He is the author of many articles on natural history, conservation, African wildlife, ornithology and travel as well as two books about British birds. A respected ornithologist, he has broadcast many times on radio and television and is a successful nature photographer. His talk will cover his many trips to the African continent, and the birds and wildlife he has photographed there. Click here for details.
Nov 2007
The UK Pride of Place intiative has been launched by the government to ask residents of local councils to nominate the locations and attractions across England that they are most proud of. They want to know if you had one day to show off your part of the country, where would you take a visitor or tourist.
The Hawk Conservancy Trust was voted of one of the top ten attractions in the Test Valley Borough Council area. If you are proud of the Trust and would like us to be nominated as the place to visit in the Test valley, then visit www.ukprideofplace.com and cast your vote today.
The Pride of Place Poll will close on Friday 30 November. There will then be local announcements confirming the Pride of Place for your area.
Oct 2007
This winter the Hawk Conservancy Trust will be opening its doors to visitors at weekends throughout the winter season (November to February). There will be something to do to keep the whole family amused on a winter's day out. In the morning meet Clive in the study centre to have a go a wide range of hands on activities including: owl pellet dissection, bird of prey identification sessions and fun family quizzes. Learn about the conservation and rehabilitation work of the Trust, and how you can help us. There will be three exciting flying displays each day, and the chance for all visitors to hold a bird and adults to experience the thrill of flying a hawk. Let the children explore our new children's bird hides, and use the binoculars to look for wild raptors. Need warming up? Don't forget to visit Duffy's for a wide range of hearty hot meals, including Roast lunch on Sundays, and lots of hot drinks, cakes and pastries. A visit to the Trust shop will give you a wide range of gift ideas for Christmas, and don't forget to take advantage of our gift wrapping service. As a special offer if you spend over £50 on Christmas Gifts in a single transaction at the shop between 1st November and 24th December 2007 you will receive a gift from us of a family admission ticket, worth £28.50 (ticket valid for 6 months). We look forward to welcoming you to a winter trip to the Trust.
Oct 2007
A special evening at the Trust. Tuesday 20 November broadcaster and Trustee Chris Packham will talk about people, places and maybe a few photo tips in his ‘Postcards from Paradise’ presentation. Join Chris and the Wildlife Worldwide team at the Hawk Conservancy for an evening of drinks, food, owl flight demonstrations, close up encounters and some ‘wild’ chat.
Sept 2007
We now have two children's hides and are looking for binoculars to place in them. If you have an unwanted pair in good condition that children could use to observe birds from our hides, please contact the office on 01264 773850.
Sept 2007
Rescued rare Hobby returns to the wild - thanks to an unusual feather donor. Click here for details.
August 2007
A series of winter fundraising talks at the Trust. The talks will take place on selected Saturday evenings in our education centre, starting at 7pm and costing £10 per person (including an interval break with tea, coffee and cake). Click here for details.
August 2007
Look out for us on ITV Thames Valley news on 8th August at 11.10am, 1.50pm and 6pm. There will be a news item about this year's Tawny Owl research project.
July 2007
Winter opening. We shall be open to the public every weekend from 3rd November to 16th February. Click here for details.
July 2007
Owls by Moonlight. Due to a high level of demand, we have opened some extra dates for Autumn 2007. Click here for details.
May 2007
Summer Ball. The Trust is delighted to announce its grand Summer Ball on 20th July, 2007. Dancing to the New Antonians and auction of promises hosted by Chris Packham. SOLD OUT.
May 2007
Photographic Days. Due to a high level of demand, we have opened an extra date on 23rd July. Click here for details.
Apr 2007
BBC Wildlife magazine is this month holding a Masterclass Readers' photo of the month featuring images taken in British Zoos. If you have taken any great shots at the Trust please think about entering them in this competition. To enter log onto www.bbcwildlifemagazine.com and click on photo Masterclass, then follow the instructions to upload your images. Closing date; Friday 11th May. Don't forget if you are not successful in this competition then enter your images into the Hawk Conservancy Trust photographic competition.
Mar 2007
The Hawk Conservancy Trust is Recruiting. The Hawk Conservancy Trust is looking for more members for its team.
2007 Photographic competition is announced. Details here
Feb 2007
New for the 2007 season, and being launched at Easter 2007, the 3.30pm - Woodland Owls and Hawks display. A new 35 minute unique display that puts the visitor in the very middle of the action and at the heart of a bird of prey's native habitat. The spotlight is turned on the birds' breathtaking agility as the owls and hawks swoop and dive through the trees above and around visitors who are seated within a woodland setting.
Jan 2007
BBC South Today is to broadcast a feature about the Trust re-homing 20 vultures that had been confiscated by Italian authorities. Broadcast date Friday 12th January 7.30pm. Click here to see the press release
Charity Challenge, win a national poster campaign
