%
id=Request("id")
accessdb="http://www.wigstonwolery.free-online.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 Hainaut (Henegouwen, Hennegau) Province,
This French speaking Province known as the Green Province lies to the south and south west of the Bruxelles bordering with France. The Provincial Town is Mons.
From our Database we have found these Tourist Information Links to other websites Beloeil ... Coup d'oeil sur Beloeil Beloeil Castle ... Bienvenue sur le site Beloeil Brugelette ... Charleroi ... Bienvenue sur le site officiel de la ville de Charleroi Gerpinnes ... Syndicat d'Initiative de Gerpinnes Hainaut ... site officiel de la Province de Hainaut Mons ... Site officiel de la ville de Mons Parc Paradisio ... Cambron-Casteau - Bienvenue sur le site web officiel de Paradisio Soignies ... Tournai ... Site officiel de la Ville de Tournai