%@LANGUAGE="VBSCRIPT"%> <% Dim rs_menu Dim rs_menu_cmd Dim rs_menu_numRows Set rs_menu_cmd = Server.CreateObject ("ADODB.Command") rs_menu_cmd.ActiveConnection = MM_padrao_STRING rs_menu_cmd.CommandText = "SELECT * FROM menu_produto ORDER BY menu ASC" rs_menu_cmd.Prepared = true Set rs_menu = rs_menu_cmd.Execute rs_menu_numRows = 0 %> <% Dim rs_empresa Dim rs_empresa_cmd Dim rs_empresa_numRows Set rs_empresa_cmd = Server.CreateObject ("ADODB.Command") rs_empresa_cmd.ActiveConnection = MM_padrao_STRING rs_empresa_cmd.CommandText = "SELECT * FROM empresa ORDER BY id DESC" rs_empresa_cmd.Prepared = true Set rs_empresa = rs_empresa_cmd.Execute rs_empresa_numRows = 0 %> <% Dim rs_busca Dim rs_busca_cmd Dim rs_busca_numRows Set rs_busca_cmd = Server.CreateObject ("ADODB.Command") rs_busca_cmd.ActiveConnection = MM_padrao_STRING rs_busca_cmd.CommandText = "SELECT * FROM menu_produto ORDER BY menu ASC" rs_busca_cmd.Prepared = true Set rs_busca = rs_busca_cmd.Execute rs_busca_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 rs_menu_numRows = rs_menu_numRows + Repeat1__numRows %> <% Dim Repeat2__numRows Dim Repeat2__index Repeat2__numRows = 1 Repeat2__index = 0 rs_empresa_numRows = rs_empresa_numRows + Repeat2__numRows %> <% Dim HLooper1__numRows HLooper1__numRows = 30 Dim HLooper1__index HLooper1__index = 0 rs_produto_numRows = rs_produto_numRows + HLooper1__numRows %>
|
<% While ((Repeat2__numRows <> 0) AND (NOT rs_empresa.EOF)) %>
Não há texto cadastrado. <% End If ' end rs_empresa.EOF And rs_empresa.BOF %> |
<% rs_menu.Close() Set rs_menu = Nothing %> <% rs_empresa.Close() Set rs_empresa = Nothing %> <% rs_busca.Close() Set rs_busca = Nothing %>