<% IntHotelId = request.querystring("Name") IntFeatureRangeId = -1 sql ="SELECT * FROM region WHERE countryid = 1 ORDER BY regionname ASC" set RsRegionSelector = ObjConnection.execute(sql) %>





Advanced Accommodation Search

Region:

Town:

Type of Room Required:

Tariff:

Rate: (No more than) £


More Options

You can narrow down your search by selecting the features that you require:

<% sql ="select * from featureranges as fr inner join features as f on f.featurerangeid = fr.featurerangeid order by featurerangedescription, featuredescription" set RsResult = ObjConnection.execute(sql) IntFeatureRangeId = -1 do while not RsResult.eof if int(RsResult("featurerangeid")) <> IntFeatureRangeId and IntFeatureRangeId <> -1 then %>

<% end if if int(RsResult("featurerangeid")) <> IntFeatureRangeId then IntFeatureRangeid = RsResult("featurerangeid") %>

<%= RsResult("featurerangedescription") %>
 <% end if %>
<%= Rsresult("featuredescription") %>: " name="feature" />
<% RsResult.movenext loop %>

<% RsRegionSelector.Close() %>