<%@ Language=JavaScript %> <% var iImage = Request("image"); var strSource = Request("source"); %> <% var oRecordset = Server.CreateObject("ADODB.Recordset"); oRecordset.Open("SELECT ID, BoatName, Type, Built, Description, Construction, Length, Engine, Equipment, Performance, Accomodation, Electric, Lying, Price, Sails, Instruments, Galley FROM tblBoats WHERE ID = " + iImage, oConnection, 1, 3); var strValue = oRecordset.Fields("Construction").Value; if (!oRecordset.BOF) { %> Boat Information - <%=oRecordset.Fields("Type").Value%> " />
St. Peter's
Marina
Boat Info
   
<%=strLinks%>

St Peter's Marina
St Peter's Basin
Newcastle upon Tyne
NE6 1HX
T: 0191 265 4472
F: 0191 276 2618
<%=oRecordset.Fields("BoatName").Value%>

<% var oPhotoRecordset = Server.CreateObject("ADODB.Recordset"); oPhotoRecordset.Open("SELECT ID FROM tblPictures WHERE BoatID = " + iImage, oConnection); if (!oPhotoRecordset.BOF) { while (!oPhotoRecordset.EOF) { %> .jpg" border="0" align="middle">  <% oPhotoRecordset.MoveNext(); } } oPhotoRecordset.Close(); oPhotoRecordset = null; } if (oRecordset.Fields("Description").Value != null && oRecordset.Fields("Description").Value != "") { %>

<%=oRecordset.Fields("Description").Value%>

<% } %> <% if (oRecordset.Fields("Type").Value != null && oRecordset.Fields("Type").Value != "") { %> <% } %> <% if (oRecordset.Fields("Built").Value != null && oRecordset.Fields("Built").Value != "") { %> <% } %> <% if (oRecordset.Fields("Construction").Value != null && oRecordset.Fields("Construction").Value != "") { %> <% } %> <% if (oRecordset.Fields("Length").Value != null && oRecordset.Fields("Length").Value != "") { %> <% } %> <% if (oRecordset.Fields("Engine").Value != null && oRecordset.Fields("Engine").Value != "") { %> <% } %> <% if (oRecordset.Fields("Equipment").Value != null && oRecordset.Fields("Equipment").Value != "") { %> <% } %> <% if (oRecordset.Fields("Performance").Value != null && oRecordset.Fields("Performance").Value != "") { %> <% } %> <% if (oRecordset.Fields("Accomodation").Value != null && oRecordset.Fields("Accomodation").Value != "") { %> <% } %> <% if (oRecordset.Fields("Electric").Value != null && oRecordset.Fields("Electric").Value != "") { %> <% } %> <% if (oRecordset.Fields("Lying").Value != null && oRecordset.Fields("Lying").Value != "") { %> <% } %> <% if (oRecordset.Fields("Sails").Value != null && oRecordset.Fields("Sails").Value != "") { %> <% } %> <% if (oRecordset.Fields("Instruments").Value != null && oRecordset.Fields("Instruments").Value != "") { %> <% } %> <% if (oRecordset.Fields("Galley").Value != null && oRecordset.Fields("Galley").Value != "") { %> <% } %> <% if (oRecordset.Fields("Price").Value != null) { %> <% } %>
Type: <%=oRecordset.Fields("Type").Value%>
Built: <%=oRecordset.Fields("Built").Value%>
Construction: <%=oRecordset.Fields("Construction").Value%>
Length: <%=oRecordset.Fields("Length").Value%>
Engine: <%=oRecordset.Fields("Engine").Value%>
Equipment: <%=oRecordset.Fields("Description").Value%>
Performance: <%=oRecordset.Fields("Performance").Value%>
Accomodation: <%=oRecordset.Fields("Accomodation").Value%>
Electric: <%=oRecordset.Fields("Electric").Value%>
Lying: <%=oRecordset.Fields("Lying").Value%>
Sails: <%=oRecordset.Fields("Sails").Value%>
Instruments: <%=oRecordset.Fields("Instruments").Value%>
Galley: <%=oRecordset.Fields("Galley").Value%>
Price: £ <%=oRecordset.Fields("Price").Value%>
<% oRecordset.Close(); oRecordset = null; %> [Enquire]