%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% Dim Tipo4 Dim Tipo4_numRows Set Tipo4 = Server.CreateObject("ADODB.Recordset") Tipo4.ActiveConnection = MM_Sirius_STRING Tipo4.Source = "SELECT Tipo FROM Tipo WHERE TipoID = 4" Tipo4.CursorType = 0 Tipo4.CursorLocation = 2 Tipo4.LockType = 1 Tipo4.Open() Tipo4_numRows = 0 %> <% Dim Prices4 Dim Prices4_numRows Set Prices4 = Server.CreateObject("ADODB.Recordset") Prices4.ActiveConnection = MM_Sirius_STRING Prices4.Source = "SELECT Articulos, Precio FROM DivPrices WHERE TipoID = 4" Prices4.CursorType = 0 Prices4.CursorLocation = 2 Prices4.LockType = 1 Prices4.Open() Prices4_numRows = 0 %> <% Dim Tipo5 Dim Tipo5_numRows Set Tipo5 = Server.CreateObject("ADODB.Recordset") Tipo5.ActiveConnection = MM_Sirius_STRING Tipo5.Source = "SELECT Tipo FROM Tipo WHERE TipoID = 5" Tipo5.CursorType = 0 Tipo5.CursorLocation = 2 Tipo5.LockType = 1 Tipo5.Open() Tipo5_numRows = 0 %> <% Dim Prices5 Dim Prices5_numRows Set Prices5 = Server.CreateObject("ADODB.Recordset") Prices5.ActiveConnection = MM_Sirius_STRING Prices5.Source = "SELECT Articulos, Precio FROM DivPrices WHERE TipoID = 5" Prices5.CursorType = 0 Prices5.CursorLocation = 2 Prices5.LockType = 1 Prices5.Open() Prices5_numRows = 0 %> <% Dim Tipo6 Dim Tipo6_numRows Set Tipo6 = Server.CreateObject("ADODB.Recordset") Tipo6.ActiveConnection = MM_Sirius_STRING Tipo6.Source = "SELECT Tipo FROM Tipo WHERE TipoID = 6" Tipo6.CursorType = 0 Tipo6.CursorLocation = 2 Tipo6.LockType = 1 Tipo6.Open() Tipo6_numRows = 0 %> <% Dim Tipo7 Dim Tipo7_numRows Set Tipo7 = Server.CreateObject("ADODB.Recordset") Tipo7.ActiveConnection = MM_Sirius_STRING Tipo7.Source = "SELECT Tipo FROM Tipo WHERE TipoID = 7" Tipo7.CursorType = 0 Tipo7.CursorLocation = 2 Tipo7.LockType = 1 Tipo7.Open() Tipo7_numRows = 0 %> <% Dim Prices6 Dim Prices6_numRows Set Prices6 = Server.CreateObject("ADODB.Recordset") Prices6.ActiveConnection = MM_Sirius_STRING Prices6.Source = "SELECT Articulos, Precio FROM DivPrices WHERE TipoID = 6" Prices6.CursorType = 0 Prices6.CursorLocation = 2 Prices6.LockType = 1 Prices6.Open() Prices6_numRows = 0 %> <% Dim Prices7 Dim Prices7_numRows Set Prices7 = Server.CreateObject("ADODB.Recordset") Prices7.ActiveConnection = MM_Sirius_STRING Prices7.Source = "SELECT Articulos, Precio FROM DivPrices WHERE TipoID = 7" Prices7.CursorType = 0 Prices7.CursorLocation = 2 Prices7.LockType = 1 Prices7.Open() Prices7_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 Prices4_numRows = Prices4_numRows + Repeat1__numRows %> <% Dim Repeat2__numRows Dim Repeat2__index Repeat2__numRows = -1 Repeat2__index = 0 Prices5_numRows = Prices5_numRows + Repeat2__numRows %> <% Dim Repeat3__numRows Dim Repeat3__index Repeat3__numRows = -1 Repeat3__index = 0 Prices6_numRows = Prices6_numRows + Repeat3__numRows %> <% Dim Repeat4__numRows Dim Repeat4__index Repeat4__numRows = -1 Repeat4__index = 0 Prices7_numRows = Prices7_numRows + Repeat4__numRows %>
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||