Hola, ¿alguien podria indicarme lo que me falta para que cuando busque en mi db me devuelva los resultados en la misma pagina?.
Aqui dejo el codigo.
Gracias
<html>
<title>Orden</title>
<link rel="stylesheet" href="_main.css" type="text/css">
<body bgcolor="#FFFFFF">
<p align="center"> </p>
<p align="left">
<table width="59%" border="0" align="center" bgcolor="#8CCCCA">
<tr>
<td width="30%" height="36">
<p align="center"><font face="Verdana"><b> LOGOTIPOS</b></font></p>
</td>
<td width="41%" valign="top" height="36">
<%
for counter = 65 to 90
' for next routine to create hyperlinks alphabetically targeted
' to the current page
%>
<a href="<%= request.servervariables("script_name")%>?u_letter= &#<%= counter %>;" class="select">
&#<%= counter %>;</a>
<% next %>
</td>
</tr>
<tr>
<td width="30%"><b>
<%
accessdb="dblogos"
if len(request.querystring("idlogo")) <> 0 then
set dbc = server.createobject("adodb.connection")
dbc.open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mappath(accessdb)
sql = "select * from logotipos where id=" & request.querystring("idlogo")
set rst = dbc.execute(sql)
if not rst.eof then
%>
<img border=1 name="tumbail" width=200 height=200 src="<%=rst("tumbail_img")%>">
<%
end if
end if
%>
</b></td>
<td width="41%" valign="top">
<%
u_letter=trim(request.querystring("u_letter"))
'if the user clicked a link then search the db
if u_letter<>"" then
accessdb="dblogos"
cn="DRIVER={Microsoft Access Driver (*.mdb)};"
cn=cn & "DBQ=" & server.mappath(accessdb)
Set rs = Server.CreateObject("ADODB.Recordset")
sql = "select * from logotipos where left(logo,1)='"& u_letter &"' order by logo asc"
rs.Open sql, cn
'if the search ends in no results display a
'no results found mesage
if rs.eof then
%>
<div align="left"><font color="#FF0000"><b>No se han encontrado logos</b></font>
<%= u_letter %>
<% else
do while not rs.eof
'display all observations found
%>
<br>
<a href="default.asp?u_letter=<%=u_letter%>&IdLogo=<% =rs("id")%>"><%= rs("logo")%></a>
<%
rs.movenext
loop
end if ' end check for obs
end if ' end check for user input
%>
</div>
</td>
</tr>
<tr>
<td width="30%">
<p><b>Descripcion</b><br>
</p>
</td>
<td width="41%" valign="top"> </td>
</tr>
<tr>
<td width="30%"><b>
<%
if len(request.querystring("idlogo")) <> 0 then
%>
<a href="<%=rst("archivo")%>">Descargar Logo</a>
<%
end if
%>
</b></td>
<td width="41%" valign="top">
<form name="Buscador" method="get" action="default.asp">
<input type="text" name="busca">
<input type="submit" name="Submit" value="Buscar">
</form>
</td>
</tr>
</table>
