<%@LANGUAGE="JAVASCRIPT"%> <% var Rsdecade = "1931"; if(String(Request.QueryString("decade")) != "undefined"){ Rsdecade = String(Request.QueryString("decade")); Rsdecade=Rsdecade.replace(/_/g," ")} var Rsmanuf = "VINCENT"; if(String(Request.QueryString("manuf")) != "undefined"){Rsmanuf = String(Request.QueryString("manuf")); Rsmanuf=Rsmanuf.replace(/_/g," ")} //var RsCollection__leetest2 = "Heritage"; //if(String(Request.QueryString("category")) != "undefined"){ RsCollection__leetest2 =//////// //String(Request.QueryString("category"));} %> <% var RsCollection = Server.CreateObject("ADODB.Recordset"); RsCollection.ActiveConnection = "Provider=SQLOLEDB;Server=localhost;uid=museum;pwd=Zb54nJKp;database=museum"; if(String(Request.QueryString("manuf")) != "undefined"){ RsCollection.Source = "SELECT Manufacturer, ID, Year, Model FROM final_collection WHERE Manufacturer='"+ Rsmanuf.replace(/'/g, "''") + "' order by Year" ;} if(String(Request.QueryString("decade")) != "undefined"){ RsCollection.Source = "SELECT Manufacturer, ID,Year, Model FROM final_collection WHERE Year-'"+ Rsdecade.replace(/'/g, "''") + "' > 0 and Year-'"+ Rsdecade.replace(/'/g, "''") + "' <10 order by Year" ;} RsCollection.CursorType = 0; RsCollection.CursorLocation = 2; RsCollection.LockType = 3; RsCollection.Open(); var RsCollection_numRows = 0; %><% var Repeat1__numRows = -1; var Repeat1__index = 0; RsCollection_numRows += Repeat1__numRows; %> <% // *** Recordset Stats, Move To Record, and Go To Record: declare stats variables // set the record count var RsCollection_total = RsCollection.RecordCount; // set the number of rows displayed on this page if (RsCollection_numRows < 0) { // if repeat region set to all records RsCollection_numRows = RsCollection_total; } else if (RsCollection_numRows == 0) { // if no repeat regions RsCollection_numRows = 1; } // set the first and last displayed record var RsCollection_first = 1; var RsCollection_last = RsCollection_first + RsCollection_numRows - 1; // if we have the correct record count, check the other stats if (RsCollection_total != -1) { RsCollection_numRows = Math.min(RsCollection_numRows, RsCollection_total); RsCollection_first = Math.min(RsCollection_first, RsCollection_total); RsCollection_last = Math.min(RsCollection_last, RsCollection_total); } %> <% // *** Recordset Stats: if we don't know the record count, manually count them if (RsCollection_total == -1) { // count the total records by iterating through the recordset for (RsCollection_total=0; !RsCollection.EOF; RsCollection.MoveNext()) { RsCollection_total++; } // reset the cursor to the beginning if (RsCollection.CursorType > 0) { if (!RsCollection.BOF) RsCollection.MoveFirst(); } else { RsCollection.Requery(); } // set the number of rows displayed on this page if (RsCollection_numRows < 0 || RsCollection_numRows > RsCollection_total) { RsCollection_numRows = RsCollection_total; } // set the first and last displayed record RsCollection_last = Math.min(RsCollection_first + RsCollection_numRows - 1, RsCollection_total); RsCollection_first = Math.min(RsCollection_first, RsCollection_total); } %><% var MM_paramName = ""; %> <% // *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters // create the list of parameters which should not be maintained var MM_removeList = "&index="; if (MM_paramName != "") MM_removeList += "&" + MM_paramName.toLowerCase() + "="; var MM_keepURL="",MM_keepForm="",MM_keepBoth="",MM_keepNone=""; // add the URL parameters to the MM_keepURL string for (var items=new Enumerator(Request.QueryString); !items.atEnd(); items.moveNext()) { var nextItem = "&" + items.item().toLowerCase() + "="; if (MM_removeList.indexOf(nextItem) == -1) { MM_keepURL += "&" + items.item() + "=" + Server.URLencode(Request.QueryString(items.item())); } } // add the Form variables to the MM_keepForm string for (var items=new Enumerator(Request.Form); !items.atEnd(); items.moveNext()) { var nextItem = "&" + items.item().toLowerCase() + "="; if (MM_removeList.indexOf(nextItem) == -1) { MM_keepForm += "&" + items.item() + "=" + Server.URLencode(Request.Form(items.item())); } } // create the Form + URL string and remove the intial '&' from each of the strings MM_keepBoth = MM_keepURL + MM_keepForm; if (MM_keepBoth.length > 0) MM_keepBoth = MM_keepBoth.substring(1); if (MM_keepURL.length > 0) MM_keepURL = MM_keepURL.substring(1); if (MM_keepForm.length > 0) MM_keepForm = MM_keepForm.substring(1); %>

Below are the results of the search for <% if(String(Request.QueryString("manuf")) != "undefined"){ Response.write("the manufacturer " + Rsmanuf) } if(String(Request.QueryString("decade")) != "undefined"){ Response.write("the decade beginning in the year " + Rsdecade) } %>

To view further information about a vehicle and see a photograph, click on the relevant details link below

Showing results <%=(RsCollection_first)%>-<%=(RsCollection_last)%> of   <%=(RsCollection_total)%>
<% while ((Repeat1__numRows-- != 0) && (!RsCollection.EOF)) { %> <% Repeat1__index++; RsCollection.MoveNext();} %><%RsCollection.Close()%>
Year Manufacturer  Model  
<%=(RsCollection.Fields.Item("Year").Value)%> <%=(RsCollection.Fields.Item("Manufacturer").Value)%>  <%=(RsCollection.Fields.Item("Model").Value)%> ">Details

 
 
Home
Search
Endeavour
For Sale
Gifts
Links
Stondon Museum And Garden Centre
Station Road, Lower Stondon, Henlow, Beds. SG16 6JN
Tel: 01462 850339 email: transportmuseum@supanet.com