esta es toda la pagina, quiero hacer una pagina de busqueda por numero de celular que me traiga el perfil de la persona registrada.
<form name="form2" method="post" action="busca_cel.asp">
<table width="190" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif">
<%
Set Con = Server.CreateObject ("ADODB.Connection")
Con.Open "driver={SQL Server};server=website; database=clubin; uid=sa;pwd=sa"
%>
<%
if request.form("telefono2") <> "" then
sql="SELECT UploadDT, nombre, alias, sexo, edad, telefono2, ciudad, hobbies, cuadre, SourceFileName FROM curriculumv WHERE telefono2.curriculumv = '"&telefono2&"'"
else
sql="SELECT UploadDT, nombre, alias, sexo, edad, telefono2, ciudad, hobbies, cuadre, SourceFileName FROM curriculumv"
end if
set rs = con.Execute(sql)
%>
</font><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong><br>
Buscar por Telefono Celular: <br>
<br>
<input name="telefono2" type="text" style="FONT-SIZE: 9pt" onBlur="MM_validateForm('telefono2','','RisNum');r eturn document.MM_returnValue" size="15" maxlength="11">
</strong></font><br> <br> <font size="1" face="Verdana, Arial, Helvetica, sans-serif"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="submit" name="enviar2" value="Buscar" style="FONT-SIZE: 7pt">
</font></font></font></font></font> <font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif">
<br>
<br>
<a href="index.asp"><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif"><<< Volver al Home</font></a></td>
</tr>
</table>
</form></td>
<td width="378" rowspan="2" align="left" valign="top"><table width="99%" height="84%" border="0" cellpadding="1" cellspacing="1" >
<tr>
<td width="2%" height="329" ><font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif"><br>
</font></td>
<td width="98%" valign="top"> <font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif">
<% Do while not RS.EOF %>
</font> <table width="100%" height="181" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="181" valign="top"><table width="100%" height="218" border="0" cellpadding="2" cellspacing="3">
<tr>
<td width="92" rowspan="5" align="center" valign="middle"><div align="left"></div>
<div align="left"></div>
<div align="left"></div>
<div align="center"><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif"><img src="<%= RS("SourceFileName")%>" width="90" height="120"></font></div></td>
<td width="265" height="24" colspan="2" ><div align="left"><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>Fecha:
</strong><%= RS("UploadDT")%></font>
</div>
<div align="center"></div></td>
</tr>
<tr >
<td height="24" colspan="2"><div align="left"><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif">
<strong>Nombre:</strong> </font><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif"><%= RS("nombre")%></font></div></td>
</tr>
<tr >
<td height="24" colspan="2" ><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>Alias:
</strong></font><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif"><%= RS("alias")%></font></td>
</tr>
<tr >
<td height="24" colspan="2" ><div align="left"><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>Edad:
</strong><%= RS("edad")%> años</font></div></td>
</tr>
<tr >
<td height="24" colspan="2"><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>Sexo:</strong>
</font><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif"><%= RS("sexo")%>
</font></td>
</tr>
<tr>
<td height="4" colspan="3"><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>Telefono
(Cel):</strong></font><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif">
<%= RS("telefono2")%></font></td>
</tr>
<tr>
<td height="4" colspan="3"><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>Ciudad:</strong></font><font color="#FFFFFF"><strong></strong></font><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif">
<%= RS("ciudad")%></font></td>
</tr>
<tr>
<td height="9" colspan="3"><font color="#FFFFFF"><strong><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Hobbies:
</font></strong></font><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif"><%= RS("hobbies")%></font></td>
</tr>
<tr>
<td height="21" colspan="3"><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>Cuadre
Perfecto :</strong></font><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif">
<%= RS("cuadre")%></font></td>
</tr>
</table></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="3" cellpadding="3">
<tr>
<td><div align="center"></div></td>
</tr>
</table>
<font color="#000000">
<hr>
</font><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif">
<%
RS.MoveNext()
Loop
%>
</font><font color="#FFFFFF"> </font><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif">
</font></td>
</tr>
</table></td>
</tr>
<tr>
<td height="173" valign="top"> </td>
</tr>
</table></td>
</tr>
</table>
<p> </p>
</td>
</tr>
<tr>
<td height="21" valign="top" background="registrate/bg4.jpg"><img src="registrate/bg8.jpg" width="730" height="67"></td>
</tr>
</table> </td>
</tr>
</table>
</body> |