<%@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 %> :: FAST-CUT ::

<% While ((Repeat1__numRows <> 0) AND (NOT rs_menu.EOF)) %>
" class="style3 style4"><%=(rs_menu.Fields.Item("menu").Value)%>
<% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 rs_menu.MoveNext() Wend %>






<% While ((Repeat2__numRows <> 0) AND (NOT rs_empresa.EOF)) %>
 
<%=(rs_empresa.Fields.Item("titulo").Value)%>

<%=(rs_empresa.Fields.Item("texto").Value)%>

<% Repeat2__index=Repeat2__index+1 Repeat2__numRows=Repeat2__numRows-1 rs_empresa.MoveNext() Wend %>


<% If rs_empresa.EOF And rs_empresa.BOF Then %>

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 %>