Jump to content


ricardo_moura

Member Since 04/05/2005
Offline Last Active 05/07/2008, 08:58
-----

Topics I've Started

Ler Banco De Dados Sem Criar Duas Tabelas Como?

04/07/2008, 22:50

Olá gente td bom?.
Bom estou com uma dúvida, estou criando um banco de dados para uma academia atualizar sua seção de horários com as aulas, a pagina orignal em html está assim:

Posted Image

O que fiz em asp ficou assim:

Posted Image

O código que usei está abaixo:

<?xml version="1.0" encoding="iso-8859-1"?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /><title>Untitled Document</title><style type="text/css"><!--.style1 {	color: #FF6600;	font-size: 14px;	font-weight: bold;}.style2 {	font-family: Arial, Helvetica, sans-serif;	font-size: 12px;}--></style></head><body link="#000000" leftmargin="0"><STYLE type=text/css>BODY {SCROLLBAR-FACE-COLOR: white;SCROLLBAR-HIGHLIGHT-COLOR: white;SCROLLBAR-SHADOW-COLOR: #DEDEDC;SCROLLBAR-3DLIGHT-COLOR: #DEDEDC;SCROLLBAR-ARROW-COLOR: #000053; SCROLLBAR-DARKSHADOW-COLOR: #000053; SCROLLBAR-BASE-COLOR: #DEDEDC;}</STYLE><%strConnection = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("horarios.mdb") & ";"Set adoDataConn = Server.CreateObject("ADODB.Connection")adoDataConn.Open strConnection 	  strQuery = "SELECT * FROM ginastica"   	  Set RS = adoDataConn.Execute(strQuery)          While not RS.eof 	  %><table width="93%" height="70" border="0" cellpadding="0" cellspacing="0">  <tr>    <td>&nbsp;</td>    <td><p class="style1"><font color="#FF6600"><strong>GIN&Aacute;STICA </strong></font><font color="#000000" >- </a> <a href='java script:;' onClick='window.print();return false'>imprimir</a></a></font><br /></p>      <table width="100%" border="1" cellspacing="0" cellpadding="0">        <tr>          <td width="11%" bordercolor="#333333"><div align="center"><font size="2"><strong><font face="Arial, Helvetica, sans-serif">IN&Iacute;CIO</font></strong></font></div>          </td>          <td width="11%" bordercolor="#333333"><div align="center"><font size="2"><strong><font face="Arial, Helvetica, sans-serif">T&Eacute;RMINO</font></strong></font></div>          </td>          <td width="15%" bordercolor="#000000"><div align="center"><font size="2"><strong><font face="Arial, Helvetica, sans-serif">SEGUNDA</font></strong></font></div>          </td>          <td width="15%" bordercolor="#000000"><div align="center"><font size="2"><strong><font face="Arial, Helvetica, sans-serif">TER&Ccedil;A</font></strong></font></div>          </td>          <td width="15%" bordercolor="#000000"><div align="center"><font size="2"><strong><font face="Arial, Helvetica, sans-serif">QUARTA</font></strong></font></div>          </td>          <td width="15%" bordercolor="#000000"><div align="center"><font size="2"><strong><font face="Arial, Helvetica, sans-serif">QUINTA</font></strong></font></div>          </td>          <td width="15%" bordercolor="#000000"><div align="center"><font size="2"><strong><font face="Arial, Helvetica, sans-serif">SEXTA</font></strong></font></div>          </td>        </tr>        <tr>          <td bordercolor="#333333"><div align="center"><strong><%Response.Write RS("incioaula") %></strong></div>          </td>          <td bordercolor="#333333"><div align="center"><strong><font size="2" face="Arial, Helvetica, sans-serif">07:40</font></strong></div>          </td>          <td bgcolor="#666666"><div align="center"><font size="2" face="Arial, Helvetica, sans-serif">&nbsp;</font><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><strong>Nat.                adulto</strong></font></div></td>          <td bgcolor="#666666"><div align="center"><font size="2" face="Arial, Helvetica, sans-serif">&nbsp;</font><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><strong>Nat.          adt. inic.</strong></font></div></td>          <td bgcolor="#666666"><div align="center"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><strong>Nat.          adulto</strong></font></div></td>          <td bgcolor="#666666"><div align="center"><font size="2" face="Arial, Helvetica, sans-serif">&nbsp;</font><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><strong>Nat.          adt. inic.</strong></font></div></td>          <td bgcolor="#666666"><font size="2" face="Arial, Helvetica, sans-serif">&nbsp;</font></td>        </tr>        <tr>          <td bordercolor="#333333"><div align="center"><strong><font size="2" face="Arial, Helvetica, sans-serif">07:40</font></strong></div>          </td>          <td bordercolor="#333333"><div align="center"><strong><font size="2" face="Arial, Helvetica, sans-serif">08:30</font></strong></div>          </td>          <td bgcolor="#666666"><div align="center"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><strong>Hidro</strong></font></div></td>          <td bgcolor="#666666"><div align="center"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><strong>Hidro</strong></font></div></td>          <td bgcolor="#666666"><div align="center"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><strong>Hidro</strong></font><font size="2" face="Arial, Helvetica, sans-serif"></font></div></td>          <td bgcolor="#666666"><div align="center"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><strong>Hidro</strong></font></div></td>          <td bgcolor="#666666"><div align="center"><font size="2" face="Arial, Helvetica, sans-serif"></font></div>                <p align="justify" class="style2">&nbsp;</p></td>  	</td>        </tr>      </table>  </tr> </table> <%      RS.MoveNext     wend   RS.CloseadoDataConn.Close%></body></html>

Sou novo com programação em asp, se poderem me ajudar aonde eu errei pq esta duplicando duas colunas, eu agradeço! valeu

IPB Skin By Virteq