%@LANGUAGE="VBSCRIPT"%> <% Dim rs_detalhes__MMColParam rs_detalhes__MMColParam = "1" If (Request.QueryString("id") <> "") Then rs_detalhes__MMColParam = Request.QueryString("id") End If %> <% Dim rs_detalhes Dim rs_detalhes_cmd Dim rs_detalhes_numRows Set rs_detalhes_cmd = Server.CreateObject ("ADODB.Command") rs_detalhes_cmd.ActiveConnection = MM_padrao_STRING rs_detalhes_cmd.CommandText = "SELECT * FROM produto WHERE id = ?" rs_detalhes_cmd.Prepared = true rs_detalhes_cmd.Parameters.Append rs_detalhes_cmd.CreateParameter("param1", 5, 1, -1, rs_detalhes__MMColParam) ' adDouble Set rs_detalhes = rs_detalhes_cmd.Execute rs_detalhes_numRows = 0 %> <% 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_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 HLooper1__numRows HLooper1__numRows = 30 Dim HLooper1__index HLooper1__index = 0 rs_produto_numRows = rs_produto_numRows + HLooper1__numRows %>
<% rs_detalhes.Close() Set rs_detalhes = Nothing %> <% rs_menu.Close() Set rs_menu = Nothing %> <% rs_busca.Close() Set rs_busca = Nothing %>