<%@ Language="JavaScript" %> <% function GetList(){ var sqlList='SELECT AccountUsers.CompanyName AS CompanyName'; sqlList+=',AccountUsers.CompanyContactPerson AS CompanyContactPerson'; sqlList+=',AccountUsers.CompanyEmail AS CompanyEmail'; sqlList+=',AccountUsers.CompanyTelephone AS CompanyTelephone'; sqlList+=',AccountUsers.CompanyFax AS CompanyFax'; sqlList+=',AccountUsers.CompanyWebSite AS WebAddress'; sqlList+=',CountryCode.Description AS CountryName'; sqlList+=',RspDetail.RspListCode AS ListCode'; sqlList+=',RspDetail.Description AS RspDesc'; sqlList+=',RspTypeCode.Description AS ServiceType'; sqlList+=' FROM AccountUsers'; sqlList+=' INNER JOIN ((RspDetail INNER JOIN RspList'; sqlList+=' ON RspDetail.RspListCode = RspList.RspDetailCode)'; sqlList+=' INNER JOIN RspTypeCode'; sqlList+=' ON RspList.RspTypeCode = RspTypeCode.RspTypeCode)'; sqlList+=' ON AccountUsers.AccountNumber = RspDetail.ListAccount'; sqlList+=' INNER JOIN CountryCode'; sqlList+=' ON RspDetail.CountryCode = CountryCode.CountryCode'; sqlList+=' WHERE (((RspDetail.RspListCode)=\''+RspDetail+'\'))'; OpenRecordSet('rsList',sqlList,'Conn'); } // ================ Begin ================ var LoginCookie=new String(Request.Cookies("CLoginGood")); var LoginVars=new Array(); LoginVars=LoginCookie.split("#"); var LoginGood=LoginVars[0] var AccountNumber=LoginVars[1]; var RspDetail=Request("List"); OpenDatabase('Conn'); var Button=Request("Button"); if (Button=="Back"){ Response.Redirect('rsp.asp'); } if (ParamGood(RspDetail)){ GetList(); } else{ Response.Redirect('rsp.asp'); } // ================ End ================ %> Stellenbosch and its Wine Routes

Home




Stellenbosch & Its Wine Routes Brochure 2005

Bookings for 2005 Issue now closed.
Info on 2006 Issue will be posted here early 2005

 

Maps for advertiser comments
Please note that small accommodation listings and text listings (ads of R1100+VAT and less) are not indicated on the maps. As previously, we only list 1/8th page and bigger advertisers on our maps.
Stellenbosch Wine Routes Map

Stellenbosch Town Center Map

Stellenbosch Town Map

Please call us with any major changes on 0861 2 22335.