Los Foros de ASPTutor.com
Home | Perfil | Registrarse | Temas Activos | Miembros | Buscar | FAQ
Usuario:
Password:
 Todos los Foros
 ASP
 mi codigo no genera resultados pero no da error
 Foro Bloqueado  Tema Bloqueado


Autor Temas
janty
Starting Member


18 Posts
Mensajes - 18 Aug 2004 :  18:30:21  Ver Perfil  Enviar Email
Estimad@s,
estoy usando el códico de Fernanda Eugenia situado en http://www.asptutor.com/asp/vartprint.asp?id=138 e intentando modificar sus ASP’s para presentar un motor de búsqueda de una base de datos que estoy generando. Consigo hacer funcionar el buscador con una base en access generada con los campos que ella pone en el ejemplo pero cuando modifico el codigo para incluir los 18 campos que tiene mi base de access no me da resultados, aunque no me señala ningún error de código.

Mi código para el resultados.asp es:
<%
Dim mostrar 'cantidad de registros a mostrar por página
Dim cant_paginas 'cantidad de páginas que recibimos
Dim pagina_actual 'La página que mostramos
Dim registro_mostrado 'Contador utilizado para mostrar las páginas
Dim I 'Variable Loop
Record = request.querystring("Record")
Number = request.querystring("Number")
PDB_ID = request.querystring("PDB_ID")
PDB_file = request.querystring("PDB_file")
PDB_file_2 = request.querystring("PDB_file_2")
Sequence = request.querystring("Sequence")
Matrix_FOLDx = request.querystring("Matrix_FOLDx")
Molecular_Surface = request.querystring("Molecular_Surface")
Ligand = request.querystring("Ligand")
Phosphorylated_residue_type = request.querystring("Phosphorylated_residue_type")
Experimental_Technique = request.querystring("Experimental_Technique")
Protein_Source = request.querystring("Protein_Source")
Title = request.querystring("Title")
Resolution = request.querystring("Resolution")
MedLine_ID = request.querystring("MedLine_ID")
Reference = request.querystring("Reference")
Protein_family = request.querystring("Protein_family")
Keywords = request.querystring("Keywords")
orden = request.querystring("orden")
alf = request.querystring("alf")
cantidad = request.querystring("cantidad")
if cantidad="10" then
mostrar = 10
elseif cantidad="20" then
mostrar = 20
elseif cantidad="30" then
mostrar = 30
elseif cantidad="50" then
mostrar = 50
elseif cantidad="75" then
mostrar = 75
elseif cantidad="100" then
mostrar = 100
end if
if orden = "" then
response.redirect "buscador.asp"
end if

' IF para saber qué página mostrar
If Request.QueryString("page") = "" Then
pagina_actual = 1
Else
pagina_actual = CInt(Request.QueryString("page"))
End If

strsql = "SELECT * FROM listado where UCase(Number) like '%" & UCase(Request("Number")) & "%' AND UCase(PDB_ID) like '%" & UCase(Request("PDB_ID")) & "%' AND UCase(PDB_file) like '%" & UCase(Request("PDB_file")) & "%' AND UCase(PDB_file_2) like '%" & UCase(Request("PDB_file_2")) & "%' AND UCase(Sequence) like '%" & UCase(Request("Sequence")) & "%' AND UCase(Matrix_FOLDx) like '%" & UCase(Request("Matrix_FOLDx")) & "%' AND UCase(Molecular_Surface) like '%" & UCase(Request("Molecular_Surface")) & "%' AND UCase(Ligand) like '%" & UCase(Request("Ligand")) & "%' AND UCase(Phosphorylated_residue_type) like '%" & UCase(Request("Phosphorylated_residue_type")) & "%' AND UCase(Experimental_Technique) like '%" & UCase(Request("Experimental_Technique")) & "%' AND UCase(Protein_Source) like '%" & UCase(Request("Protein_Source")) & "%' AND UCase(Title) like '%" & UCase(Request("Title")) & "%' AND UCase(Resolution) like '%" & UCase(Request("Resolution")) & "%' AND UCase(MedLine_ID) like '%" & UCase(Request("MedLine_ID")) & "%' AND UCase(Reference) like '%" & UCase(Request("Reference")) & "%' AND UCase(Protein_family) like '%" & UCase(Request("Protein_family")) & "%' AND UCase(Keywords) like '%" & UCase(Request("Keywords")) & "%' order by "& orden & " "&alf

Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ="&Server.MapPath("phosphoprotein103.mdb")

' creo el RecordSet y defino la cantidad de registros a mostrar
Set RS = Server.CreateObject("ADODB.Recordset")
RS.PageSize = mostrar
RS.CacheSize = mostrar

' Abro la tabla...
RS.Open strSQL, oConn,3,1
'cuento las páginas que se formaron con la variable mostrar
cant_paginas = RS.PageCount

' Si el pedido de página cae afuera del rango,
' lo modifico para que caiga adentro
If pagina_actual > cant_paginas Then pagina_actual = cant_paginas
If pagina_actual < 1 Then pagina_actual = 1
%>
<body style="background-color: #FFFFF4">
<%
' Si la cantidad de páginas da 0 es que no hay registros... por eso este IF
If cant_paginas = 0 Then%>

<p><font face="Arial"> We have found <font color="#FF0000"> <b>0</b> records</font></font></p>

<ul>
<li><font face="Arial"><a href="buscador.asp">New search</a></font></li>
<li><font face="Arial">
<a href="resultados.asp?orden=Number&PDB_ID=<%=PDB_ID%>&cantidad=10">Repetition the search without restrictions</a></font></li>
</ul>
<%
'sino, si es que encuentra registros
Else
' Nos movemos a la página elegida
RS.AbsolutePage = pagina_actual
' muestra el dato de la página en la que estamos...
%>
<div align="center">
<center>
<table border="1" cellspacing="1" style="border-width:0; border-collapse: collapse" bordercolor="#111111" width="80%" id="AutoNumber1">
<tr>
<td width="10%" bgcolor="#CCCCFF" style="border-left:medium none #111111; background-color: #DDDDFF; border-right-style:none; border-right-width:medium; border-top-style:none; border-top-width:medium; border-bottom-style:none; border-bottom-width:medium" align="center">
<p style="text-align: left"><b>
<font color="#003366" face="Arial" size="2">
Record </font></b></td>
<td width="10%" bgcolor="#CCCCFF" style="border-style: none; border-width: medium; background-color: #DDDDFF; text-align:center">
<b><font face="Arial" size="2" color="#003366">Number</font></b></td>
<td width="10%" bgcolor="#CCCCFF" style="border-style: none; border-width: medium; background-color: #DDDDFF" align="center">
<p align="center"><b><font face="Arial" size="2" color="#003366">PDB_ID</font></b></td>

<td width="10%" bgcolor="#CCCCFF" style="border-style: none; border-width: medium; background-color: #DDDDFF" align="center">
<p align="center"><b><font face="Arial" size="2" color="#003366">PDB_file</font></b></td>

<td width="10%" bgcolor="#CCCCFF" style="border-style: none; border-width: medium; background-color: #DDDDFF" align="center">
<p align="center"><b><font face="Arial" size="2" color="#003366">PDB_file_2</font></b></td>

<td width="10%" bgcolor="#CCCCFF" style="border-style: none; border-width: medium; background-color: #DDDDFF" align="center">
<p align="center"><b><font face="Arial" size="2" color="#003366">Sequence</font></b></td>

<td width="10%" bgcolor="#CCCCFF" style="border-style: none; border-width: medium; background-color: #DDDDFF" align="center">
<p align="center"><b><font face="Arial" size="2" color="#003366">Matrix_FOLDx</font></b></td>

<td width="10%" bgcolor="#CCCCFF" style="border-style: none; border-width: medium; background-color: #DDDDFF" align="center">
<p align="center"><b><font face="Arial" size="2" color="#003366">Molecular_Surface</font></b></td>

<td width="10%" bgcolor="#CCCCFF" style="border-style: none; border-width: medium; background-color: #DDDDFF" align="center">
<p align="center"><b><font face="Arial" size="2" color="#003366">Ligand</font></b></td>

<td width="10%" bgcolor="#CCCCFF" style="border-style: none; border-width: medium; background-color: #DDDDFF" align="center">
<p align="center"><b><font face="Arial" size="2" color="#003366">Phosphorylated_residue_type</font></b></td>

<td width="10%" bgcolor="#CCCCFF" style="border-style: none; border-width: medium; background-color: #DDDDFF" align="center">
<p align="center"><b><font face="Arial" size="2" color="#003366">Experimental_Technique</font></b></td>

<td width="10%" bgcolor="#CCCCFF" style="border-style: none; border-width: medium; background-color: #DDDDFF" align="center">
<p align="center"><b><font face="Arial" size="2" color="#003366">Protein_Source</font></b></td>

<td width="10%" bgcolor="#CCCCFF" style="border-style: none; border-width: medium; background-color: #DDDDFF" align="center">
<p align="center"><b><font face="Arial" size="2" color="#003366">Title</font></b></td>

<td width="10%" bgcolor="#CCCCFF" style="border-style: none; border-width: medium; background-color: #DDDDFF" align="center">
<p align="center"><b><font face="Arial" size="2" color="#003366">Resolution</font></b></td>

<td width="10%" bgcolor="#CCCCFF" style="border-style: none; border-width: medium; background-color: #DDDDFF" align="center">
<p align="center"><b><font face="Arial" size="2" color="#003366">MedLine_ID</font></b></td>

<td width="10%" bgcolor="#CCCCFF" style="border-style: none; border-width: medium; background-color: #DDDDFF" align="center">
<p align="center"><b><font face="Arial" size="2" color="#003366">Reference</font></b></td>

<td width="10%" bgcolor="#CCCCFF" style="border-style: none; border-width: medium; background-color: #DDDDFF" align="center">
<p align="center"><b><font face="Arial" size="2" color="#003366">Protein_family</font></b></td>

<td width="10%" bgcolor="#CCCCFF" style="border-right:medium none #111111; background-color: #DDDDFF; border-left-style:none; border-left-width:medium; border-top-style:none; border-top-width:medium; border-bottom-style:none; border-bottom-width:medium" align="center">
<p align="center" style="text-align: center">
<b><font face="Arial" size="2" color="#003366">Keywords</font></b></td>
</tr>
<%

' Hacemos el bucle mostrando los datos del registro
registro_mostrado = 0
Do While registro_mostrado < mostrar And Not RS.EOF
if colorfila = 0 then
color= "#FFFFFF"
colorfila=1
else
color="#F3F3F3"
colorfila=0
end if
%>

<tr>
<td width="10%" align="center" style="border-style:none; border-width:medium; background-color: <%= color %>; text-align:center; "><font face="Arial" size="2"><b><%=RS("Record")%></b> </td>
<td width="10%" align="center" style="border-style:none; border-width:medium; background-color: <%= color %>; text-align:center; "><font face="Arial" size="2"><%=RS("Number")%></a></font> </td>
<td width="10%" align="center" style="border-style:none; border-width:medium; background-color: <%= color %>; text-align:center; "><font face="Arial" size="2"><%=RS("PDB_ID")%> </td>
<td width="10%" align="center" style="border-style:none; border-width:medium; background-color: <%= color %>; text-align:center; "><font face="Arial" size="2"><%=RS("PDB_file")%> </td>
<td width="10%" align="center" style="border-style:none; border-width:medium; background-color: <%= color %>; text-align:center; "><font face="Arial" size="2"><%=RS("PDB_file_2")%> </td>
<td width="10%" align="center" style="border-style:none; border-width:medium; background-color: <%= color %>; text-align:center; "><font face="Arial" size="2"><%=RS("Sequence")%> </td>
<td width="10%" align="center" style="border-style:none; border-width:medium; background-color: <%= color %>; text-align:center; "><font face="Arial" size="2"><%=RS("Matrix_FOLDx")%> </td>
<td width="10%" align="center" style="border-style:none; border-width:medium; background-color: <%= color %>; text-align:center; "><font face="Arial" size="2"><%=RS("Molecular_Surface")%> </td>
<td width="10%" align="center" style="border-style:none; border-width:medium; background-color: <%= color %>; text-align:center; "><font face="Arial" size="2"><%=RS("Ligand")%> </td>
<td width="10%" align="center" style="border-style:none; border-width:medium; background-color: <%= color %>; text-align:center; "><font face="Arial" size="2"><%=RS("Phosphorylated_residue_type")%> </td>
<td width="10%" align="center" style="border-style:none; border-width:medium; background-color: <%= color %>; text-align:center; "><font face="Arial" size="2"><%=RS("Experimental_Technique")%> </td>
<td width="10%" align="center" style="border-style:none; border-width:medium; background-color: <%= color %>; text-align:center; "><font face="Arial" size="2"><%=RS("Protein_Source")%> </td>
<td width="10%" align="center" style="border-style:none; border-width:medium; background-color: <%= color %>; text-align:center; "><font face="Arial" size="2"><%=RS("Title")%> </td>
<td width="10%" align="center" style="border-style:none; border-width:medium; background-color: <%= color %>; text-align:center; "><font face="Arial" size="2"><%=RS("Resolution")%> </td>
<td width="10%" align="center" style="border-style:none; border-width:medium; background-color: <%= color %>; text-align:center; "><font face="Arial" size="2"><%=RS("MedLine_ID")%> </td>
<td width="10%" align="center" style="border-style:none; border-width:medium; background-color: <%= color %>; text-align:center; "><font face="Arial" size="2"><%=RS("Reference")%> </td>
<td width="10%" align="center" style="border-style:none; border-width:medium; background-color: <%= color %>; text-align:center; "><font face="Arial" size="2"><%=RS("Protein_family")%> </td>
<td width="25%" align="center" style="border-style:none; border-width:medium; background-color: <%= color %>; text-align:center; "><p><font face="Arial" size="2" color="#FF0000"><%=RS("Keywords")%> </td>
</tr>
<%
' Sumamos 1 a los mostrados
registro_mostrado = registro_mostrado + 1
' Nos movemos al próximo registro...
RS.MoveNext
Loop

End If
%>
</table>

</center>
</div>

<%
' Cerramos y limpiamos...
RS.Close
Set RS = Nothing
oConn.Close
Set oConn = Nothing
%>
<div align="center"><br>
<font size="2" face="Arial">
<%
' Ahora mostramos los enlaces a las otras páginas con el resto de los registros...
If pagina_actual > 1 Then
%> </font><font size="2"> <a href="resultados.asp?eje=30&page=<%= pagina_actual - 1 %>&Record=<%=Record%>&Number=<%=Number%>&orden=<%=orden%>&PDB_ID=<%=PDB_ID%>&PDB_file=<%=PDB_file%>&PDB_file_2=<%=PDB_file_2%>&Sequence=<%=Sequence%>&Matrix_FOLDx=<%=Matrix_FOLDx%>&Molecular_Surface=<%=Molecular_Surface%>&Ligand=<%=Ligand%>&Phosphorylated_residue_type=<%=Phosphorylated_residue_type%>&Experimental_Technique=<%=Experimental_Technique%>&Protein_Source=<%=Protein_Source%>&Title=<%=Title%>&Resolution=<%=Resolution%>&MedLine_ID=<%=MedLine_ID%>&Reference=<%=Reference%>&Protein_family=<%=Protein_family%>&Keywords=<%=Keywords%>&cantidad=<%=cantidad%>">
<font face="Arial">[</font><b><font face="Arial"><<</font></b><font face="Arial"> Previous ]</font></a><font face="Arial"> <%
End If

' mostramos la paginacion por numeros de página
For I = 1 To cant_paginas
If I = pagina_actual Then
%> <font color="#FF3300">
<b><%= I %></b></font>
<%
Else
%>
<a href="resultados.asp?eje=30&page=<%= I %>&Record=<%=Record%>&Number=<%=Number%>&orden=<%=orden%>&PDB_ID=<%=PDB_ID%>&PDB_file=<%=PDB_file%>&PDB_file_2=<%=PDB_file_2%>&Sequence=<%=Sequence%>&Matrix_FOLDx=<%=Matrix_FOLDx%>&Molecular_Surface=<%=Molecular_Surface%>&Ligand=<%=Ligand%>&Phosphorylated_residue_type=<%=Phosphorylated_residue_type%>&Experimental_Technique=<%=Experimental_Technique%>&Protein_Source=<%=Protein_Source%>&Title=<%=Title%>&Resolution=<%=Resolution%>&MedLine_ID=<%=MedLine_ID%>&Reference=<%=Reference%>&Protein_family=<%=Protein_family%>&Keywords=<%=Keywords%>&cantidad=<%=cantidad%>"><%= I %></a>
<%
End If
Next 'I


If pagina_actual < cant_paginas Then
%> </font> <a href="resultados.asp?eje=30&page=<%= pagina_actual + 1 %>&Record=<%=Record%>&Number=<%=Number%>&orden=<%=orden%>&PDB_ID=<%=PDB_ID%>&PDB_file=<%=PDB_file%>&PDB_file_2=<%=PDB_file_2%>&Sequence=<%=Sequence%>&Matrix_FOLDx=<%=Matrix_FOLDx%>&Molecular_Surface=<%=Molecular_Surface%>&Ligand=<%=Ligand%>&Phosphorylated_residue_type=<%=Phosphorylated_residue_type%>&Experimental_Technique=<%=Experimental_Technique%>&Protein_Source=<%=Protein_Source%>&Title=<%=Title%>&Resolution=<%=Resolution%>&MedLine_ID=<%=MedLine_ID%>&Reference=<%=Reference%>&Protein_family=<%=Protein_family%>&Keywords=<%=Keywords%>&cantidad=<%=cantidad%>">
<font face="Arial">[ </font>
</font>

<font size="2" face="Arial"> next
</font>

<font size="2">
<b><font face="Arial">>></font></b></font><font face="Arial" size="2">]</font></a><font size="2">
<br>
</font>

<%
End If
'Fin
%>
</div>

<br><center><font face="Arial" size="1"><a href="buscador.asp">New search</font><font size="2"><a/>
</a></font>

</BODY>
</HTML>

y para el buscados.asp es:

<head>
<title>Query form</title>
</head>

<body>

<div align="center">
<center>
<form method="GET" action="resultados.asp">
<table border="1" cellpadding="2" cellspacing="0" style="border-collapse: collapse" bordercolor="#000000" width="58%" id="AutoNumber1">
<tr>
<td width="104%" align="right" style="border-right-style: none; border-right-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#000000" colspan="2">
<p align="center"><b><font face="Arial" size="2" color="#FFFFFF">Advanced
search in Phosphoprtein 1.03 database</font></b></td>
</tr>
<tr>
<td width="39%" align="right" style="border-right-style: none; border-right-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<b><font face="Arial" size="2">Record:</font></b></td>
<td width="65%" style="border-left-style: none; border-left-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<font face="Arial"><input type="text" name="Record" size="10">&nbsp;&nbsp;
<font size="2"><a href="explanation.htm">Explanation</a></font></font></td>
</tr>
<tr>
<td width="39%" align="right" style="border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<b><font face="Arial" size="2">Number:</font></b></td>
<td width="65%" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<font face="Arial"><input type="text" name="Number" size="10">&nbsp;&nbsp;
<font size="2"><a href="explanation.htm">Explanation</a></font></font></td>
</tr>
<tr>
<td width="39%" align="right" style="border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<b><font face="Arial" size="2">PDB_ID:</font></b></td>
<td width="65%" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<font face="Arial"><input type="text" name="PDB_ID" size="20">&nbsp;&nbsp;
<font size="2"><a href="explanation.htm">Explanation</a></font></font></td>
</tr>
<tr>
<td width="39%" align="right" style="border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<b><font face="Arial" size="2">PDB_file:</font></b></td>
<td width="65%" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<font face="Arial"><input type="text" name="PDB_file" size="20">&nbsp;&nbsp;
<font size="2"><a href="explanation.htm">Explanation</a></font></font></td>
</tr>
<tr>
<td width="39%" align="right" style="border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<b><font face="Arial" size="2">PDB_file_2:</font></b></td>
<td width="65%" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<font face="Arial"><input type="text" name="PDB_file_2" size="20">&nbsp;&nbsp;
<font size="2"><a href="explanation.htm">Explanation</a></font></font></td>
</tr>
<tr>
<td width="39%" align="right" style="border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<b><font face="Arial" size="2">Sequence:</font></b></td>
<td width="65%" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<font face="Arial"><input type="text" name="Sequence" size="45">&nbsp;&nbsp;
<font size="2"><a href="explanation.htm">Explanation</a></font></font></td>
</tr>
<tr>
<td width="39%" align="right" style="border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<b><font face="Arial" size="2">Matrix_FOLDx:</font></b></td>
<td width="65%" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<font face="Arial"><input type="text" name="Matrix_FOLDx" size="20">&nbsp;&nbsp;
<font size="2"><a href="explanation.htm">Explanation</a></font></font></td>
</tr>
<tr>
<td width="39%" align="right" style="border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<b><font face="Arial" size="2">Molecular_Surface:</font></b></td>
<td width="65%" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<font face="Arial"><input type="text" name="Molecular_Surface" size="20">&nbsp;&nbsp;
<font size="2"><a href="explanation.htm">Explanation</a></font></font></td>
</tr>
<tr>
<td width="39%" align="right" style="border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<b><font face="Arial" size="2">Ligand:</font></b></td>
<td width="65%" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<font face="Arial"><input type="text" name="Ligand" size="35">&nbsp;&nbsp;
<font size="2"><a href="explanation.htm">Explanation</a></font></font></td>
</tr>
<tr>
<td width="39%" align="right" style="border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<b><font face="Arial" size="2">Phosphorylated_residue_type:</font></b></td>
<td width="65%" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<font face="Arial"><input type="text" name="Phosphorylated_residue_type" size="20">&nbsp;&nbsp;
<font size="2"><a href="explanation.htm">Explanation</a></font></font></td>
</tr>
<tr>
<td width="39%" align="right" style="border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<b><font face="Arial" size="2">Experimental_Technique:</font></b></td>
<td width="65%" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<font face="Arial">
<input type="text" name="Experimental_Technique" size="25">&nbsp;&nbsp;
<font size="2"><a href="explanation.htm">Explanation</a></font></font></td>
</tr>
<tr>
<td width="39%" align="right" style="border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<b><font face="Arial" size="2">Protein_Source:</font></b></td>
<td width="65%" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<font face="Arial"><input type="text" name="Protein_Source" size="20">&nbsp;&nbsp;
<font size="2"><a href="explanation.htm">Explanation</a></font></font></td>
</tr>
<tr>
<td width="39%" align="right" style="border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<b><font face="Arial" size="2">Title:</font></b></td>
<td width="65%" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<font face="Arial"><input type="text" name="Title" size="50">&nbsp;&nbsp;
<font size="2"><a href="explanation.htm">Explanation</a></font></font></td>
</tr>
<tr>
<td width="39%" align="right" style="border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<b><font face="Arial" size="2">Resolution:</font></b></td>
<td width="65%" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<font face="Arial"><input type="text" name="Resolution" size="10">&nbsp;&nbsp;
<font size="2"><a href="explanation.htm">Explanation</a></font></font></td>
</tr>
<tr>
<td width="39%" align="right" style="border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<b><font face="Arial" size="2">MedLine_ID:</font></b></td>
<td width="65%" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<font face="Arial"><input type="text" name="MedLine_ID" size="20">&nbsp;&nbsp;
<font size="2"><a href="explanation.htm">Explanation</a></font></font></td>
</tr>
<tr>
<td width="39%" align="right" style="border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<b><font face="Arial" size="2">Reference:</font></b></td>
<td width="65%" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<font face="Arial"><input type="text" name="Reference" size="30">&nbsp;&nbsp;
<font size="2"><a href="explanation.htm">Explanation</a></font></font></td>
</tr>
<tr>
<td width="39%" align="right" style="border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<b><font face="Arial" size="2">Protein_family:</font></b></td>
<td width="65%" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<font face="Arial"><input type="text" name="Protein_family" size="20">&nbsp;&nbsp;
<font size="2"><a href="explanation.htm">Explanation</a></font></font></td>
</tr>
<tr>
<td width="39%" align="right" style="border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<b><font face="Arial" size="2">Keywords:</font></b></td>
<td width="65%" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<font face="Arial"><input type="text" name="Keywords" size="50"></font></td>
</tr>
<tr>
<td width="39%" align="right" style="border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<b><font face="Arial" size="2">Organize by:</font></b></td>
<td width="65%" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-width: 0" bordercolor="#111111" width="269" id="AutoNumber2" height="71">
<tr>

<td width="20" style="border-style: none; border-width: medium" height="18">
<font face="Arial"><input type="radio" value="Record" name="orden"></font></td>
<td width="50" style="border-style: none; border-width: medium" height="18">
<font face="Arial" size="2">Record</font></td>

<td width="20" style="border-style: none; border-width: medium" height="18">
<font face="Arial">
<input type="radio" value="Number" name="orden" checked></font></td>
<td width="50" style="border-style: none; border-width: medium" height="18">
<font face="Arial" size="2">Number</font></td>

<td width="20" style="border-style: none; border-width: medium" height="18">
<font face="Arial"><input type="radio" value="PDB_ID" name="orden"></font></td>
<td width="105" style="border-style: none; border-width: medium" height="18">
<font face="Arial" size="2">PDB_ID</font></td>
</tr>
<tr>
<td width="20" style="border-style: none; border-width: medium" height="16">
<font face="Arial"><input type="radio" value="PDB_file" name="orden"></font></td>
<td width="49" style="border-style: none; border-width: medium" height="16">
<font face="Arial" size="2">PDB_file</font></td>

<td width="20" style="border-style: none; border-width: medium" height="16">
<font face="Arial"><input type="radio" value="PDB_file_2" name="orden"></font></td>
<td width="55" style="border-style: none; border-width: medium" height="16">
<font face="Arial" size="2">PDB_file_2</font></td>

<td width="20" style="border-style: none; border-width: medium" height="16">
<font face="Arial"><input type="radio" value="Sequence" name="orden"></font></td>
<td width="105" style="border-style: none; border-width: medium" height="16">
<font face="Arial" size="2">Sequence</font></td>
</tr>
<tr>
<td width="20" style="border-style: none; border-width: medium" height="16">
<font face="Arial"><input type="radio" value="Matrix_FOLDx" name="orden"></font></td>
<td width="49" style="border-style: none; border-width: medium" height="16">
<font face="Arial" size="2">Matrix_FOLDx</font></td>

<td width="20" style="border-style: none; border-width: medium" height="16">
<font face="Arial"><input type="radio" value="Molecular_Surface" name="orden"></font></td>
<td width="55" style="border-style: none; border-width: medium" height="16">
<font face="Arial" size="2">Molecular_Surface</font></td>

<td width="20" style="border-style: none; border-width: medium" height="16">
<font face="Arial"><input type="radio" value="Ligand" name="orden"></font></td>
<td width="105" style="border-style: none; border-width: medium" height="16">
<font face="Arial" size="2">Ligand</font></td>
</tr>
<tr>
<td width="20" style="border-style: none; border-width: medium" height="16">
<font face="Arial"><input type="radio" value="Phosphorylated_residue_type" name="orden"></font></td>
<td width="49" style="border-style: none; border-width: medium" height="16">
<font face="Arial" size="2">Phosphorylated_residue_type</font></td>

<td width="20" style="border-style: none; border-width: medium" height="16">
<font face="Arial"><input type="radio" value="Resolution" name="orden"></font></td>
<td width="55" style="border-style: none; border-width: medium" height="16">
<font face="Arial" size="2">Resolution</font></td>

<td width="20" style="border-style: none; border-width: medium" height="16">
<font face="Arial"><input type="radio" value="Title" name="orden"></font></td>
<td width="105" style="border-style: none; border-width: medium" height="16">
<font face="Arial" size="2">Title</font></td>
</tr>
<tr>
<td width="20" style="border-style: none; border-width: medium" height="16">
<font face="Arial"><input type="radio" value="Protein_Source" name="orden"></font></td>
<td width="49" style="border-style: none; border-width: medium" height="16">
<font face="Arial" size="2">Protein_Source</font></td>

<td width="20" style="border-style: none; border-width: medium" height="16">
<font face="Arial"><input type="radio" value="MedLine_ID" name="orden"></font></td>
<td width="55" style="border-style: none; border-width: medium" height="16">
<font face="Arial" size="2">MedLine_ID</font></td>

<td width="20" style="border-style: none; border-width: medium" height="16">
<font face="Arial"><input type="radio" value="Reference" name="orden"></font></td>
<td width="105" style="border-style: none; border-width: medium" height="16">
<font face="Arial" size="2">Reference</font></td>
</tr>
<tr>
<td width="20" style="border-style: none; border-width: medium" height="16">
<font face="Arial"><input type="radio" value="Protein_family" name="orden"></font></td>
<td width="49" style="border-style: none; border-width: medium" height="16">
<font face="Arial" size="2">Protein_family</font></td>

<td width="20" style="border-style: none; border-width: medium" height="16">
<font face="Arial"><input type="radio" value="Keywords" name="orden"></font></td>
<td width="55" style="border-style: none; border-width: medium" height="16">
<font face="Arial" size="2">Keywords</font></td>

<td width="20" style="border-style: none; border-width: medium" height="16">
<font face="Arial"><input type="radio" value="Experimental_Technique" name="orden"></font></td>
<td width="105" style="border-style: none; border-width: medium" height="16">
<font face="Arial" size="2">Experimental_Technique</font></td>
</tr>
<tr>
<td width="269" style="border-style: none; border-width: medium" colspan="6" height="5">
</td>
</tr>
<tr>
<td width="20" style="border-style: none; border-width: medium" height="17">
<input type="radio" name="alf" value="asc" checked></td>
<td width="124" style="border-style: none; border-width: medium" height="17" colspan="3">
up</td>
<td width="20" style="border-style: none; border-width: medium" height="17">
<input type="radio" name="alf" value="desc"></td>
<td width="105" style="border-style: none; border-width: medium" height="17">
down</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="39%" align="right" style="border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<b><font face="Arial" size="2">Number of records:</font></b></td>
<td width="65%" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" bgcolor="#EBEBEB">
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-width: 0" bordercolor="#111111" width="100%" id="AutoNumber3">
<tr>
<td width="22" style="border-style: none; border-width: medium">
<font face="Arial">
<input type="radio" value="10" name="cantidad" checked></font></td>
<td width="34" style="border-style: none; border-width: medium">
<font face="Arial" size="2">10</font></td>
<td width="20" style="border-style: none; border-width: medium">
<font face="Arial"><input type="radio" value="20" name="cantidad"></font></td>
<td width="35" style="border-style: none; border-width: medium">
<font face="Arial" size="2">20</font></td>
<td width="20" style="border-style: none; border-width: medium">
<font face="Arial"><input type="radio" value="30" name="cantidad"></font></td>
<td width="35" style="border-style: none; border-width: medium">
<font face="Arial" size="2">30</font></td>
<td width="20" style="border-style: none; border-width: medium">
<font face="Arial"><input type="radio" value="50" name="cantidad"></font></td>
<td width="35" style="border-style: none; border-width: medium">
<font face="Arial" size="2">50</font></td>
<td width="20" style="border-style: none; border-width: medium">
<font face="Arial"><input type="radio" value="75" name="cantidad"></font></td>
<td width="35" style="border-style: none; border-width: medium">
<font face="Arial" size="2">75</font></td>
<td width="20" style="border-style: none; border-width: medium">
<font face="Arial"><input type="radio" value="100" name="cantidad"></font></td>
<td width="147" style="border-style: none; border-width: medium">
<font face="Arial" size="2">100</font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="39%" align="right" style="border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium" bgcolor="#EBEBEB"> </td>
<td width="65%" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium" bgcolor="#EBEBEB">
<font face="Arial"><input type="submit" value="Search">&nbsp;&nbsp;&nbsp; <input type="reset" value="Clear">
</font></td>
</tr>
</table>
</form>
</center>
</div>

</body>

</html>

Lo tengo colgado en http://shaker.umh.es/data/buscador.asp

Podeis hacerme una ayudita.

Gracias, Jose.Encinar@embl.de

   
 Foro Bloqueado  Tema Bloqueado
Ir a:
Los Foros de ASPTutor.com Los Foros de ASPTutor.com
Ir al principio de la Página

 Imprimir Tema
 

Descargas de manuales¦ Ejemplos de código ¦ Artículos mas visitados ¦ Envía tu articulo ¦ Foros ¦
  Libro de visitas ¦Crea un enlace con ASPTutor 
 

    © 2001-Hasta hoy  Pedro Rufo Martín  contactar