<% dim dbc dim DistilleryRS dim SQLquery dim DistilleryID dim RegionID dim BottlerID dim StyleID dim DistilleryName dim RegionName dim HTMLoutput dim cname HTMLoutput = "" shopopendatabase dbc set DistilleryRS = Server.CreateObject("ADODB.Recordset") SQLquery = "SELECT distilleryname, regionname, bottlername, typename FROM products WHERE ccode IN (SELECT MAX(ccode) as ccode FROM products GROUP BY distilleryname) ORDER BY distilleryname" DistilleryRS.Open SQLquery, dbc, 0 DistilleryName = "" DistilleryID = "" RegionID = "" BottlerID = "" StyleID = "" do while not DistilleryRS.EOF DistilleryName = DistilleryRS("distilleryname") DistilleryID = DistilleryRS("distilleryname") RegionID = DistilleryRS("regionname") StyleID = DistilleryRS("typename") if DistilleryName <> "" then HTMLoutput = HTMLoutput & "" & DistilleryName ' & ", " & cname end if DistilleryRS.movenext() loop %> Select a Distillery... --------------------- <%= HTMLoutput %>

Home Browse Search Basket Personalised labels Checkout My account

WEB SITE LINKS
	Clubs & Societies Scotch Malt Whisky Society - Informal and friendly malt whisky appreciation society Malt whisky Association - Malt whisky association run by the Master of Malt. Single Malt Scotch Whisky (Yahoo club) - A full featured and friendly whisky discussion forum. Hammarby Clan Whisky Best Whiskies - Specialist supplier or Rare Vintage and Limited Edition Malt Whiskies   Distilleries Glenmorangie Distillery  -  A rather unique website with a lot of information buried inside it. Glengoyne Distillery  - A solid source of information on the distillery and the whiskies it produces. The Balvenie - A very friendly, informative site with everything you might want to know about this wonderful malt.   Independent Bottlers Signatory Vintage Scotch Whisky Company - A family owned business who have recently bought the Edradour distillery. Gordon & MacPhail  -  Perhaps Scotland's largest independent bottler   Distilleries Inver House Distillers  -  A good source of information on a range of whiskies and the distilleries that produce them.   Auction Sites Whisky Bay -   Personal Sites Home page of Jan Langenberg -  Links, definitions of some whisky terms, and a collection of miniature label pictures. HIVESBEE US site listing many rare and interesting malts   Scottish Products Rannoch Smokery - Look here for some of the finest wild venison and smoked gourmet meats in the land.   Other non Whisky Sites Avenue35  - Badminton on court and on line ATOM Supplies  - Genuine and compatible ink jet cartridges, laser toners and media all at Competitive prices Best of British Mail Order  - Companies, world-wide, selling British products and services by mail-order. alkis.net - A large range of alcohol related resources (News, Jokes, Links etc...), a must visit for anyone who enjoys alcoholic drinks and drinking. Celtic Life - A directory of All Things Celtic, around the world. - everything about London dining. BlueWine.com - Search engine about French wine, California wine country, Italian wine, wine tasting, vineyard, cellar, wine making, red wine, Whisky & Scotch, beer, Zinfandel, Merlot, Chardonnay, Cabernet Sauvignon, Malbec, Champagne, port wine...

Home | Help | Delivery Times | Terms & Conditions | Privacy Policy
Tel: 0207 870 9674   Fax: 01892 667 525   shop@masterofmalt.com	© Master of Malt 2005