%
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 - France: Pictures of 95 Val d'Oise Department, Paris and the Ile de France
From our Database we have found these Tourist Information Links to other websites Auvers-sur-Oise ... Bienvenue a Auvers-sur-Oise Enghien-les-Bains ... Le site de la ville d'Enghien les bains L'Isle-Adam ... Bienvenue sur le site officiel de la Mairie de l'Isle-Adam. Val d'Oise ... Comite du Tourisme et des Loisirs du Val d'Oise