%@ 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 ================
%>
WineBiz.co.za / Suppliers Guide
WineBiz
Suppliers Guide
The
WineBiz Suppliers Guide is an annual publication and are used as a "phone
book" in the wine industry.
The publication showed tremendious growth since its luanch in 2000 and
the 2005 issue will now be distributed to wineries in the new world.
We are spreading our wings and will distribute the 2005 guide not only
in South Africa but also in Australia, New Zealand, South and Norhern
America.
The South African edition will still contain a special Local
suppliers sections.
Our readers use the guide as a telephone directory when purchasing
supplies for their wineries. Your listing will list all your
agents / offices in the new world so that decision makers can
easily find the nearest contact for your products. (Sample International
listing below, spread over 2 pages)
The guide is printed on high quality paper to ensure that it
is durable during its 12 month life span.
In addition to valuable market exposure through this guide,
all participating suppliers also enjoy free Internet
coverage on our web site www.winebiz.co.za. Be sure to list
your company in the next issue.
(International
Listing on 2 pages. Left page contains your advertisement while
the left contains all the contact information. Click on image
for larger format)
Publication
Specs
Next
Publication Date:
March
2005
Duration:
March
- December 2005
Booking
Deadline:
31
January 2005
Material
Deadline:
31
January 2005
Cover
Price:
Free
of Charge- Not for Sale
International Copies - Postage payable
Target
Audience:
Decision
makers in the New World Wine Industry.
Wine Farmers, Wine Makers & Production Managers, Purchase
Managers, Marketing Managers, Financial Managers.
Distribution
15,000
copies (5,000 South Africa, 10,000 International)