<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%> <% var rsSubCats__MMColParam = "1"; if (String(Request.QueryString("CatId")) != "undefined" && String(Request.QueryString("CatId")) != "") { rsSubCats__MMColParam = String(Request.QueryString("CatId")); } %> <% var rsSubCats = Server.CreateObject("ADODB.Recordset"); rsSubCats.ActiveConnection = MM_task_STRING; rsSubCats.Source = "SELECT * FROM SubCats WHERE CatId = "+ rsSubCats__MMColParam.replace(/'/g, "''") + ""; rsSubCats.CursorType = 0; rsSubCats.CursorLocation = 2; rsSubCats.LockType = 1; rsSubCats.Open(); var rsSubCats_numRows = 0; %> <% var rsImage__MMColParam = "1"; if (String(Request.QueryString("CatId")) != "undefined" && String(Request.QueryString("CatId")) != "") { rsImage__MMColParam = String(Request.QueryString("CatId")); } %> <% var rsImage = Server.CreateObject("ADODB.Recordset"); rsImage.ActiveConnection = MM_task_STRING; rsImage.Source = "SELECT * FROM Cats WHERE CatId = "+ rsImage__MMColParam.replace(/'/g, "''") + ""; rsImage.CursorType = 0; rsImage.CursorLocation = 2; rsImage.LockType = 1; rsImage.Open(); var rsImage_numRows = 0; %> <% var Repeat1__numRows = -1; var Repeat1__index = 0; rsSubCats_numRows += Repeat1__numRows; %> <% 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); %> Stuart Waters Services
<%=(rsImage.Fields.Item("DatDescription").Value)%>

Please click on the Product Range you require:

 
<% while ((Repeat1__numRows-- != 0) && (!rsSubCats.EOF)) { %> <% Repeat1__index++; rsSubCats.MoveNext(); } %>
"><%=(rsSubCats.Fields.Item("SubCatDesc").Value)%>  
">
 
<% rsSubCats.Close(); %> <% rsImage.Close(); %>