%@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_localizacao Dim rs_localizacao_cmd Dim rs_localizacao_numRows Set rs_localizacao_cmd = Server.CreateObject ("ADODB.Command") rs_localizacao_cmd.ActiveConnection = MM_padrao_STRING rs_localizacao_cmd.CommandText = "SELECT * FROM localizacao ORDER BY id DESC" rs_localizacao_cmd.Prepared = true Set rs_localizacao = rs_localizacao_cmd.Execute rs_localizacao_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_localizacao_numRows = rs_localizacao_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_localizacao.EOF)) %>
<% Repeat2__index=Repeat2__index+1 Repeat2__numRows=Repeat2__numRows-1 rs_localizacao.MoveNext() Wend %>
<% If rs_localizacao.EOF And rs_localizacao.BOF Then %>
Não há texto cadastrado.
<% End If ' end rs_localizacao.EOF And rs_localizacao.BOF %>
|
<% rs_menu.Close() Set rs_menu = Nothing %> <% rs_localizacao.Close() Set rs_localizacao = Nothing %> <% rs_busca.Close() Set rs_busca = Nothing %>