%@LANGUAGE="VBSCRIPT"%> <% Dim rsProducts Dim rsProducts_numRows Set rsProducts = Server.CreateObject("ADODB.Recordset") rsProducts.ActiveConnection = adoCon rsProducts.Source = "SELECT * FROM Stock WHERE Category='Item' ORDER BY ID ASC" rsProducts.CursorType = 0 rsProducts.CursorLocation = 2 rsProducts.LockType = 1 rsProducts.Open() rsProducts_numRows = 0 %> <% Dim rsBoxedProducts Dim rsBoxedProducts_numRows Set rsBoxedProducts = Server.CreateObject("ADODB.Recordset") rsBoxedProducts.ActiveConnection = adoCon rsBoxedProducts.Source = "SELECT * FROM Stock WHERE Category = 'Pack' ORDER BY ID" rsBoxedProducts.CursorType = 0 rsBoxedProducts.CursorLocation = 2 rsBoxedProducts.LockType = 1 rsBoxedProducts.Open() rsBoxedProducts_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 rsProducts_numRows = rsProducts_numRows + Repeat1__numRows %> <% Dim Repeat2__numRows Dim Repeat2__index Repeat2__numRows = -1 Repeat2__index = 0 rsBoxedProducts_numRows = rsBoxedProducts_numRows + Repeat2__numRows %>