<%
id=Request("id")
accessdb="http://www.a-motorhome-on-tour.co.uk/france.mdb"
myDSN = "Driver={Microsoft Access Driver (*.mdb)};"
myDSN = myDSN & "DBQ=" & Server.MapPath(accessdb)
Query="SELECT * from locations WHERE departmentid LIKE '%"
Query= Query & Request("id") & "%'"
Query = Query & " ORDER BY location"
Set DataConn = Server.CreateObject("ADODB.Connection")
DataConn.open(myDSN)
Set RSloc = DataConn.execute(Query)
Querydept="SELECT * from departments WHERE departmentid LIKE '%"
Querydept= Querydept & Request("id") & "%'"
Querydept = Querydept & " ORDER BY departmentname"
Set RSdept = DataConn.execute(Querydept)
thisregionid= RSdept("regionid")
Queryreg="SELECT * from regions WHERE regionid LIKE '%"&thisregionid&"%'"
Set RSreg = DataConn.execute(Queryreg)
thiscountryid= RSreg("countryid")
Querycty="SELECT * from countries WHERE countryid LIKE '%"&thiscountryid&"%'"
Set RScty = DataConn.execute(Querycty)
%>
A Motorhome on Tour - Belgium: Pictures of Brabant Wallon Province,
This French speaking Province lies to the south of the Bruxelles. The Provincial town is Wavre..
From our Database we have found these Tourist Information Links to other websites Brabant-Wallon ... Bienvenue sur le site de la jeune Province du Brabant wallon Braine-l'Alleud ... Commune de Braine-l'Alleud - Site officiel Brabant Wallon Ittre ... Le Syndicat d'Initiative et de Tourisme d'Ittre vous souhaite la bienvenue Lasne ... Nivelles ... Ville de Nivelles Rixensart ... Villers-la-Ville Abbey ... Site officiel de l'Abbaye de Villers-la-Ville Walibi ... Recreation Park at Wavre Waterloo 1815 ... Waterloo 1815 Le centre du Visiteur, The Visitors Center Wavre ... WAVRE: Accueil
