Olá, tenho um relatório para alterar página, está funcionando perfeitamente, o unico problema que os formulários estão saidno lado a lado e não um embaixo do outro, aqui está o script
<%
Set DB = Server.CreateObject("ADODB.Connection")
cnpath="DBQ=" & server.mappath("email.mdb")
DB.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & cnpath
listar = "SELECT * FROM emails ORDER BY firma "
Set lista = DB.Execute(listar)
%>
<%if lista.EOF then%>
<p align="center"><b><font color="#FF0000" size="5">Não há usuários cadastrados <%else%> <%do while NOT lista.EOF%>
</font></b></p>
<form action="alterar.asp" method="post">
<input type="hidden" name="id" value="<%= lista("id")%>">
<table border="0" cellpadding="0" cellspacing="0" align="left" width="803">
<tr>
<td width="8"> </td>
<td width="795">
<div align="justify"> </div>
<div align="justify">
<p align="center"><img border="0" src="logodh.gif"></p>
<table border="0" cellpadding="0" cellspacing="0" align="left" width="655">
<tr>
<td width="6"> </td>
<td width="645">
<table border="0" width="100%">
<tr>
<td width="100%" colspan="2"><b>Firma:</b><font face="arial" size="2"><input type="text" name="firma" value="<%= lista("firma")%>" size="20"> </font></td>
</tr>
<tr>
<td width="100%" colspan="2"><b>Endereço:</b><font face="arial" size="2"><input type="text" name="lugar" value="<%= lista("lugar")%>" size="45">
</font></td>
</tr>
<tr>
<td width="100%" colspan="2"><b>Contato:</b><font face="arial" size="2"><input type="text" name="resp" value="<%= lista("resp")%>" size="20">
</font>
</td>
</tr>
<tr>
<td width="100%" colspan="2" style="border-bottom-style: solid"><b>
Relatório Técnico</b>
</td>
</tr>
<tr>
<td width="100%" colspan="2"><b>1- </b> <font face="arial" size="2">
<input type="text" name="dia" value="<%= lista("dia")%>" size="18"><input type="text" name="dia1" value="<%= lista("dia1")%>" size="6"><input type="text" name="dia2" value="<%= lista("dia2")%>" size="20"></font><b>
Horário
<input type="text" name="hora" size="2" value="<%=lista("hora")%>"><input type="text" name="hora1" size="2" value="<%=lista("hora1")%>">às
<input type="text" name="hora2" size="2" value="<%=lista("hora2")%>"><input type="text" name="hora3" size="2" value="<%=lista("hora3")%>"><font face="Tahoma" size="3">ID
</font> </b><font size="2" face="Arial, Helvetica, sans-serif" color="#FFFFFF"><input type="text" name="id1" value="<%=lista("id")%>" size="2">
</font></td>
</tr>
<tr>
<td width="100%" colspan="2"><b>Chamado Técnico: </b><input type="text" name="cham" size="70" value="<%=lista("cham")%>"></td>
</tr>
<tr>
<td width="100%" colspan="2"><textarea rows="12" name="cham2" cols="90"><%=lista("cham2")%></textarea></td>
</tr>
<tr>
<td width="100%" colspan="2"><b><font size="2" face="Tahoma">Posição
do Chamado:</font> <input type="text" name="pos" size="7" value="<%=lista("pos")%>"></b></td>
</tr>
<tr>
<td width="100%" height="21" style="border-bottom-style: solid"><font face="Tahoma" size="2"><b>
Pendências:</b></font></td>
</tr>
<tr>
<td width="100%" height="21"><textarea rows="6" name="pen" cols="90"><%=lista("pen")%></textarea></td>
</tr>
<tr>
<td width="100%" height="21">
<p> </td>
</tr>
<tr>
<td width="100%" height="21">
<table border="0" width="100%">
<tr>
<td width="50%" align="center"><font face="Tahoma" size="2">
______________________________________________</font></td>
<td width="50%" align="center"><font face="Tahoma" size="2">
______________________________________________</font></td>
</tr>
<tr>
<td width="50%" align="center"><input type="text" name="tecnico" size="15" value="<%=lista("tec")%>"></td>
<td width="50%" align="center"><font face="arial" size="2"><input type="text" name="paginainicial1" value="<%= lista("resp")%>" size="20">
</font>
</td>
</tr>
<tr>
<td width="50%" align="center"><font face="Tahoma" size="2"><b>
Suporte Técnico</b></font></td>
<td width="50%" align="center"><font face="Tahoma" size="2"><b>
Responsável Cliente</b></font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%" colspan="2"></td>
</tr>
<tr>
<td width="100%" colspan="2"></td>
</tr>
<tr>
<td width="10%"></td>
<td width="90%"></td>
</tr>
</table>
<p align="center"> <input type="submit" value="Alterar">
<input type="reset" value="Desfazer" name="reset">
</p>
<p> </p>
</td>
</tr>
</table>
</div>
<p> </p>
<p> </p>
<div align="justify"> </div>
<div align="justify"> </div>
<div align="justify"> </div>
<div align="justify"> </div>
<font face="arial" size="2">
</font></td>
</tr>
</table>
</form><form method="post" action="deletar.asp">
<input type="hidden" name="id" value="<%= lista("id")%>">
</form>
<p><%lista.MoveNext%><%loop%><%end if%>
Alterar
Started By mokus, 06/09/2003, 03:52
1 reply to this topic
#2
gnomo
-
- Usuários
-
- 23 posts
Novato no fórum
- Sexo:Não informado
Posted 12/09/2003, 10:14
<%
Set DB = Server.CreateObject("ADODB.Connection")
cnpath="DBQ=" & server.mappath("email.mdb")
DB.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & cnpath
listar = "SELECT * FROM emails ORDER BY firma "
Set lista = DB.Execute(listar)
%>
<%if lista.EOF then%>
<p align="center"><b><font color="#FF0000" size="5">Não há usuários cadastrados <%else%> <%do while NOT lista.EOF%>
</font></b></p>
<form action="alterar.asp" method="post">
<input type="hidden" name="id" value="<%= lista("id")%>">
<table border="0" cellpadding="0" cellspacing="0" align="left" width="803">
<tr>
<td width="8"> </td>
<td width="795">
<div align="justify"> </div>
<div align="justify">
<p align="center"><img border="0" src="logodh.gif"></p>
<table border="0" cellpadding="0" cellspacing="0" align="left" width="655">
<tr>
<td width="6"> </td>
<td width="645">
<table border="0" width="100%">
<tr>
<td width="100%" colspan="2"><b>Firma:</b><font face="arial" size="2"><input type="text" name="firma" value="<%= lista("firma")%>" size="20"> </font></td>
</tr>
<tr>
<td width="100%" colspan="2"><b>Endereço:</b><font face="arial" size="2"><input type="text" name="lugar" value="<%= lista("lugar")%>" size="45">
</font></td>
</tr>
<tr>
<td width="100%" colspan="2"><b>Contato:</b><font face="arial" size="2"><input type="text" name="resp" value="<%= lista("resp")%>" size="20">
</font>
</td>
</tr>
<tr>
<td width="100%" colspan="2" style="border-bottom-style: solid"><b>
Relatório Técnico</b>
</td>
</tr>
<tr>
<td width="100%" colspan="2"><b>1- </b> <font face="arial" size="2">
<input type="text" name="dia" value="<%= lista("dia")%>" size="18"><input type="text" name="dia1" value="<%= lista("dia1")%>" size="6"><input type="text" name="dia2" value="<%= lista("dia2")%>" size="20"></font><b>
Horário
<input type="text" name="hora" size="2" value="<%=lista("hora")%>"><input type="text" name="hora1" size="2" value="<%=lista("hora1")%>">às
<input type="text" name="hora2" size="2" value="<%=lista("hora2")%>"><input type="text" name="hora3" size="2" value="<%=lista("hora3")%>"><font face="Tahoma" size="3">ID
</font> </b><font size="2" face="Arial, Helvetica, sans-serif" color="#FFFFFF"><input type="text" name="id1" value="<%=lista("id")%>" size="2">
</font></td>
</tr>
<tr>
<td width="100%" colspan="2"><b>Chamado Técnico: </b><input type="text" name="cham" size="70" value="<%=lista("cham")%>"></td>
</tr>
<tr>
<td width="100%" colspan="2"><textarea rows="12" name="cham2" cols="90"><%=lista("cham2")%></textarea></td>
</tr>
<tr>
<td width="100%" colspan="2"><b><font size="2" face="Tahoma">Posição
do Chamado:</font> <input type="text" name="pos" size="7" value="<%=lista("pos")%>"></b></td>
</tr>
<tr>
<td width="100%" height="21" style="border-bottom-style: solid"><font face="Tahoma" size="2"><b>
Pendências:</b></font></td>
</tr>
<tr>
<td width="100%" height="21"><textarea rows="6" name="pen" cols="90"><%=lista("pen")%></textarea></td>
</tr>
<tr>
<td width="100%" height="21">
<p> </td>
</tr>
<tr>
<td width="100%" height="21">
<table border="0" width="100%">
<tr>
<td width="50%" align="center"><font face="Tahoma" size="2">
______________________________________________</font></td>
<td width="50%" align="center"><font face="Tahoma" size="2">
______________________________________________</font></td>
</tr>
<tr>
<td width="50%" align="center"><input type="text" name="tecnico" size="15" value="<%=lista("tec")%>"></td>
<td width="50%" align="center"><font face="arial" size="2"><input type="text" name="paginainicial1" value="<%= lista("resp")%>" size="20">
</font>
</td>
</tr>
<tr>
<td width="50%" align="center"><font face="Tahoma" size="2"><b>
Suporte Técnico</b></font></td>
<td width="50%" align="center"><font face="Tahoma" size="2"><b>
Responsável Cliente</b></font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%" colspan="2"></td>
</tr>
<tr>
<td width="100%" colspan="2"></td>
</tr>
<tr>
<td width="10%"></td>
<td width="90%"></td>
</tr>
</table>
<p align="center"> <input type="submit" value="Alterar">
<input type="reset" value="Desfazer" name="reset">
</p>
<p> </p>
</td>
</tr>
</table>
</div>
<p> </p>
<p> </p>
<div align="justify"> </div>
<div align="justify"> </div>
<div align="justify"> </div>
<div align="justify"> </div>
<font face="arial" size="2">
</font></td>
</tr>
</table>
</form><form method="post" action="deletar.asp">
<input type="hidden" name="id" value="<%= lista("id")%>">
</form>
<p><br><%lista.MoveNext%><%loop%><%end if%>era só ter posto um <br> antes de <%lista.MoveNext%>
Valeu! :ok:
+ NOME - Tiago Monteiro Loeblein
+ E-MAIL - gnomo88@bol.com.br
+ SITE - www.superservicos.kit.net
+ E-MAIL - gnomo88@bol.com.br
+ SITE - www.superservicos.kit.net
1 user(s) are reading this topic
0 membro(s), 1 visitante(s) e 0 membros anônimo(s)
