<%
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 - France: Pictures of 71 Saone et Loire Department, Bourgogne
From our Database we have found these Tourist Information Links to other websites Autun Office de Tourisme ... Brancion ... 10th 12th and 15th century castle of the Dukes of Burgundy and King of France etc.. Chalon-sur-Saone ... Office de Tourisme de Chalon sur Saone Cluny ... Site officiel de l'Office de Tourisme de Cluny Le Creusot ... Office de Tourisme Chateau de la Verrerie - 71200 Le Creusot Macon ... Bienvenue sur le site portail de services en ligne de Macon et sa region Saint-Gengoux ... Saint-Gengoux-le-National Tournus ... L'equipe de l'Office de Tourisme de Tournus vous souhaite la bienvenue sur son espace internet.
