Ir para conteúdo

POWERED BY:

Arquivado

Este tópico foi arquivado e está fechado para novas respostas.

FabianoBSB

[Resolvido] Esconder Linhas tabela em asp

Por , em ASP Clássico

Recommended Posts

FabianoBSB    0

FabianoBSB
Postado

Ola galera sou novo no forum, tenho um sistema de Nota de Material aonde eu monto alguns regsitros na tabela desse formulario. Porém to com um problema em imprimir os dados na tela. Esse formulario tem uma sequencia de 13 registros por formulario. O Problema é que quando o usuario efetuar a consulta e por exemplo achar somente 6, ele imprime na tela e os outras 7 linhas da tabela continuem visiveis, eu to fazendo dando loop ai ele efetua a consulta porem me adiciona mais 7 linhas em branco ai um registro depois de novo e isso se repete ate o tanto que achar. Esse formulario tem um tamanho padrao. Acho que fui claro. espero q vcs tenham me entendido. Se puderem me dar uma força. Segue o código

 

<p>

<%
Set Conn = Server.CreateObject("ADODB.Connection") 
Conn.provider ="Microsoft.Jet.OLEDB.4.0" 
Conn.connectionstring=Server.Mappath("banco.mdb")
Conn.open

Set RS = Server.CreateObject("ADODB.Recordset") 'acrescentei por causa da paginação
Numero = Request("Numero")
sql =  "SELECT * FROM NMM Order by nr asc"

RS.Open Sql, conn, 3,3
If RS.EOF Then
'Response.Write "Nenhum registro encontrado!"
Response.Write("<a href=javascript:history.back(-1)><br><br>Voltar</a>")
Response.End()
End If


%>

 

</p>
<table width="1169" height="59" cellpadding="0" cellspacing="0" style="border-width:1;">
    <tr>
        <td width="176" height="53" rowspan="2" bordercolor="white"> </td>
        <td width="575" height="14" bordercolor="white">
            <p align="center"> </p>
        </td>
        <td width="416" height="59" bordercolor="white" rowspan="2">
            <p align="center"> </p>
        </td>
    </tr>
    <tr>
        <td width="575" height="21" bordercolor="white">
            <p align="center"> </p>
        </td>
    </tr>
</table>
<table width="1169" height="633" style="border-width:1; border-color:rgb(204,204,204); border-style:none; border-collapse:collapse;" id="NMM" cellspacing="0" bordercolordark="white" bordercolorlight="black" cellpadding="0">
    <tr>
        <td width="737" colspan="6" height="30" rowspan="2" style="border-top-width:2; border-right-width:1; border-bottom-width:1; border-left-width:2; border-color:black; border-style:solid;">
            <p align="center"><font size="5" face="Verdana" color="#1F497D">NOTA DE MOVIMENTAÇÃO DE MATERIAL NMM</font></p>
        </td>
        <td width="125" height="30" rowspan="2" colspan="3" style="border-top-width:2; border-right-width:1; border-bottom-width:1; border-left-width:1; border-color:black; border-style:solid;">
            <p align="center"><font size="1" face="Verdana" color="#1F497D">1ª VIA DEAMP</font></p>
        </td>
        <td width="28" height="18" style="border-top-width:2; border-right-width:1; border-bottom-width:1; border-left-width:1; border-color:black; border-style:solid;">
            <p align="center"><font size="1" face="Verdana" color="#1F497D">Cat</font></p>
        </td>
        <td width="15" height="18" style="border-top-width:2; border-right-width:1; border-bottom-width:1; border-left-width:1; border-color:black; border-style:solid;"><font size="1" color="#1F497D"> </font></td>
        <td width="44" height="18" style="border-top-width:2; border-right-width:1; border-bottom-width:1; border-left-width:1; border-color:black; border-style:solid;">
            <p align="center"><font size="1" face="Verdana" color="#1F497D">C Mov</font><font size="1"></font></p>
        </td>
        <td width="43" height="18" style="border-top-width:2; border-right-width:1; border-bottom-width:1; border-left-width:1; border-color:black; border-style:solid;"><font size="1" face="Verdana" color="#1F497D">Cod Local</font></td>
        <td width="165" height="18" style="border-top-width:2; border-right-width:2; border-bottom-width:1; border-left-width:1; border-color:black; border-style:solid;">
            <p align="center"><font size="1" face="Verdana" color="#1F497D">NUMERAÇÃOSEQUENCIAL</font></p>
        </td>
    </tr>
    <tr>
        <td width="28" height="18" style="border-width:1; border-color:black; border-style:solid;">
            <p align="center"><font size="1" face="Verdana" color="#1F497D">01</font><font size="1"></font></p>
        </td>
        <td width="15" height="18" style="border-width:1; border-color:black; border-style:solid;"><font size="1" face="Verdana" color="#1F497D"> </font></td>
        <td width="44" height="18" style="border-width:1; border-color:black; border-style:solid;">
            <p align="center"><font size="1" face="Verdana" color="#1F497D">35</font><font size="1"></font></p>
        </td>
        <td width="43" height="18" style="border-width:1; border-color:black; border-style:solid;">
            <p align="center"><font size="1" face="Verdana" color="#1F497D"><%Response.Write rs("Cod_local")%> </font></p>
        </td>
        <td width="165" height="18" style="border-top-width:1; border-right-width:2; border-bottom-width:1; border-left-width:1; border-color:black; border-style:solid;">
            <p align="center"><font size="5" face="Verdana" color="#1F497D"><%Response.Write rs("Numero")



%> </font></p>
        </td>
    </tr>
    <tr>
        <td width="38" height="81" rowspan="5" style="border-top-width:2; border-right-width:1; border-bottom-width:2; border-left-width:2; border-color:black; border-style:solid;">
            <p align="center"><font size="1" face="Verdana" color="#1F497D">DE:</font></p>
        </td>
        <td width="698" rowspan="5" colspan="5" height="81" style="border-top-width:2; border-right-width:1; border-bottom-width:2; border-left-width:1; border-color:black; border-style:solid;">
            <p>   <font size="4" face="Verdana" color="#1F497D"><%Response.Write rs("NomeDe")



%> </font></p>
        </td>
        <td width="125" colspan="3" style="border-top-width:2; border-right-width:1; border-bottom-width:1; border-left-width:1; border-color:black; border-style:solid;"><font size="1" face="Verdana" color="#1F497D">Setor de Localização</font></td>
        <td width="132" colspan="4" style="border-top-width:2; border-right-width:2; border-bottom-width:1; border-left-width:1; border-color:black; border-style:solid;">
            <p align="left"><font size="1" face="Verdana" color="#1F497D"><%Response.Write rs("StrLocDe")



%> </font></p>
        </td>
        <td width="165" style="border-top-width:2; border-right-width:2; border-left-width:1; border-top-color:black; border-right-color:black; border-bottom-color:white; border-left-color:white; border-top-style:solid; border-right-style:solid; border-bottom-style:none; border-left-style:solid;" height="17">
            <p align="center"><font size="1" face="Verdana" color="#1F497D">Nota Fiscal</font></p>
        </td>
    </tr>
    <tr>
        <td width="125" colspan="3" style="border-width:1; border-color:black; border-style:solid;"><font size="1" face="Verdana" color="#1F497D">Centro de Custo</font></td>
        <td width="132" colspan="4" style="border-top-width:1; border-right-width:2; border-bottom-width:1; border-left-width:1; border-color:black; border-style:solid;">
            <p><font size="1" face="Verdana" color="#1F497D"><%Response.Write rs("CentroCustoDe")



%> </font></p>
        </td>
        <td width="165" height="31" rowspan="2" style="border-top-width:1; border-right-width:2; border-bottom-width:2; border-left-width:1; border-color:black; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:solid;">
            <p align="center"><font size="2" face="Verdana" color="#1F497D"><%Response.Write rs("Nota_Fiscal")



%> </font></p>
        </td>
    </tr>
    <tr>
        <td width="125" colspan="3" style="border-width:1; border-color:black; border-style:solid;" height="14"><font size="1" face="Verdana" color="#1F497D">Local</font></td>
        <td width="132" colspan="4" style="border-top-width:1; border-right-width:2; border-bottom-width:1; border-left-width:1; border-color:black; border-style:solid;" height="14">
            <p align="left"><font size="1" face="Verdana" color="#1F497D"><%Response.Write rs("LocalPara")



%> </font></p>
        </td>
    </tr>
    <tr>
        <td width="125" height="15" colspan="3" style="border-width:1; border-color:black; border-style:solid;">
            <p><font size="1" face="Verdana" color="#1F497D">Matrícula</font><font size="1"></font></p>
        </td>
        <td width="132" height="15" colspan="4" style="border-top-width:1; border-right-width:2; border-bottom-width:1; border-left-width:1; border-color:black; border-style:solid;">
            <p align="left"><font size="1" face="Verdana" color="#1F497D"><%Response.Write rs("Mat_De")



%> </font></p>
        </td>
        <td width="165" height="17" style="border-top-width:1; border-right-width:2; border-bottom-width:1; border-left-width:1; border-color:black; border-top-style:solid; border-right-style:solid; border-bottom-style:none; border-left-style:solid;">
            <p align="center"><font size="1" face="Verdana" color="#1F497D">Nota de Empenho</font></p>
        </td>
    </tr>
    <tr>
        <td width="258" height="12" colspan="7" style="border-top-width:1; border-right-width:2; border-bottom-width:2; border-left-width:1; border-color:black; border-style:solid;">
            <p align="left"><font size="1" face="Verdana"> </font></p>
        </td>
        <td width="165" height="29" rowspan="2" style="border-top-width:1; border-right-width:2; border-bottom-width:2; border-left-width:1; border-color:black; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:solid;">
            <p align="center"><font size="2" face="Verdana" color="#1F497D"><%Response.Write rs("Ne")



%> </font></p>
        </td>
    </tr>
    <tr>
        <td width="38" rowspan="4" height="58" style="border-top-width:1; border-right-width:1; border-bottom-width:2; border-left-width:2; border-color:black; border-style:solid;">
            <p align="center"><font size="1" face="Verdana" color="#1F497D">PARA:</font></p>
        </td>
        <td width="698" rowspan="4" colspan="5" height="58" style="border-top-width:1; border-right-width:1; border-bottom-width:2; border-left-width:1; border-color:black; border-style:solid;">
            <p>   <font face="Verdana" color="#1F497D"><b><%Response.Write rs("NomePara")



%> </b></font></p>
        </td>
        <td width="125" colspan="3" style="border-width:1; border-color:black; border-style:solid;" height="6"><font size="1" face="Verdana" color="#1F497D">Setor de Localização</font><font size="1" face="Verdana"></font></td>
        <td width="132" colspan="4" style="border-top-width:1; border-right-width:2; border-bottom-width:1; border-left-width:1; border-color:black; border-style:solid;" height="6">
            <p align="left"><font size="1" face="Verdana" color="#1F497D"><%Response.Write rs("StrlocPara")



%> </font></p>
        </td>
    </tr>
    <tr>
        <td width="125" colspan="3" style="border-width:1; border-color:black; border-style:solid;" height="10"><font size="1" face="Verdana" color="#1F497D">Centro de Custo</font><font size="1" face="Verdana"></font></td>
        <td width="132" colspan="4" style="border-top-width:1; border-right-width:2; border-bottom-width:1; border-left-width:1; border-color:black; border-style:solid;" height="10">
            <p align="left"><font size="1" face="Verdana" color="#1F497D"><%Response.Write rs("CentrocustoPara")



%> </font></p>
        </td>
        <td width="165" height="10" style="border-top-width:1; border-right-width:2; border-bottom-width:1; border-left-width:1; border-color:black; border-top-style:solid; border-right-style:solid; border-bottom-style:none; border-left-style:solid;">
            <p align="center"><font size="1" face="Verdana" color="#1F497D">NMM de Referência</font></p>
        </td>
    </tr>
    <tr>
        <td width="125" colspan="3" style="border-width:1; border-color:black; border-style:solid;" height="6"><font size="1" face="Verdana" color="#1F497D">Local</font><font size="1"></font></td>
        <td width="132" colspan="4" style="border-top-width:1; border-right-width:2; border-bottom-width:1; border-left-width:1; border-color:black; border-style:solid;" height="6">
            <p align="left"><font size="1" face="Verdana" color="#1F497D"><%Response.Write rs("LocalDe")



%> </font></p>
        </td>
        <td width="165" height="24" rowspan="2" style="border-top-width:1; border-right-width:2; border-bottom-width:2; border-left-width:1; border-color:black; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:solid;">
            <p align="center"><font size="2" face="Verdana" color="#1F497D"><%Response.Write rs("Numero")



%> </font></p>
        </td>
    </tr>
    <tr>
        <td width="125" height="7" colspan="3" style="border-top-width:1; border-right-width:1; border-bottom-width:2; border-left-width:1; border-color:black; border-style:solid;">
            <p align="left"><font size="1" face="Verdana" color="#1F497D">Matrícula</font><font size="1" face="Verdana"></font></p>
        </td>
        <td width="132" height="7" colspan="4" style="border-top-width:1; border-right-width:2; border-bottom-width:2; border-left-width:1; border-color:black; border-style:solid;">
            <p align="left"><font size="1" face="Verdana" color="#1F497D"><%Response.Write rs("Mat_Para")



%> </font></p>
        </td>
    </tr>
    <tr>
        <td width="38" bgcolor="#66FFFF" style="border-top-width:2; border-right-width:1; border-bottom-width:1; border-left-width:2; border-color:black; border-style:solid;" height="10"><font size="1" face="Verdana" color="#1F497D"> </font></td>
        <td width="206" bgcolor="#66FFFF" style="border-top-width:2; border-right-width:1; border-bottom-width:1; border-left-width:1; border-color:black; border-style:solid;" height="10"><font size="1" face="Verdana" color="#1F497D"> </font></td>
        <td width="121" bgcolor="#66FFFF" style="border-top-width:2; border-right-width:1; border-bottom-width:1; border-left-width:1; border-color:black; border-style:solid;" height="10"><font size="1" face="Verdana" color="#1F497D"> </font></td>
        <td width="121" bgcolor="#66FFFF" style="border-top-width:2; border-right-width:1; border-bottom-width:1; border-left-width:1; border-color:black; border-style:solid;" height="10"><font size="1" face="Verdana" color="#1F497D"> </font></td>
        <td width="121" bgcolor="#66FFFF" style="border-top-width:2; border-right-width:1; border-bottom-width:1; border-left-width:1; border-color:black; border-style:solid;" height="10"><font size="1" face="Verdana" color="#1F497D"> </font></td>
        <td width="125" bgcolor="#66FFFF" style="border-top-width:2; border-right-width:1; border-bottom-width:1; border-left-width:1; border-color:black; border-style:solid;" height="10"><font size="1" face="Verdana" color="#1F497D"> </font></td>
        <td width="125" bgcolor="#66FFFF" colspan="3" style="border-top-width:2; border-right-width:1; border-bottom-width:1; border-left-width:1; border-color:black; border-style:solid;" height="10"><font size="1" face="Verdana" color="#1F497D"> </font></td>
        <td width="89" bgcolor="#66FFFF" colspan="3" style="border-top-width:2; border-right-width:1; border-bottom-width:1; border-left-width:1; border-color:black; border-style:solid;" height="10"><font size="1" face="Verdana" color="#1F497D"> </font></td>
        <td width="43" bgcolor="#66FFFF" style="border-top-width:2; border-right-width:1; border-bottom-width:1; border-left-width:1; border-color:black; border-style:solid;" height="10"><font size="1" face="Verdana" color="#1F497D"> </font></td>
        <td width="165" bgcolor="#66FFFF" style="border-top-width:2; border-right-width:2; border-bottom-width:1; border-left-width:1; border-color:black; border-style:solid;" height="10"><font size="1" face="Verdana" color="#1F497D"> </font></td>
    </tr>
	

    <tr>
        <td width="38" style="border-top-width:1; border-right-width:1; border-bottom-width:1; border-left-width:2; border-color:black; border-style:solid;" height="18">
            <p align="center"><font size="1" face="Verdana" color="#1F497D">Ordem</font><font size="1" face="Verdana"></font></p>
        </td>
        <td width="206" style="border-width:1; border-color:black; border-style:solid;" height="18">
            <p align="center"><font size="1" face="Verdana" color="#1F497D">Número de Estoque</font><font size="1" face="Verdana"></font></p>
        </td>
        <td width="121" style="border-width:1; border-color:black; border-style:solid;" height="18">
            <p align="center"><font size="1" face="Verdana" color="#1F497D">Número de Registro</font><font size="1" face="Verdana"></font></p>
        </td>
        <td width="243" colspan="2" style="border-width:1; border-color:black; border-style:solid;" height="18">
            <p align="center"><font size="1" face="Verdana" color="#1F497D">Palavra Chave Nomeclatura</font><font size="1" face="Verdana"></font></p>
        </td>
        <td width="125" style="border-width:1; border-color:black; border-style:solid;" height="18">
            <p align="center"><font size="1" face="Verdana" color="#1F497D">Numero de Série</font><font size="1" face="Verdana"></font></p>
        </td>
        <td width="39" style="border-width:1; border-color:black; border-style:solid;" height="18">
            <p align="center"><font size="1" face="Verdana" color="#1F497D">Estado</font></p>
        </td>
        <td width="38" style="border-width:1; border-color:black; border-style:solid;" height="18"><font size="1" face="Verdana" color="#1F497D">UF</font><font size="1"></font></td>
        <td width="46" style="border-width:1; border-color:black; border-style:solid;" height="18"><font size="1" face="Verdana" color="#1F497D">Quant.</font></td>
        <td width="299" colspan="5" style="border-top-width:1; border-right-width:2; border-bottom-width:1; border-left-width:1; border-color:black; border-style:solid;" height="18">
            <p align="center"><font size="1" face="Verdana" color="#1F497D">Preço Total R$</font></p>
        </td>
			
    </tr>
		
    <%DO WHILE NOT RS.EOF%>

    <tr id="Linha1"> 
        <td width="38" style="border-top-width:1; border-right-width:1; border-bottom-width:1; border-left-width:2; border-color:black; border-style:solid;" height="16" id="Linha1">
            <p align="center"><font size="1" face="Verdana" color="#1F497D">
		
			
</font><font size="2" face="Verdana" color="#1F497D">           
</font><font size="2" face="Verdana">1</font></p>
        </td>
        <td width="206" style="border-width:1; border-color:black; border-style:solid;" height="16">
            <p align="center"><font size="2" face="Verdana" color="#1F497D"><%Response.Write rs("Cod_local")



%> </font></p>
        </td>
        <td width="121" style="border-width:1; border-color:black; border-style:solid;" height="16">
            <p align="center"><font size="2" face="Verdana" color="#1F497D"><%Response.Write rs("Nr")



%> </font></p>
        </td>
        <td width="243" colspan="2" style="border-width:1; border-color:black; border-style:solid;" id="pavra1" height="16">
            <p align="center"><font size="2" face="Verdana" color="#1F497D"><%Response.Write rs("Palavra_Chave")



%> </font></p>
        </td>
        <td width="125" style="border-width:1; border-color:black; border-style:solid;" height="16">
            <p align="center"><font size="2" face="Verdana" color="#1F497D"><%Response.Write rs("Numero_serie")



%> </font></p>
        </td>
        <td width="39" style="border-width:1; border-color:black; border-style:solid;" height="16">
            <p align="center"><font size="2" face="Verdana" color="#1F497D"><%Response.Write rs("Estado")



%> </font></p>
        </td>
        <td width="38" style="border-width:1; border-color:black; border-style:solid;" height="16">
            <p align="center"><font size="2" face="Verdana" color="#1F497D"><%Response.Write rs("UF")



%> </font></p>
        </td>
        <td width="46" style="border-width:1; border-color:black; border-style:solid;" height="16">
            <p align="center"><font size="2" face="Verdana" color="#1F497D"><%Response.Write rs("Cod_local")



%> </font></p>
        </td>
        <td width="300" colspan="5" style="border-width:1; border-color:black; border-style:solid;" height="16" id="Linha1">
            <p align="center" id="valor"><font size="2" face="Verdana" color="#1F497D"><%Valor = Rs("Valor")
Response.Write FormatCurrency(Valor,2)%>
</font></p>
        </td>
    </tr>

    <tr id="Linha2">
        <td width="38" style="border-top-width:1; border-right-width:1; border-bottom-width:1; border-left-width:2; border-color:black; border-style:solid;" height="16">
            <p align="center"><font size="2" face="Verdana">2</font></p>
        </td>
        <td width="206" style="border-width:1; border-color:black; border-style:solid;" height="16" id="Linha2">
         </td>
        <td width="121" style="border-width:1; border-color:black; border-style:solid;" height="16">
            <p> </p>
        </td>
        <td width="243" colspan="2" style="border-width:1; border-color:black; border-style:solid;" id="pavra1" height="16">
         </td>
        <td width="125" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="39" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="38" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="46" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="300" colspan="5" style="border-width:1; border-color:black; border-style:solid;" height="16" id="Linha2">  
         </td>
    </tr>

    <tr id="Linha3">
        <td width="38" style="border-top-width:1; border-right-width:1; border-bottom-width:1; border-left-width:2; border-color:black; border-style:solid;" height="12">
            <p align="center"><font size="2" face="Verdana">3</font></p>
        </td>
        <td width="206" style="border-width:1; border-color:black; border-style:solid;" height="12">
         </td>
        <td width="121" style="border-width:1; border-color:black; border-style:solid;" height="12">
         </td>
        <td width="243" colspan="2" style="border-width:1; border-color:black; border-style:solid;" id="pavra1" height="12">
         </td>
        <td width="125" style="border-width:1; border-color:black; border-style:solid;" height="12">
         </td>
        <td width="39" style="border-width:1; border-color:black; border-style:solid;" height="12">
         </td>
        <td width="38" style="border-width:1; border-color:black; border-style:solid;" height="12">
         </td>
        <td width="46" style="border-width:1; border-color:black; border-style:solid;" height="12">
         </td>
        <td width="300" colspan="5" style="border-width:1; border-color:black; border-style:solid;" height="12">
         </td>
    </tr>
    <tr id="Linha4">
        <td width="38" style="border-top-width:1; border-right-width:1; border-bottom-width:1; border-left-width:2; border-color:black; border-style:solid;" height="16">
            <p align="center"><font size="2" face="Verdana">4</font></p>
        </td>
        <td width="206" style="border-width:1; border-color:black; border-style:solid;" height="16">
            <p> </p>
        </td>
        <td width="121" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="243" colspan="2" style="border-width:1; border-color:black; border-style:solid;" id="pavra1" height="16">
         </td>
        <td width="125" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="39" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="38" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="46" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="300" colspan="5" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
    </tr>
    <tr id="Linha5">
        <td width="38" style="border-top-width:1; border-right-width:1; border-bottom-width:1; border-left-width:2; border-color:black; border-style:solid;" height="16">
            <p align="center"><font size="2" face="Verdana">5</font></p>
        </td>
        <td width="206" style="border-width:1; border-color:black; border-style:solid;" height="16" id="CampoNestoque">
            <p> </p>
        </td>
        <td width="121" style="border-width:1; border-color:black; border-style:solid;" height="16" id="CampoNr">
         </td>
        <td width="243" colspan="2" style="border-width:1; border-color:black; border-style:solid;" id="pavra1" height="16">
         </td>
        <td width="125" style="border-width:1; border-color:black; border-style:solid;" height="16" id="NumeroSerie">
         </td>
        <td width="39" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="38" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="46" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="300" colspan="5" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
    </tr>
    <tr id="Linha6">
        <td width="38" style="border-top-width:1; border-right-width:1; border-bottom-width:1; border-left-width:2; border-color:black; border-style:solid;" height="16">
            <p align="center"><font size="2" face="Verdana">6</font></p>
        </td>
        <td width="206" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="121" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="243" colspan="2" style="border-width:1; border-color:black; border-style:solid;" id="pavra1" height="16">
         </td>
        <td width="125" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="39" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="38" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="46" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="300" colspan="5" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
    </tr>
    <tr id="Linha7">
        <td width="38" style="border-top-width:1; border-right-width:1; border-bottom-width:1; border-left-width:2; border-color:black; border-style:solid;" height="16">
            <p align="center"><font size="2" face="Verdana">7</font></p>
        </td>
        <td width="206" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="121" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="243" colspan="2" style="border-width:1; border-color:black; border-style:solid;" id="pavra1" height="16">
         </td>
        <td width="125" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="39" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="38" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="46" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="300" colspan="5" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
    </tr>
    <tr id="Linha8">
        <td width="38" style="border-top-width:1; border-right-width:1; border-bottom-width:1; border-left-width:2; border-color:black; border-style:solid;" height="16">
            <p align="center"><font size="2" face="Verdana">8</font></p>
        </td>
        <td width="206" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="121" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="243" colspan="2" style="border-width:1; border-color:black; border-style:solid;" id="pavra1" height="16">
         </td>
        <td width="125" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="39" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="38" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="46" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="300" colspan="5" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
    </tr>
    <tr id="Linha9">
        <td width="38" style="border-top-width:1; border-right-width:1; border-bottom-width:1; border-left-width:2; border-color:black; border-style:solid;" height="16">
            <p align="center"><font size="2" face="Verdana">9</font></p>
        </td>
        <td width="206" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="121" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="243" colspan="2" style="border-width:1; border-color:black; border-style:solid;" id="pavra1" height="16">
         </td>
        <td width="125" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="39" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="38" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="46" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="300" colspan="5" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
    </tr>
    <tr id="Linha10">
        <td width="38" style="border-top-width:1; border-right-width:1; border-bottom-width:1; border-left-width:2; border-color:black; border-style:solid;" height="16">
            <p align="center"><font size="2" face="Verdana">10</font></p>
        </td>
        <td width="206" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="121" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="243" colspan="2" style="border-width:1; border-color:black; border-style:solid;" id="pavra1" height="16">
         </td>
        <td width="125" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="39" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="38" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="46" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="300" colspan="5" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
    </tr>
    <tr id="Linha11">
        <td width="38" style="border-top-width:1; border-right-width:1; border-bottom-width:1; border-left-width:2; border-color:black; border-style:solid;" height="16">
            <p align="center"><font size="2" face="Verdana">11</font></p>
        </td>
        <td width="206" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="121" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="243" colspan="2" style="border-width:1; border-color:black; border-style:solid;" id="pavra1" height="16">
         </td>
        <td width="125" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="39" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="38" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="46" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="300" colspan="5" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
    </tr>
    <tr id="Linha12">
        <td width="38" style="border-top-width:1; border-right-width:1; border-bottom-width:1; border-left-width:2; border-color:black; border-style:solid;" height="16">
            <p align="center"><font size="2" face="Verdana">12</font></p>
        </td>
        <td width="206" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="121" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="243" colspan="2" style="border-width:1; border-color:black; border-style:solid;" id="pavra1" height="16">
         </td>
        <td width="125" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="39" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="38" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="46" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="300" colspan="5" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
    </tr>
    <tr id="Linha13">
        <td width="38" style="border-top-width:1; border-right-width:1; border-bottom-width:1; border-left-width:2; border-color:black; border-style:solid;" height="16">
            <p align="center"><font size="2" face="Verdana">13</font></p>
        </td>
        <td width="206" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="121" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="243" colspan="2" style="border-width:1; border-color:black; border-style:solid;" id="pavra1" height="16">
         </td>
        <td width="125" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="39" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="38" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="46" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
        <td width="300" colspan="5" style="border-width:1; border-color:black; border-style:solid;" height="16">
         </td>
    </tr>

	    <%
RS.MOVENEXT
LOOP
%>

    <tr>
        <td width="245" style="border-top-width:1; border-right-width:1; border-bottom-width:2; border-left-width:2; border-color:black; border-style:solid;" height="22" colspan="2">
            <p><sup><font size="1" face="Verdana"><span style="word-spacing:0pt; letter-spacing:0pt;">Solicitante</span></font></sup><font size="1" face="Verdana"></font></p>
        </td>
        <td width="121" height="22" style="border-top-width:1; border-right-width:1; border-bottom-width:2; border-left-width:2; border-color:black; border-style:solid;">
            <p align="center"><sup><font size="1" face="Verdana">Data Emissão           </font></sup><font size="2" face="Verdana" color="#1F497D"><sup>
		
            <%data=date
response.write data%>
</sup></font></p>
        </td>
        <td width="243" height="59" rowspan="2" colspan="2" style="border-top-width:1; border-right-width:1; border-bottom-width:2; border-left-width:2; border-color:black; border-style:solid;"><font size="1" face="Verdana"> </font></td>
        <td width="125" height="22" style="border-top-width:1; border-right-width:1; border-bottom-width:2; border-left-width:2; border-color:black; border-style:solid;"><sup><font size="1" face="Verdana">Data Efetiva</font></sup></td>
        <td width="39" height="22" style="border-width:1; border-color:black; border-style:solid;"><sup><font size="1" face="Verdana">Total</font></sup><font size="1" face="Verdana"></font></td>
        <td width="38" height="22" style="border-width:1; border-color:black; border-top-style:solid; border-right-style:none; border-bottom-style:solid; border-left-style:solid;"><sup><font size="1" face="Verdana">Soma</font></sup><font size="1" face="Verdana"></font></td>
        <td width="46" height="22" style="border-width:1; border-color:black; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-left-style:none;"><sup><sup> </sup></sup></td>
        <td width="302" height="22" colspan="5" style="border-top-width:1; border-right-width:1; border-bottom-width:2; border-left-width:2; border-color:black; border-style:solid;"><sup><font size="1" face="Verdana"><sup> </sup></font></sup></td>
    </tr>
    <tr>
        <td width="245" height="37" colspan="2" style="border-top-width:1; border-right-width:1; border-bottom-width:2; border-left-width:2; border-color:black; border-style:solid;"><font size="1" face="Verdana"><sup> </sup></font></td>
        <td width="121" height="37" style="border-top-width:1; border-right-width:1; border-bottom-width:2; border-left-width:2; border-color:black; border-style:solid;"><font size="1" face="Verdana"><sup> </sup></font></td>
        <td width="125" height="37" style="border-top-width:1; border-right-width:1; border-bottom-width:2; border-left-width:2; border-color:black; border-style:solid;"><font size="1" face="Verdana"><sup>Matrícula</sup></font></td>
        <td width="170" height="37" colspan="5" style="border-top-width:1; border-right-width:1; border-bottom-width:2; border-left-width:2; border-color:black; border-style:solid;"><font size="1" face="Verdana"><sup> </sup></font></td>
        <td width="255" height="37" colspan="3" style="border-top-width:1; border-right-width:1; border-bottom-width:2; border-left-width:2; border-color:black; border-style:solid;">
            <p align="center" id="valor"><font size="2" face="Verdana" color="#1F497D"><%=total%>
</font></p>
        </td>
    </tr>
    <tr>
        <td width="245" height="25" colspan="2" style="border-top-width:1; border-right-width:1; border-bottom-width:2; border-left-width:2; border-color:black; border-style:solid;"> </td>
        <td width="121" height="8" style="border-top-width:1; border-right-width:1; border-bottom-width:2; border-left-width:2; border-color:black; border-style:solid;"> </td>
        <td width="796" height="25" colspan="11" style="border-top-width:1; border-right-width:1; border-bottom-width:2; border-left-width:2; border-color:black; border-style:solid;"> </td>
    </tr>
</table>
<p> </p>

<p> </p>

Compartilhar este post

Link para o post
Compartilhar em outros sites

xanburzum    169

xanburzum
Postado

na verdade, você precisa verificar onde esta fazendo o loop, após a consulta no banco, e deixar somente as linhas do registro, para ele poder fazer o laço, verifique se os outros registros não estão em branco, pois dae ele pode exibir no loop...

Compartilhar este post

Link para o post
Compartilhar em outros sites

FabianoBSB    0

FabianoBSB
Postado

na verdade, você precisa verificar onde esta fazendo o loop, após a consulta no banco, e deixar somente as linhas do registro, para ele poder fazer o laço, verifique se os outros registros não estão em branco, pois dae ele pode exibir no loop...

 

Ai que ta o problema!!! eu não quero que mostre as linhas do registro e sim o da tabela.Se o banco estiver em branco(No caso BOF e EOF) eu quero que mostre as 13 linhas da tabela. O que ta acontecendo é que se no banco tiver 2 registro apenas, quando o formulario é aberto aparece 26 linhas e não 13.!!!!!. Mudei o loop pra 1º linha ai acontece que ele adiciona mais uma linha assim fazendo 14 linhas. O que eu quero que toda vez q a consulta achar um registro seria inserido na tabela e retirado uma linha do codigo html. Assim não alteraria o formato da tabela.

Compartilhar este post

Link para o post
Compartilhar em outros sites

xanburzum    169

xanburzum
Postado

cria um table com 13 linhas

Compartilhar este post

Link para o post
Compartilhar em outros sites

FabianoBSB    0

FabianoBSB
Postado

cria um table com 13 linhas

 

Vou tentar ser mais claro.

O usuario fez uma pesquisa no banco e encontrou 3 registros. A partir dessa consulta ele joga nessa tabela a pesquisa, essa tabela tem por padrao 13 linhas.O que eu quero é que quando o usuario jogar a sua pesquisa nesse formulario as linhas correspondente a sua pesquisa saissem dessa tabela no caso seriam 3. Dessa forma o padrao da tabela não fugiria do seu tamanho normal. O que ta acontecendo e que as linhas estao sendo somadas. Nesse caso dos 3 registros a tabela ficaria com 16 linhas e não com 13.

Compartilhar este post

Link para o post
Compartilhar em outros sites

xanburzum    169

xanburzum
Postado

eleza amigo, resolvido...

Compartilhar este post

Link para o post
Compartilhar em outros sites
Ir para a lista de tópicos ASP Clássico
×

Informação importante

Ao usar o fórum, você concorda com nossos Termos e condições.

  Aceito