% IntHotelId = request.querystring("Name") IntFeatureRangeId = -1 sql ="SELECT * FROM region WHERE countryid = 1 ORDER BY regionname ASC" set RsRegionSelector = ObjConnection.execute(sql) %>
Region:
Town:
Type of Room Required:
Tariff:
Rate: (No more than) £
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 %>