
20/09/2005, 16:18
|
| | Fecha de Ingreso: noviembre-2003
Mensajes: 209
Antigüedad: 21 años, 5 meses Puntos: 0 | |
Gracias por responder pronto @padawan@.... este es el codigo que genero, puse en negrita la linea que creo hace referencia a el campo Foto de la BD's:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include file="Connections/ConexionNoticias.asp" -->
<%
Dim Recordset1__MMColParam
Recordset1__MMColParam = "1"
If (Request.QueryString("index") <> "") Then
Recordset1__MMColParam = Request.QueryString("index")
End If
%>
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_ConexionNoticias_STRING
Recordset1.Source = "SELECT * FROM TablaNoticias WHERE index = " + Replace(Recordset1__MMColParam, "'", "''") + ""
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
Recordset1_numRows = 0
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
//-->
</script>
</head>
<body background="ImagenesIndex/Background.jpg">
<table width="75" border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="2"><img src="ImagenesIndex/Banner.jpg" width="799" height="55"></td>
</tr>
<tr>
<td width="372"><font size="1" face="Verdana">Tuesday, September 20, 2005</font></td>
<td width="427"><div align="right"><font size="1" face="Verdana">Quick Links:
Apollo | México | Steering</font></div></td>
</tr>
</table>
<table width="799" border="0" cellpadding="0" cellspacing="0" bgcolor="#CCCCCC">
<tr>
<td height="19">
<div align="right"><font size="1" face="Verdana">Apollo> México>
Steering> Querétaro</font></div></td>
</tr>
</table>
<br>
<table width="646" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="646" bordercolor="#CCCCCC" bgcolor="eaeaea"><font size="3" face="Verdana"><strong><%=(Recordset1.Fields.Item( "PreNoticia").Value)%></strong></font></td>
</tr>
<tr>
<td bgcolor="eaeaea"><font size="2" face="Verdana"><%=(Recordset1.Fields.Item("Fecha") .Value)%></font></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td bgcolor="eaeaea"><font size="2" face="Verdana"><strong>Por: <%=(Recordset1.Fields.Item("Por").Value)%></strong></font></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td bgcolor="eaeaea"><font size="2" face="Verdana"><%=(Recordset1.Fields.Item("Noticia ").Value)%></font></td>
</tr>
</table> <p><%=(Recordset1.Fields.Item("Foto").Value)%> </p>
<p> </p>
<p> </p>
<div id="Layer1" style="position:absolute; left:662px; top:101px; width:140; height:505; z-index:1; background-color: eaeaea; layer-background-color: eaeaea; border: 1px none #000000;">
<table width="139" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#CCCCCC" bgcolor="#FFFFFF">
<tr>
<td bgcolor="336699"><div align="center"><font color="#FFFFFF" size="2" face="Verdana"><strong>Links</strong></font></div></td>
</tr>
<tr>
<td height="45" bgcolor="#FFFFFF"><img src="ImagenesIndex/Apollo.jpg" width="140" height="40"></td>
</tr>
<tr>
<td height="28" bgcolor="#FFFFFF"><img src="ImagenesIndex/Azteca.jpg" width="140" height="22"></td>
</tr>
<tr>
<td height="25" bgcolor="#FFFFFF"><img src="ImagenesIndex/Captura.jpg" width="140" height="20"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><img src="ImagenesIndex/Ethics.jpg" width="140" height="33"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><img src="ImagenesIndex/planpensiontitle.jpg" width="140" height="38"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><img src="ImagenesIndex/Clima.jpg" width="140" height="27"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><img src="ImagenesIndex/Pta68.jpg" width="140" height="40"></td>
</tr>
</table>
</div>
</body>
</html>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%> |