Whitsand Bay & The Rame Peninsula Holiday Cottages | self catering Apartments & Holiday cottages in The Rame Peninsula @ Cornwall Online

Holiday Cottages in Whitsand Bay The Rame Peninsula
Self-catering, Camping & Holiday Cottages in The Rame Peninsula

<% sql = "SELECT TOP 200 * From Clients WHERE (([Local Area] Like '%rame%' OR [Local Area] Like '%saltash%' OR [Local Area] Like '%whitsand%') AND [Accommodation_Type] Like '%self%' AND [Show] NOT LIKE '%Hide%'AND [HolidayAgency] NOT LIKE '%') " sql = sql & " ORDER BY rnd(INT(NOW*id)-NOW*id)" %> <%' Open Connection dim objConn dim objRec set objConn = Server.CreateObject("ADODB.Connection") set objRec = Server.CreateObject("ADODB.Recordset") ' set the cursor location for record count objRec.CursorLocation = 3 objConn.Open "Driver={Microsoft Access driver (*.mdb)};DBQ=d:\wwwdata\pub-domains\www.westcountry-online.com\accommodationdata\database\accommodationdata.mdb" objRec.Open sql, objConn 'objRec.Open "Clients", objConn, 0,1,2 %>