Problemas na pagina de imprimir.asp

paulofbc · Abril 2, 2004

E aê pessoal,

Estou com um problema na pagina de imprimir.asp do meu sistema de noticias, tipo, quando eu clico no link imprimir noticia, ele abre um pop up (que deveria ter a noticia que eu estou lendo), mas dentro deste pop up nao tem a noticia que eu quero, aparece uma outra noticia que esta dentro do meu banco de dados.

Dêem uma olhada na pagina CLICANDO AQUI em seguida clique no link abaixo da noticia, imprima essa noticia, reparem que a noticia que se abre nao é a mesma que voce quer que imprima.

O Rafael do forum do MxStudio esta me ajudando muito, mas tem alguma coisa que nós nao estamos conseguindo enchergar de erro.

Aguardo resposta de voces.

abraços

Paulo

hargon · Abril 2, 2004

Posta o código da página imprimir.asp

Posta tbm o código que exibe a noticia na pagina que você indicou!

paulofbc · Abril 2, 2004

E ae, beleza?

ae vai

exibe.asp

<% ultimos = "5" 'numero de noticias na pagina ultimas.aspdb = "noticias/admin/dados/farolbr" 'caminho pro db sem .mdb, NÀO MUDE%><%Set Conexao = CreateObject("ADODB.CONNECTION")conStr ="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.MapPath(db)ConexaoAberta = FALSESub AbreConexao()	if not ConexaoAberta then	Conexao.Open ConStr	ConexaoAberta = True	end ifend subSub FechaConexao()	if ConexaoAberta then	Conexao.close	ConexaoAberta = False	end ifend sub %><html><head><title>FAROLBR - Conheça o mundo em segundos, navegue !!!</title><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><link rel="stylesheet" href="images/style.css" type="text/css"><link rel="stylesheet" href="images/style2.CSS" type="text/css"><script src="images/h.js"></SCRIPT><script language="JavaScript"><!--function MM_preloadImages() { //v3.0  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}}function MM_findObj(n, d) { //v4.0  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);  if(!x && document.getElementById) x=document.getElementById(n); return x;}function MM_nbGroup(event, grpName) { //v3.0  var i,img,nbArr,args=MM_nbGroup.arguments;  if (event == "init" && args.length > 2) {    if ((img = MM_findObj(args[2])) != null && !img.MM_init) {      img.MM_init = true; img.MM_up = args[3]; img.MM_dn = img.src;      if ((nbArr = document[grpName]) == null) nbArr = document[grpName] = new Array();      nbArr[nbArr.length] = img;      for (i=4; i < args.length-1; i+=2) if ((img = MM_findObj(args[i])) != null) {        if (!img.MM_up) img.MM_up = img.src;        img.src = img.MM_dn = args[i+1];        nbArr[nbArr.length] = img;    } }  } else if (event == "over") {    document.MM_nbOver = nbArr = new Array();    for (i=1; i < args.length-1; i+=3) if ((img = MM_findObj(args[i])) != null) {      if (!img.MM_up) img.MM_up = img.src;      img.src = (img.MM_dn && args[i+2]) ? args[i+2] : args[i+1];      nbArr[nbArr.length] = img;    }  } else if (event == "out" ) {    for (i=0; i < document.MM_nbOver.length; i++) {      img = document.MM_nbOver[i]; img.src = (img.MM_dn) ? img.MM_dn : img.MM_up; }  } else if (event == "down") {    if ((nbArr = document[grpName]) != null)      for (i=0; i < nbArr.length; i++) { img=nbArr[i]; img.src = img.MM_up; img.MM_dn = 0; }    document[grpName] = nbArr = new Array();    for (i=2; i < args.length-1; i+=2) if ((img = MM_findObj(args[i])) != null) {      if (!img.MM_up) img.MM_up = img.src;      img.src = img.MM_dn = args[i+1];      nbArr[nbArr.length] = img;  } }}//--></script></head><body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_preloadImages('images/topo_r4_c4_f3.gif','images/topo_r4_c4_f2.gif','images/topo_r4_c6_f3.gif','images/topo_r4_c6_f2.gif','images/topo_r4_c8_f3.gif','images/topo_r4_c8_f2.gif')"><table border="0" cellpadding="0" cellspacing="0" width="778" align="center">  <form name=formRadix2 onSubmit="return formRadix_checkForm2(this)">    <tr>       <td><img src="images/spacer.gif" width="305" height="1" border="0" alt=""></td>      <td><img src="images/spacer.gif" width="194" height="1" border="0" alt=""></td>      <td><img src="images/spacer.gif" width="58" height="1" border="0" alt=""></td>      <td><img src="images/spacer.gif" width="30" height="1" border="0" alt=""></td>      <td><img src="images/spacer.gif" width="36" height="1" border="0" alt=""></td>      <td><img src="images/spacer.gif" width="54" height="1" border="0" alt=""></td>      <td><img src="images/spacer.gif" width="26" height="1" border="0" alt=""></td>      <td><img src="images/spacer.gif" width="49" height="1" border="0" alt=""></td>      <td><img src="images/spacer.gif" width="26" height="1" border="0" alt=""></td>      <td><img src="images/spacer.gif" width="1" height="1" border="0" alt=""></td>    </tr>    <tr>       <td colspan="9"><img name="topo_r1_c1" src="images/topo_r1_c1.gif" width="778" height="16" border="0" alt="" usemap="#topo_r1_c1Map"></td>      <td><img src="images/spacer.gif" width="1" height="16" border="0" alt=""></td>    </tr>    <tr>       <td rowspan="2"><img name="topo_r2_c1" src="images/topo_r2_c1.gif" width="305" height="93" border="0" alt="" usemap="#topo_r2_c1Map"></td>      <td colspan="8" background="images/topo_r2_c2.gif">         <!--#INCLUDE FILE="01default.asp"-->      </td>      <td><img src="images/spacer.gif" width="1" height="68" border="0" alt=""></td>    </tr>    <tr>       <td colspan="8"><img name="topo_r3_c2" src="images/topo_r3_c2.gif" width="473" height="25" border="0" alt=""></td>      <td><img src="images/spacer.gif" width="1" height="25" border="0" alt=""></td>    </tr>    <tr>       <td rowspan="2" colspan="2" background="images/topo_r4_c1.gif">         <table width="100%" border="0" cellspacing="0" cellpadding="0" height="24">          <tr>             <td width="15%" height="24" align="right"><a href="http://batepapo.farolbr.com.br/"             target=_blank><img border=0 height=7             src="images/batepapo.gif"             vspace=8 width=63></a></td>            <td width="28%" height="24">               <table border=0 cellpadding=1 cellspacing=2>                <tbody>                 <tr>                   <td valign="top">                     <select name=select2                     size=1 class="contato" id=select6>                      <option selected value=0>Escolha o grupo</option>                      <option value=0>Por Idade</option>                      <option                     value=1>Cidades</option>                      <option value=2>Tema Livre</option>                      <option value=3>Variados</option>                      <option                     value=4>Encontros</option>                      <option                   value=5>Sexo</option>                    </select>                  </td>                  <td valign=middle>                     <input name="image22"                   type=image                   src="images/ok.gif" width=18 height=15 border=0 cache>                  </td>                </tr>                </tbody>               </table>            </td>            <td width="15%" height="24" align="right"><a href="http://batepapo.farolbr.com.br/"             target=_blank><img border=0 height=7             src="images/busca.gif"             vspace=8 width=53></a></td>            <td height="24" valign="top">               <table border=0 cellpadding=1 cellspacing=2>                <tbody>                 <tr>                   <td width="59" ><b>                     <input class=contato                   style="WIDTH: 90px" name=exp>                    </b> </td>                  <td >                     <select                   class=contato style="WIDTH: 100px" name=engine>                      <option>----------------- </option>                      <option value="Farol">no Farol BR</option>                      <option value="Yahoo">no Yahoo! Brasil </option>                      <option value="Google">no Google</option>                    </select>                  </td>                  <td valign=middle >                     <input type=image                   src="images/ok.gif"                   border=0 name="image">                  </td>                </tr>                </tbody>               </table>            </td>            <td width="0%" height="24"> </td>          </tr>        </table>      </td>      <td rowspan="3"><img name="topo_r4_c3" src="images/topo_r4_c3.gif" width="58" height="27" border="0" alt=""></td>      <td><a href="index.asp" onMouseOut="MM_nbGroup('out');" onMouseOver="MM_nbGroup('over','topo_r4_c4','images/topo_r4_c4_f2.gif','images/topo_r4_c4_f3.gif',1);" onClick="MM_nbGroup('down','navbar1','topo_r4_c4','images/topo_r4_c4_f3.gif',1);"><img name="topo_r4_c4" src="images/topo_r4_c4.gif" width="30" height="5" border="0" alt=""></a></td>      <td rowspan="3"><img name="topo_r4_c5" src="images/topo_r4_c5.gif" width="36" height="27" border="0" alt=""></td>      <td><a href="http://webmail.farolbr.com/" onMouseOut="MM_nbGroup('out');" onMouseOver="MM_nbGroup('over','topo_r4_c6','images/topo_r4_c6_f2.gif','images/topo_r4_c6_f3.gif',1);" onClick="MM_nbGroup('down','navbar1','topo_r4_c6','images/topo_r4_c6_f3.gif',1);"><img name="topo_r4_c6" src="images/topo_r4_c6.gif" width="54" height="5" border="0" alt=""></a></td>      <td rowspan="3"><img name="topo_r4_c7" src="images/topo_r4_c7.gif" width="26" height="27" border="0" alt=""></td>      <td><a href="suporte.asp" onMouseOut="MM_nbGroup('out');" onMouseOver="MM_nbGroup('over','topo_r4_c8','images/topo_r4_c8_f2.gif','images/topo_r4_c8_f3.gif',1);" onClick="MM_nbGroup('down','navbar1','topo_r4_c8','images/topo_r4_c8_f3.gif',1);"><img name="topo_r4_c8" src="images/topo_r4_c8.gif" width="49" height="5" border="0" alt=""></a></td>      <td rowspan="3"><img name="topo_r4_c9" src="images/topo_r4_c9.gif" width="26" height="27" border="0" alt=""></td>      <td><img src="images/spacer.gif" width="1" height="5" border="0" alt=""></td>    </tr>    <tr>       <td rowspan="2"><img name="topo_r5_c4" src="images/topo_r5_c4.gif" width="30" height="22" border="0" alt=""></td>      <td rowspan="2"><img name="topo_r5_c6" src="images/topo_r5_c6.gif" width="54" height="22" border="0" alt=""></td>      <td rowspan="2"><img name="topo_r5_c8" src="images/topo_r5_c8.gif" width="49" height="22" border="0" alt=""></td>      <td><img src="images/spacer.gif" width="1" height="21" border="0" alt=""></td>    </tr>    <tr>       <td colspan="2"><img name="topo_r6_c1" src="images/topo_r6_c1.gif" width="499" height="1" border="0" alt=""></td>      <td><img src="images/spacer.gif" width="1" height="1" border="0" alt=""></td>    </tr>  </form></table><table border="0" cellspacing="0" cellpadding="0" width="778" align="center" height="50">  <tr>     <td background="images/menu_barra1.gif" valign="top" width="155"><!--#include file="menu.asp"--></td>    <td background="images/bg_produtos.gif" valign="top">   <table width="100%" border="0" cellspacing="0" cellpadding="0">        <tr>           <td colspan="2" align="center"><img height=4 src="inicial/x.gif"                   width=10></td>        </tr>        <tr>                 <td  colspan="2" align="center"> </td>        </tr>        <tr>           <td width="2%"><img height=10 src="inicial/x.gif"                   width=10></td>          <td width="98%"> </td>        </tr>        <tr>           <td height="272"><img height=280 src="inicial/x.gif"                   width=10></td>                <td align="center" valign="top">         <table width="97%" border="0" cellspacing="0" cellpadding="0" align="left">              <tr>                 <td width="1%"> </td>                <td width="99%"><font face="Verdana, Arial, Helvetica, sans-serif"><b><font color="#CC3333">NOTÍCIAS</font></b></font></td>              </tr>              <tr>                 <td width="1%"> </td>                <td width="99%"> </td>              </tr>              <tr>                 <td width="1%"> </td>                <td width="99%"><strong><font face="Verdana, Arial, Helvetica, sans-serif">                   <script language="JavaScript">function abrir(URL) {  var width = 600;  var height = 450;  var left = 5;  var top = 5;  window.open('imprimir.asp','titulo', 'width='+width+', height='+height+', top='+top+', left='+left+', scrollbars=yes, status=yes, toolbar=no, location=no, directories=no, menubar=no, resizable=yes, fullscreen=no');}</script>                  <% AbreConexaoid = request.querystring("id")SQL = "SELECT * FROM noticias where id_noticia = " & id & " ORDER BY id_noticia DESC"Set rs = Conexao.Execute(SQL)While not rs.EOF %>                  <font face="Verdana, Arial, Helvetica, sans-serif"> <%=rs("data_alt")%></font><font size="2">-                   </font><font color="#000000" face="Verdana, Arial, Helvetica, sans-serif"><%=Rs("titulo")%></font><br>                  <br><br><br><br><font color="#000000" face="Verdana, Arial, Helvetica, sans-serif"><%=Rs("texto")%></font><br><br><a href="javascript:abrir('imprimir.asp?id=<%=id%>');">Clique aqui para imprimir essa notícia!</a>                  <% rs.MoveNextWendrs.closeFechaConexaoSet rs = nothing %>                  </font></td>              </tr>              <tr>                <td> </td>                <td> </td>              </tr>              <tr>                 <td> </td>                <td> </td>              </tr>              <tr>                 <td width="1%"> </td>                <td width="99%"> </td>              </tr>              <tr valign="top">                 <td colspan="2" height="26"><font face="Verdana" size="2">                   <table border="0" cellpadding="0" cellspacing="3" width="100%" bordercolorlight="#FFFFFF">                    <tr>                       <td bgcolor="#CC3333"><font face="Verdana, Arial, Helvetica, sans-serif" color="#000000"><b><font color="#FFFFFF"> Notícias                         anteriores</font></b></font></td>                    </tr>                    <tr>                       <td bgcolor="#E2E9F0"><font face="Verdana, Arial, Helvetica, sans-serif"><font color="#FFFFFF">                         </font><font face="Verdana, Arial, Helvetica, sans-serif" color="#000000">                         </font></font> <table width="100%" border="0" cellspacing="4" cellpadding="0">                          <tr>                             <td><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif" color="#000000">                               </font> <font face="Verdana, Arial, Helvetica, sans-serif" color="#000000">                               <%AbreConexaoSQL = "SELECT * FROM noticias where tipo = '1' ORDER BY id_noticia DESC"Set rs = Conexao.Execute(SQL)While not rs.EOF%>                              </font><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><b><font color="#000000"><%=rs("data_alt")%></font></b></font></font><font face="Verdana, Arial, Helvetica, sans-serif" color="#6699CC"></font><font face="Verdana, Arial, Helvetica, sans-serif" color="#000000">                               <font size="2">-</font><a href="exibe.asp?id=<%=rs("id_noticia")%>">                               <%=Rs("titulo")%></a><br>                              <% rs.MoveNextWendrs.closeFechaConexaoSet rs = nothing %>                              </font><font face="Verdana, Arial, Helvetica, sans-serif" color="#000000">                               </font></font></td>                          </tr>                        </table>                        <font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif" color="#000000">                         </font><font color="#FFFFFF"> </font></font></td>                    </tr>                    <tr>                       <td><br> </td>                    </tr>                  </table>                  </font></td>              </tr>            </table>      </td>        </tr>      </table>    </td>  </tr></table><table width="778" border="0" cellspacing="0" cellpadding="0" align="center">  <tr>     <td><img src="images/rodape.gif" width="778" height="40" usemap="#Map" border="0"></td>  </tr></table><map name="Map">   <area shape="rect" coords="486,27,722,39" href="http://www.webzero.com.br/" target="_blank"></map><map name="topo_r1_c1Map">   <area shape="rect" coords="666,4,796,13" href="index.asp"></map><map name="topo_r2_c1Map">   <area shape="rect" coords="8,1,227,72" href="index.asp"></map></BODY></HTML>

imprimir.asp

<% ultimos = "5" 'numero de noticias na pagina ultimas.aspdb = "noticias/admin/dados/farolbr" 'caminho pro db sem .mdb, NÀO MUDE%><%Set Conexao = CreateObject("ADODB.CONNECTION")conStr ="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.MapPath(db)ConexaoAberta = FALSESub AbreConexao()if not ConexaoAberta thenConexao.Open ConStrConexaoAberta = Trueend ifend subSub FechaConexao()if ConexaoAberta thenConexao.closeConexaoAberta = Falseend ifend sub %><html><head><title>FAROLBR - Conheça o mundo em segundos, navegue !!!</title><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><link rel="stylesheet" href="images/style.css" type="text/css"><link rel="stylesheet" href="images/style2.css" type="text/css"><script src="images/h.js"></SCRIPT></head><body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"><%id = Request.Querystring("id")AbreConexaoSQL = "SELECT * FROM noticias WHERE id_noticia " & id & " ORDER BY id_noticia DESC"Set rs = Conexao.Execute(SQL) %>  <%=RS("data_alt")%>  <%=RS("titulo")%><br><br><p align="justify"><%=RS("texto")%></p><br><a href="javascript:self.print();">Imprimir</a><% FechaConexao %></BODY></HTML>

Abraços

Paulo

paulofbc · Abril 2, 2004

E ae krinha, eu já consegui, valew

Entrar

Arquivado

Problemas na pagina de imprimir.asp

Recommended Posts

paulofbc 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

hargon 64

Compartilhar este post

Link para o post

Compartilhar em outros sites

paulofbc 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

paulofbc 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

Fixar div até atingir uma certa altura

Ajuda com Extends e envio para o banco

PHP+Codeginiter - Orientação para Impressão

Este projeto é apoiado pelas empresas

Fóruns

Tempo Real

Informação importante