Jump to content


Photo

Erro Estanho Em Apresentar


  • Faça o login para participar
2 replies to this topic

#1 Reluviari

Reluviari

    Normal

  • Usuários
  • 78 posts
  • Sexo:Não informado

Posted 30/06/2003, 14:12

olhem isso caras........

<%
sql ="select DataNascimento1 = CONVERT(nvarchar(20), DataNascimento, 103), * From documentositens Where documento = '"&Session("documento")&"' and seqendosso = '"&Session("seqendosso")&"' "

Set rsquery = Conn.Execute(SQL)
If rsquery.EOF or rsquery.BOF Then
%>

<div style="width:90%;height:5%;text-align:center;padding-top:10%;padding-left:20%">
<center><font color="#003366" size="2" face="Verdana, Arial, Helvetica, sans-serif"><b><%Response.Write "Nenhum registro encontrado...."%></b></font></center>
</div>

<%Response.End%>
<%End If%>

<%
set rsquery2 = conn.execute ("Select * from SituacaoItens where situacaoitens = '"& rsquery("SituacaoItem") &"' ")
%>


<html>
<head>
<title>:::FullWare:::</title>

</head>

<body>
<div style="width:90%;height:5%;text-align:center;padding-top:1%;padding-left:20%">
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macr...rsion=6,0,29,0" width="100" height="40">
<param name="movie" value="imagens/COBERTURAS.swf">
<param name="quality" value="high">
<embed src="imagens/COBERTURAS.swf" quality="high" pluginspage="http://www.macromedi...getflashplayer" type="application/x-shockwave-flash" width="150" height="50"></embed>
</object>
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macr...rsion=6,0,29,0" width="100" height="40">
<param name="movie" value="imagens/DEPENDENTES1.swf">
<param name="quality" value="high">
<embed src="imagens/DEPENDENTES1.swf" quality="high" pluginspage="http://www.macromedi...getflashplayer" type="application/x-shockwave-flash" width="150" height="50"></embed>
</object>
</div>
<div style="width:80%;height:5%;text-align:center;padding-top:2%;padding-left:25%;padding-right:20%">

<fieldset style="width:150%;height:5%;text-align:center;padding-top:3%">

<legend> <b><font color="#000080" size="3" face="Arial">ITENS</font></b> </legend>
<BR>

<table align="center" border="2"ID="Table1" width="110%" height="10">
<tr>
<td bgcolor="#ffffe1"><font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif"><b>ITEM</b></font></td>
<td bgcolor="#ffffe1"><font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif"><b>ITEM CIA</b></font></td>
<td bgcolor="#ffffe1"><font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif"><b>SITUA&Ccedil;&Atilde;O DO ITEM</b></font></td>
</tr>

<tr>
<td width="26%" height="20"><font color="#003366" size="2" face="Verdana, Arial, Helvetica, sans-serif"><b> <%=rsquery("item")%></b></font></td>
<td width="26%" height="20"><font color="#003366" size="2" face="Verdana, Arial, Helvetica, sans-serif"><b><%=rsquery("itemcia")%></b></font></td>

<% do while not rsquery2.eof %>
<td width="58%" height="20"><font color="#003366" size="2" face="Verdana, Arial, Helvetica, sans-serif"><b><%=rsquery2("descricao")%></b></font></td>
<%rsquery2.movenext
loop%>
</tr>
</table>
<BR>

<table align="center" border="2"ID="Table1" width="110%" height="10">
<tr>
<td height="17" bgcolor="#ffffe1"><b><font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif">NOME</font></b></td>
<td bgcolor="#ffffe1"><font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif"><b>CPF</b></font></td>
<td bgcolor="#ffffe1"><font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif"><b>RG</b></font></td>
</tr>

<tr>
<td width="50%" height="20"><font color="#003366" size="2" face="Verdana, Arial, Helvetica, sans-serif"><b><%=rsquery("nome")%></b></font></td>
<td width="26%" height="20"><font color="#003366" size="2" face="Verdana, Arial, Helvetica, sans-serif"><b><%=rsquery("cpf")%></b></font></td>

<td width="30%" height="20"><font color="#003366" size="2" face="Verdana, Arial, Helvetica, sans-serif"><b><%=rsquery("Rg")%></b></font></td>

</tr>
</table>
<BR>

<table align="center" border="2"ID="Table1" width="110%" height="10">

<tr>
<td bgcolor="#ffffe1"><font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif"><b>DATA DE NASCIMENTO</b></font></td>
<td bgcolor="#ffffe1"><font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif"><b>SEXO</b></font></td>
</tr>

<tr>
<td width="50%" height="20"><font color="#003366" size="2" face="Verdana, Arial, Helvetica, sans-serif"><b><%=rsquery("datanascimento1")%></b></font></td>
<td width="50%" height="20"><%if rsquery("sexo") = "F" then%> <font color="#003366" size="2" face="Verdana, Arial, Helvetica, sans-serif"><b><%Response.Write ("FEMININO")%></b></font><%else%><font color="#003366"size="2" face="Verdana, Arial, Helvetica, sans-serif"><b> <%Response.Write("MASCULINO")%> <%end if%> </b></font></td>
</tr>

</table>

<BR>

<table align="center" border="2"ID="Table1" width="110%" height="10">
<tr>
<td height="23" bgcolor="#ffffe1"><font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif"><b>OBSERVA&Ccedil;&Atilde;O</b></font></td>
</tr>
<tr>
<td width="110%" height="70"><font color="#003366" size="2" face="Verdana, Arial, Helvetica, sans-serif"><b><%=rsquery("Observacao")%></b></font></td>
</tr>
</table>
<BR>


</fieldset>
</div>

</body>
</html>


NA TABELA ESSES CAMPOS ESTAO TODOS PREENCHIDOS (EXISTEM REGISTRO EM TODOS )SÓ Q O RG E A OBSERVACAO NAO APARECEM PQ????
PODEM ME AJUDAR MAISSSSSSSSS UMA VEZ....NAO CONSSIGO ACHAR O ERROOO...................AAHHH TEM MAIS ...A PAGINA NAO DA PAU O CAMPO FICA APENAS EM BRANCO

#2 Reluviari

Reluviari

    Normal

  • Usuários
  • 78 posts
  • Sexo:Não informado

Posted 30/06/2003, 16:56

pq ninguem me ajuda??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????

#3 sodra

sodra

    12 Horas

  • Usuários
  • 174 posts
  • Sexo:Não informado

Posted 30/06/2003, 18:03

ae kra eu num sei c eh issu tenta tira as letras maiusculas do nome do campo Rg e Observacao, num encontrei + nda pra dah erru soh issu mesmo tenta ai c num deh posta d novu
Gustavo Bodra

"Muitos dizem skate na veia, mas poucos sabem, realmente, o que é skate nos pés"




1 user(s) are reading this topic

0 membro(s), 1 visitante(s) e 0 membros anônimo(s)

IPB Skin By Virteq