Search for UK hotel and guest house accommodation online with www.travelaround.co.uk
 
Home | Scotland
Counties and Towns in England
Counties and Towns in Wales
Counties and Towns in Scotland

<% 'Declare variables Dim oConnection, oRecordset, sSQL, iSpan, iNumlinks Dim oRSCountLinks, oRSNewLinks Dim iCategoryID, sCategoryName, sCategoryDescription 'store the desired SQL statement in a variable sSQL="SELECT * FROM tblCategory WHERE ACTIVE='Y'" 'create an instance of the ADO connection and recordset objects Set oConnection = Server.CreateObject ("ADODB.Connection") Set oRecordset = Server.CreateObject ("ADODB.Recordset") 'open the connection to the database oConnection.Open(sConnString) 'open the recordset object and execute the SQL oRecordset.Open sSQL,oConnection 'we will use the span variable to keep the number of category columns to 2 iSpan=0 'loop through the categories Do while not oRecordset.eof iSpan=iSpan + 1 If iSpan>2 then Response.write "" iSpan=1 End If iCategoryID=oRecordset("CategoryID") sCategoryName=oRecordset("CategoryName") sCategoryDescription=oRecordset("CategoryDescription") %>
 Argyll and Bute Accommodation

 Argyll and Bute contains the following towns

Achahois,h Appin, Ardbe,g Arden, Ardfern, Ardlui, Ardrishaig, Arduaine, Arrochar, Barcaldine, Bellochantu,y Benderloch, Bonawe, Bowmore, Cairndow, Cardross, Carradale, Clachan, Cairnbaan, Campbeltown, Cladich, Clynder, Colintraive, Connel, Coulport, Cove, Craighouse, Craignure, Craobh Haven, Crarae, Crinan, Dalavich, Dalmally, Druimdrishaig, Drumlemble, Dunbeg, Dunoon, Ford, Furnace, Garelochhead, Glenbar,r Grogport, Helensburgh, Innellan, Inveraray, Inverbeg, Inveruglas, Kames, Keillmore, Kilberry, Kilchenzie, Kilcreggan, Kilmartin, Kilmore, Kilmun, Kilninver, Kilmelfort, Loch Awe, Lochgair, Lochgilphead, Lochgoilhead, Luss, Machrihanish, Millhouse, Minard, Muasdale, Oban, Ormsary, Otter Ferry, Peninver, Portavadie, Port Askaig, Port Bannatyne, Port Charlotte, Port Ellen, Portincaple, Portnahaven, Rhu, Rosneath, Rothesay, Saddell, Salen, Sandbank, Shandon, Skipness, Southend, Stewarton, Strachur, Succoth, Tarbert, Tarbet, Tayinloan, Taynuilt, Tayvallich, Tighnabruaich, Tobermory, Torinturk, Toward, Whistlefield, Whitehouse

 Places of interest in Argyll and Bute
  • Argyll Forest Park
  • Carrick Castle
  • Cruachan Dam Hydroelectric plant
  • Fincharn Castle
  • Kilchurn Castle
  • Lachlan Castle
  • Younger Botanic Garden Benmore

 Links and Resources
 

   
 
Copyright © Shops Online Ltd. All rights reserved