<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%> <% var rsHeader__MMColParam = "1"; if (String(Request.QueryString("SubCatId")) != "undefined" && String(Request.QueryString("SubCatId")) != "") { rsHeader__MMColParam = String(Request.QueryString("SubCatId")); } %> <% var rsHeader = Server.CreateObject("ADODB.Recordset"); rsHeader.ActiveConnection = MM_task_STRING; rsHeader.Source = "SELECT * FROM SubCats WHERE SubCatId = "+ rsHeader__MMColParam.replace(/'/g, "''") + ""; rsHeader.CursorType = 0; rsHeader.CursorLocation = 2; rsHeader.LockType = 1; rsHeader.Open(); var rsHeader_numRows = 0; %> <% var rsProdInfo__MMColParam = "1"; if (String(Request.QueryString("SubCatId")) != "undefined" && String(Request.QueryString("SubCatId")) != "") { rsProdInfo__MMColParam = String(Request.QueryString("SubCatId")); } %> <% var rsProdInfo = Server.CreateObject("ADODB.Recordset"); rsProdInfo.ActiveConnection = MM_task_STRING; rsProdInfo.Source = "SELECT * FROM Details WHERE SubCatId = "+ rsProdInfo__MMColParam.replace(/'/g, "''") + ""; rsProdInfo.CursorType = 0; rsProdInfo.CursorLocation = 2; rsProdInfo.LockType = 1; rsProdInfo.Open(); var rsProdInfo_numRows = 0; %> <% var Repeat1__numRows = -1; var Repeat1__index = 0; rsProdInfo_numRows += Repeat1__numRows; %> <% var Repeat1__numRows = -1; var Repeat1__index = 0; rsHeader_numRows += Repeat1__numRows; %> Stuart Waters Services
<% if (!rsProdInfo.EOF || !rsProdInfo.BOF) { %> <%=(rsHeader.Fields.Item("SubCatDesc").Value)%> <% } // end !rsProdInfo.EOF || !rsProdInfo.BOF %>
<% if (!rsProdInfo.EOF || !rsProdInfo.BOF) { %> <% while ((Repeat1__numRows-- != 0) && (!rsProdInfo.EOF)) { %>
<%=(rsHeader.Fields.Item("SubCatDesc").Value)%> - <%=(rsProdInfo.Fields.Item("PartNo").Value)%> <% if (!rsProdInfo.EOF || !rsProdInfo.BOF) { %> <% } // end !rsProdInfo.EOF || !rsProdInfo.BOF %> ','Image','scrollbars=yes,resizable=yes,width=375,height=600')">" border="0">
<%=(rsProdInfo.Fields.Item("Details").Value)%>

 
<% Repeat1__index++; rsProdInfo.MoveNext(); } %> <% } // end !rsProdInfo.EOF || !rsProdInfo.BOF %>

 

 
<% rsHeader.Close(); %> <% rsProdInfo.Close(); %>