logo pyrenees65
Esquí ESQUI
Termalismo TERMALISMO
Alojamiento ALOJAMIENTOS
Ocio OCIO
escapadas ESCAPADAS
comercioe COMERCIO
Restauración RESTAURACION
Inmobiliaria INMOBILIARIA
Servicios SERVICIOS
Escríbanos
Sitio Local
El Pays Toy
Luz Saint Sauveur, Luz Ardiden, Gavarnie, Barèges-Tourmalet
Pico de Midi de Bigorre.
   volver Inicio / Comercio
Comercio Comercio


<% Dim dcnDB 'As ADODB.connection Dim recordset 'As ADODB.Recordset Dim Pays, granderegion, region, departement, vallee ' 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%>
Seleccione sus criterios de búsqueda
<%Set recordset = server.createObject("ADODB.recordset") SQL = "SELECT DISTINCT type1 from commerces 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 ville from commerces WHERE (Pays='"&Pays&"') and (granderegion='"&granderegion&"') and (region='"®ion&"') and departement=" & departement recordset.Open SQL, dcnDB, 1, 1%> <%recordset.Close set recordset = nothing dcnDB.Close Set dcnDB = nothing%>
Comercio
Pueblo