logo pyrenees65
Ski SKI
spas SPAS
Accomodation ACCOMMODATION
Leisure LEISURE
discovery DISCOVERY
shops SHOPS
Restaurants RESTAURANTS
Real estate REAL ESTATE
Services SERVICES
Diary DIARY
Write-us
Local Site
Toy Country
Luz Saint Sauveur, Luz Ardiden, Gavarnie, Barèges-Tourmalet
Pic du Midi de Bigorre.
   return Home / Accommodation - Rentals
Accommodation - Rentals Accommodation - Rentals


<% Dim dcnDB 'As ADODB.connection Dim recordset 'As ADODB.Recordset Dim SQL, Pays, granderegion, region, departement, vallee, type1, type2, terrain, organisme, qualite, personnesmini, personnesmaxi, nbrechambres, nom, village, telephone, lien ' As ADODB.String Set dcnDB = server.createObject("ADODB.Connection") dcnDB.Open "am12972" pays = "France" granderegion = "Pyrénées" region = "Midi-Pyrénées" departement = 65%>
Select your search criteria
<%Set recordset = server.createObject("ADODB.recordset") SQL = "SELECT DISTINCT type1 from hebergements WHERE (pays='"&pays&"') and (granderegion='"&granderegion&"') and (region='"®ion&"') and departement=" & departement recordset.Open SQL, dcnDB, 1, 1%> <%recordset.Close set recordset = nothing%> <%Set recordset = server.createObject("ADODB.recordset") SQL = "SELECT DISTINCT village from hebergements WHERE (pays='"&pays&"') and (granderegion='"&granderegion&"') and (region='"®ion&"') and departement=" & departement recordset.Open SQL, dcnDB, 1, 1%> <%recordset.Close set recordset = nothing%> <%Set recordset = server.createObject("ADODB.recordset") SQL = "SELECT DISTINCT personnesmini from hebergements WHERE (pays='"&pays&"') and (granderegion='"&granderegion&"') and (region='"®ion&"') and departement=" & departement & " ORDER BY personnesmini" recordset.Open SQL, dcnDB, 1, 1%> <%recordset.Close set recordset = nothing%> <%Set recordset = server.createObject("ADODB.recordset") SQL = "SELECT DISTINCT nbrechambres from hebergements WHERE (pays='"&pays&"') and (granderegion='"&granderegion&"') and (region='"®ion&"') and departement=" & departement & " ORDER BY nbrechambres" recordset.Open SQL, dcnDB, 1, 1%> <%recordset.Close set recordset = nothing dcnDB.Close Set dcnDB = nothing%>
type of accommodation
Village
Mininum number of people
Minimum number of rooms