Explicar melhor coloca o código! Pessoal assim, tenho uma tabela com varios registros de um sistema aqui da empresa. O que quero é dentro dessa tabela conseguir fazer o filtro. Por exemplo tem lá 5 vezes em lugares diferente o registro "Maria" quero poder clicar nesse registro e a tela fazer um upload e só aparecer as linhas onde tem o registro "Maria" Essa é minha ideia...o que eu já fiz foi o filtro...se eu clico em "Maria" aparece a mesma tela só que onde tinha "Maria" fica como se o link já tivesse sido clicado... Mas se eu clicar em "Maria", "Jose", "Joao" ficam todos iguais e a ideia de filtro some.. Meu código ... <!--#include file="conectando.asp"-->
<!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>Multiplus - Software Técnicos</title>
<style type="text/css">
<!--
.link02 { font-family: Arial, Helvetica, sans-serif;
font-style: normal;
line-height: normal;
text-decoration: none;
color:#000000;
font-size: 12px;
font-weight: bold;
}
.style6 {font-family: Arial, Helvetica, sans-serif; font-size: 18px; }
a:link {
color: #000000;
text-decoration: none;
}
a:visited {
text-decoration: none;
color: #0000FF;
}
a:hover {
text-decoration: none;
color: #FF0000;
}
a:active {
text-decoration: none;
}
.style9 {font-size: 12px}
.style10 {
font-family: Arial, Helvetica, sans-serif;
font-size: 16px;
font-weight: bold;
}
.style11 {color: #FF0000}
-->
</style>
</head>
<%
vdata = request.querystring ("data")
vcodigo = request.querystring ("codigo")
vusuario = request.querystring ("usuario")
vddd = request.querystring ("ddd")
vtipo = request.querystring ("tipo")
vsoftware = request.querystring ("software")
vdata = request.querystring ("data")
If data <> "" Then
sql = "Select * From suptec where data='"&vdata&"' and pendencia = true ORDER BY data DESC"
End If
vcodigo = request.querystring ("codigo")
If vcodigo <> "" Then
sql = "Select * From suptec where codigo='"&vcodigo&"' and pendencia = true ORDER BY data DESC"
End If
vusuario = request.querystring ("usuario")
If vusuario <> "" Then
sql = "Select * From suptec where usuario='"&vusuario&"' and pendencia = true ORDER BY data DESC"
End If
vddd = request.querystring ("ddd")
If vddd <> "" Then
sql = "Select * From suptec where ddd='" & vddd &"' and pendencia = true ORDER BY data DESC"
End If
vtipo = request.querystring ("tipo")
If vtipo <> "" Then
sql = "Select * From suptec where tipo='" & vtipo &"' and pendencia = true ORDER BY data DESC"
End If
vsoftware = request.querystring ("software")
If vsoftware <> "" Then
sql = "Select * From suptec where software='" & vsoftware&"' and pendencia = true ORDER BY data DESC"
End If
Set rs = bco.Execute(sql)
if rs.eof then
Response.Write("<p align=""center"">NÃO HÁ PENDENCIAS</p>")
else
%>
<body>
<div id="Layer1" style="position:absolute; left:10px; top:10px; width:990px; height:580px; z-index:1; overflow:auto;">
<form>
<table width="427" border="1" align="center">
<tr>
<td width="135"><div align="center"><span class="style6"><a href="../suporte/indice.asp">Indice - SIM</a></span></div></td>
<td width="135"><div align="center"><span class="style6"><a href="relatorio_total.asp">Total</a></span></div></td>
<td width="135"><div align="center"><a href="relatorio_resolvidas.asp"><span class="style6">Solucionadas</span></a></div></td>
</tr>
</table>
<p><input name="id" type="hidden" id="id" value="<%=rs("id")%>">
</p>
<table width="513" border="1" align="center" cellspacing="1" bordercolor="#CCCCCC">
<tr>
<td colspan="9"><div align="center"><span class="style10">Dúvidas do SIM - <span class="style11">PENDÊNCIAS </span></span></div></td>
</tr>
<tr>
<td><div align="center"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold">Data</span></div></td>
<td><div align="center"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold">Código</span></div></td>
<td><div align="center"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold">Usuario</span></div></td>
<td><div align="center"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold">Contato</span></div></td>
<td><div align="center"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold">DDD</span></div></td>
<td><div align="center"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold">Tipo</span></div></td>
<td><div align="center"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold">Software</span></div></td>
<td><div align="center"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold">Assunto</span></div></td>
<td><div align="center"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold">Resposta</span></div></td>
</tr>
<%
contado=0
Do While Not rs.eof
contador=contador+1
%>
<tr>
<td nowrap="nowrap"><div align="center"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;"><a href="relatorio_FILTRO.asp?data=<%=rs("data")%>"><%=rs("data")%></a></span></div></td>
<td nowrap="nowrap"><div align="left"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;"><a href="relatorio_FILTRO.asp?codigo=<%=rs("codigo")%>"><%=rs("codigo")%></a></span></div></td>
<td nowrap="nowrap"><div align="left"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;"><a href="relatorio_FILTRO.asp?usuario=<%=rs("usuario")%>"><%=rs("usuario")%></a></span></div></td>
<td nowrap="nowrap"><div align="left"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;"><%=rs("contato")%></span></div></td>
<td nowrap="nowrap"><div align="left"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;"><a href="relatorio_FILTRO.asp?ddd=<%=rs("ddd")%>"><%=rs("ddd")%></a></span></div></td>
<td nowrap="nowrap"><div align="left"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;"><a href="relatorio_FILTRO.asp?tipo=<%=rs("tipo")%>"><%=rs("tipo")%></a></span></div></td>
<td nowrap="nowrap"><div align="left"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;"><a href="relatorio_FILTRO.asp?software=<%=rs("software")%>"><%=rs("software")%></a></span></div>
<div align="center"></div></td>
<td nowrap="nowrap"><div align="left"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;"><%=rs("resumo")%></span></div></td>
<td nowrap="nowrap"><div align="center">
<div align="center"><a href="resposta_suporte.asp?id=<%=rs("id")%>" class="link02 style9">[Responder]</a></div>
</div></td>
</tr>
<%
rs.Movenext
Loop
End if
rs.close
Set rs=nothing
bco.close
Set rs=nothing
%>
</table>
<br />
<hr width="80%" />
<br />
</form>
</div>
</body>
</html>