¿ke significa este error????

[ralea]

me sale el siguiente error en la 2 pagina con registros.Alguien sabe k significa y como lo puedo arreglar????

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][Controlador ODBC Microsoft Access] Error de sintaxis (falta operador) en la expresión de consulta 'Ucase(Sexo)LIKE'%%'AND Ucase(Pais)LIKE'%%'and Ucase(Clientes.IdCliente)like pais.IdCliente and Ucase(Clientes.IdCliente)like perfilsecundario.IdCliente and Ucase(Edad)between and'.

/conexion_resultados.asp, line 17

lo k me sorprende es k la linea 17 corresponde a:

tabla.open temp,conexion

es decir cuando abro mi recordset(tabla),mi consulta sql(temp) y la conexion ADODB(conexion).
¿k puede fallar?¿pk en la primera pagina si k se ve bien. <IMG SRC="images/futbol.gif" WIDTH="15" HEIGHT="15" HSPACE="3">

[Conde]

Poné el código!!!!!

[urjose]

Lo que esta mal es tu Sentencia SQL así que posteala.

Saludos

<center>
<p><a href=http://comunidadguru.com><img border=0 src=http://comunidadguru.com/urjose.gif></a></p>
</center>

[lubetpic]

si, definitivo es un error interno del codigo, pero sin verlo aqui posteado es imposible...


<p align="center"><a href="http://www.webdesign-costarica.com"><img src="http://www.webdesign-costarica.com/images/webdesign_banner.gif" border="0"></a></p>

[ralea]

el codigo es este:

&lt;%
Dim pag, iEstado
Dim aDatos, iTotal
Dim conexion,tabla,temp
dim i,j,descripcion,nombre,edad,pais,foto,id

Set conexion= server.createobject(&quot;ADODB.connection&quot;)
Set tabla= server.createobject(&quot;ADODB.recordset&quot;)
tabla.cachesize=60
conexion.open &quot;tupareja&quot;
temp=&quot;SELECT * FROM Clientes,pais,perfilsecundario WHERE Ucase(Sexo)LIKE'%&quot; &amp; Ucase(Request(&quot;sexo&quot;)) &amp; &quot;%'AND Ucase(Pais)LIKE'%&quot; &amp; Ucase(Request(&quot;pais&quot;)) &amp; &quot;%'and Ucase(Clientes.IdCliente)like pais.IdCliente and Ucase(Clientes.IdCliente)like perfilsecundario.IdCliente and Ucase(Edad)between &quot;&amp; Ucase(request(&quot;edad&quot;))&amp;&quot;and &quot;&amp;Ucase(request(&quot;edad1&quot;))&amp;& quot; order by Edad&quot;
tabla.CursorType = 0
LockType = Read-Only
tabla.LockType = 1
CursorLocation = adUseClient
tabla.CursorLocation = 3
tabla.open temp,conexion
%&gt;
No creo k falle la consulta sql pk tb fallaria en la primera pagina no?????????

[mamon]

bueno, nose si te has dado cuenta, pero no lee Ucase(request(&quot;sexo&quot;))
osea cuando sale el error no te aparece el valor de Ucase(request(&quot;sexo&quot;)

lo que puedes hacer es antes de hacer el execute debes leer tu string
&lt;%
response.write strSQL
response.end
%&gt;
y mira lo que dice, leo y ve si te da todo bien, xq hay està tu error.

<center><font face="verdana" size="1" color="black">Muy pronto no más aburrimiento en internet, siempre abrá algo nuevo para ver...[/CODE]
</center>

[ralea]

Pero si me fallara la sentencia SQL me daria el error en la primera pagina tambien y sin embargo la primera pagina se me ve bien el error me sale al darle al boton siguiente,en la segunda pagina.
No se si me explico y la linea 17 k es donde dice k tengo el error no corresponde a la linea de la sentencia SQL,sino a la linea donde abro el recordset,la conexion y la sentencia SQL.

[dagui]

El error te lo da en la línea donde corres la sentencia SQL, por eso es que presumimos que es allí que está el error.

Otra cosa que puede estar pasando es que no se está recibiendo bien el paranetro desde la página anterior, o viene vacío. Prueba haciendo un Response.Write(parametro), tanto antes de pasarlo en la página anterior, como al recivirlo en esta página.

Suerte.

P.D: Te recomiendo que anexes el código para que te puedan ayudar, sino está muy difícil.

[ralea]

el codigo donde me da el error es el k esta posteado arriba y la pagina k uso para paginar es la siguiente.

&lt;!--#include file=&quot;conexion_resultados.asp&quot;--&gt;
&lt;html&gt;
&lt;head&gt;
&lt;title&gt;Buscar Datos&lt;/title&gt;
&lt;meta http-equiv=&quot;Content-Type&quot; content=&quot;text/html; charset=iso-8859-1&quot;&gt;
&lt;/head&gt;

&lt;body bgcolor=&quot;#FFFFFF&quot; text=&quot;#000000&quot;&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; width=&quot;528&quot;&gt;
&lt;tr&gt;
&lt;td valign=&quot;top&quot; width=&quot;464&quot; height=&quot;2&quot; bgcolor=&quot;#FFFFFF&quot;&gt;

&lt;table cellspacing=&quot;0&quot; cellpadding=&quot;0&quot; width=&quot;526&quot; border=&quot;0&quot; bgcolor=&quot;#FFFFFF&quot; height=&quot;1&quot;&gt;
&lt;tbody&gt;
&lt;tr bgcolor=&quot;#2d4d5f&quot;&gt;
&lt;td width=&quot;385&quot; height=&quot;1&quot;&gt;

&lt;table cellspacing=&quot;1&quot; cellpadding=&quot;0&quot; width=&quot;527&quot; border=&quot;0&quot; height=&quot;7&quot;&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td bgcolor=&quot;#759AFB&quot; width=&quot;470&quot; height=&quot;1&quot;&gt;

&lt;form action=&quot;/general.asp&quot; method=&quot;post&quot;&gt;
&lt;table cellspacing=&quot;0&quot; cellpadding=&quot;0&quot; width=&quot;517&quot; border=&quot;0&quot; height=&quot;19&quot;&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td align=&quot;right&quot; bgcolor=&quot;#759AFB&quot; width=&quot;512&quot; height=&quot;19&quot;&gt;
&lt;div align=&quot;center&quot;&gt;

&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;6&quot; width=&quot;518&quot; height=&quot;40&quot;&gt;
&lt;tr&gt;

&lt;td valign=&quot;top&quot; width=&quot;525&quot; height=&quot;2&quot; bgcolor=&quot;#759AFB&quot;&gt;
&lt;div align=&quot;center&quot;&gt;


&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;491&quot; align=&quot;left&quot;&gt;
&lt;tr&gt;
&lt;td bgcolor=&quot;#759AFB&quot;&gt;&lt;font size=&quot;1&quot; face=&quot;Verdana&quot;&gt;Busco&amp;nbsp;&lt;/font&gt;&lt;/td&gt;
&lt;td bgcolor=&quot;#759AFB&quot;&gt;&lt;font size=&quot;1&quot; face=&quot;Verdana&quot;&gt;
&lt;select name=&quot;sexo&quot; size=&quot;1&quot; style=&quot;color: #004080; font-size: 10 px; font-family: Verdana; font-weight: bold&quot;&gt;
&lt;option selected value=&quot;Mujer&quot;&gt;Mujer&lt;/option&gt;
&lt;option value=&quot;Hombre&quot;&gt;Hombre&lt;/option&gt;
&lt;/select&gt;
&amp;nbsp;&lt;/font&gt;&lt;/td&gt;
&lt;td bgcolor=&quot;#759AFB&quot;&gt;&lt;font size=&quot;1&quot; face=&quot;Verdana&quot;&gt;Edad&amp;nbsp;&lt;/font&gt;&lt;/td&gt;
&lt;td bgcolor=&quot;#759AFB&quot;&gt;&lt;font size=&quot;1&quot; face=&quot;Verdana&quot;&gt;
&lt;select name=&quot;edad&quot; style=&quot;font-size: 10 px; font-family: Verdana; color: #004080; font-weight: bold&quot; size=&quot;1&quot;&gt;
&lt;option value=&quot;18&quot;&gt;18&lt;/option&gt;
&lt;option value=&quot;25&quot;&gt;25&lt;/option&gt;
&lt;option value=&quot;30&quot;&gt;30&lt;/option&gt;
&lt;option value=&quot;35&quot;&gt;35&lt;/option&gt;
&lt;option value=&quot;40&quot;&gt;40&lt;/option&gt;
&lt;option value=&quot;45&quot;&gt;45&lt;/option&gt;
&lt;option value=&quot;50&quot;&gt;50&lt;/option&gt;
&lt;option value=&quot;55&quot;&gt;55&lt;/option&gt;
&lt;option value=&quot;60&quot;&gt;60&lt;/option&gt;
&lt;option value=&quot;70&quot;&gt;70&lt;/option&gt;
&lt;/select&gt;
&lt;/font&gt;&lt;/td&gt;
&lt;td bgcolor=&quot;#759AFB&quot;&gt;&lt;font size=&quot;1&quot; face=&quot;Verdana&quot;&gt;a&lt;/font&gt;&lt;/td&gt;
&lt;td bgcolor=&quot;#759AFB&quot;&gt;&lt;font size=&quot;1&quot; face=&quot;Verdana&quot;&gt;
&lt;select name=&quot;edad1&quot; style=&quot;color: #004080; font-family: Verdana; font-size: 10 px; font-weight: bold&quot; size=&quot;1&quot;&gt;
&lt;option value=&quot;18&quot;&gt;&lt;font size=&quot;1&quot; face=&quot;Verdana&quot;&gt;18&lt;/font&gt;&lt;/option&gt;
&lt;option value=&quot;25&quot;&gt;&lt;font size=&quot;1&quot; face=&quot;Verdana&quot;&gt;25&lt;/font&gt;&lt;/option&gt;
&lt;option value=&quot;30&quot;&gt;&lt;font size=&quot;1&quot; face=&quot;Verdana&quot;&gt;30&lt;/font&gt;&lt;/option&gt;
&lt;option value=&quot;35&quot;&gt;&lt;font size=&quot;1&quot; face=&quot;Verdana&quot;&gt;35&lt;/font&gt;&lt;/option&gt;
&lt;option value=&quot;40&quot;&gt;&lt;font size=&quot;1&quot; face=&quot;Verdana&quot;&gt;40&lt;/font&gt;&lt;/option&gt;
&lt;option value=&quot;45&quot;&gt;&lt;font size=&quot;1&quot; face=&quot;Verdana&quot;&gt;45&lt;/font&gt;&lt;/option&gt;
&lt;option value=&quot;50&quot;&gt;&lt;font size=&quot;1&quot; face=&quot;Verdana&quot;&gt;50&lt;/font&gt;&lt;/option&gt;
&lt;option value=&quot;55&quot;&gt;&lt;font size=&quot;1&quot; face=&quot;Verdana&quot;&gt;55&lt;/font&gt;&lt;/option&gt;
&lt;option value=&quot;60&quot;&gt;&lt;font size=&quot;1&quot; face=&quot;Verdana&quot;&gt;60&lt;/font&gt;&lt;/option&gt;
&lt;option value=&quot;70&quot;&gt;&lt;font size=&quot;1&quot; face=&quot;Verdana&quot;&gt;70&lt;/font&gt;&lt;/option&gt;
&lt;option value=&quot;80&quot;&gt;&lt;font size=&quot;1&quot; face=&quot;Verdana&quot;&gt;80&lt;/font&gt;&lt;/option&gt;
&lt;/select&gt;
&lt;/font&gt;&lt;/td&gt;
&lt;td bgcolor=&quot;#759AFB&quot;&gt;&lt;font size=&quot;1&quot; face=&quot;Verdana&quot;&gt;De&amp;nbsp;&lt;/font&gt;&lt;/td&gt;
&lt;td bgcolor=&quot;#759AFB&quot;&gt;
&lt;select name=&quot;pais&quot; onchange=&quot;load_states(this.value)&quot; style=&quot;background-color: #ffffff; font-family: Verdana; font-size: 10 px; width: 114; height: 23; color: #004080; font-weight: bold&quot; size=&quot;1&quot;&gt;
&lt;option value=&quot;Espa&amp;ntilde;a&quot;&gt;Espa&amp;nt ilde;a&lt;/option&gt;
&lt;option value=&quot;Francia&quot;&gt;Francia&lt;/option&gt;
&lt;option value=&quot;Inglaterra&quot;&gt;Inglaterra&lt;/option&gt;
&lt;option value=&quot;Irlanda&quot;&gt;Irlanda&lt;/option&gt;
&lt;option value=&quot;Italia&quot;&gt;Italia&lt;/option&gt;
&lt;option value=&quot;ArabiaSaudi&quot;&gt;Arabia
Saud&amp;iacute;&lt;/option&gt;
&lt;option value=&quot;Albania&quot;&gt;Albania&lt;/option&gt;
&lt;option value=&quot;Alemania&quot;&gt;Alemania&lt;/option&gt;
&lt;option value=&quot;Australia&quot;&gt;Australia&lt;/option&gt;
&lt;option value=&quot;Andorra&quot;&gt;Andorra&lt;/option&gt;
&lt;option value=&quot;Angola&quot;&gt;Angola&lt;/option&gt;
&lt;option value=&quot;Argelia&quot;&gt;Argelia&lt;/option&gt;
&lt;option value=&quot;Argentina&quot;&gt;Argentina&lt;/option&gt;
&lt;option value=&quot;Austria&quot;&gt;Austria&lt;/option&gt;
&lt;option value=&quot;Belgica&quot;&gt;B&amp;eacute;lgica&lt ;/option&gt;
&lt;option value=&quot;Bolivia&quot;&gt;Bolivia&lt;/option&gt;
&lt;option value=&quot;BosniaHerzegovina&quot;&gt;Bosnia
Herzegovina&lt;/option&gt;
&lt;option value=&quot;Brasil&quot;&gt;Brasil&lt;/option&gt;
&lt;option value=&quot;Bulgaria&quot;&gt;Bulgaria&lt;/option&gt;
&lt;option value=&quot;Camerun&quot;&gt;Camer&amp;uacute;n&lt ;/option&gt;
&lt;option value=&quot;Canada&quot;&gt;Canad&amp;aacute;&lt;/option&gt;
&lt;option value=&quot;Chile&quot;&gt;Chile&lt;/option&gt;
&lt;option value=&quot;China&quot;&gt;China&lt;/option&gt;
&lt;option value=&quot;Chipre&quot;&gt;Chipre&lt;/option&gt;
&lt;option value=&quot;Colombia&quot;&gt;Colombia&lt;/option&gt;
&lt;option value=&quot;CoreaNorte&quot;&gt;Corea
del Norte&lt;/option&gt;
&lt;option value=&quot;CoreaSur&quot;&gt;Corea
del Sur&lt;/option&gt;
&lt;option value=&quot;CostaRica&quot;&gt;Costa
Rica&lt;/option&gt;
&lt;option value=&quot;Croacia&quot;&gt;Croacia&lt;/option&gt;
&lt;option value=&quot;Cuba&quot;&gt;Cuba&lt;/option&gt;
&lt;option value=&quot;Dinamarca&quot;&gt;Dinamarca&lt;/option&gt;
&lt;option value=&quot;Ecuador&quot;&gt;Ecuador&lt;/option&gt;
&lt;option value=&quot;Egipto&quot;&gt;Egipto&lt;/option&gt;
&lt;option value=&quot;ElCongo&quot;&gt;El
Congo&lt;/option&gt;
&lt;option value=&quot;ElSalvador&quot;&gt;El
Salvador&lt;/option&gt;
&lt;option value=&quot;Escocia&quot;&gt;Escocia&lt;/option&gt;
&lt;option value=&quot;Eslovenia&quot;&gt;Eslovenia&lt;/option&gt;
&lt;option value=&quot;EstadosUnidos&quot;&gt;Estados
Unidos&lt;/option&gt;
&lt;option value=&quot;Estonia&quot;&gt;Estonia&lt;/option&gt;
&lt;option value=&quot;Filipinas&quot;&gt;Filipinas&lt;/option&gt;
&lt;option value=&quot;Finlandia&quot;&gt;Finlandia&lt;/option&gt;
&lt;option value=&quot;Gales&quot;&gt;Gales&lt;/option&gt;
&lt;option value=&quot;Gibraltar&quot;&gt;Gibraltar&lt;/option&gt;
&lt;option value=&quot;Grecia&quot;&gt;Grecia&lt;/option&gt;
&lt;option value=&quot;Guatemala&quot;&gt;Guatemala&lt;/option&gt;
&lt;option value=&quot;Honduras&quot;&gt;Honduras&lt;/option&gt;
&lt;option value=&quot;HongKong&quot;&gt;Hong
Kong&lt;/option&gt;
&lt;option value=&quot;Hungria&quot;&gt;Hungr&amp;iacute;a&lt ;/option&gt;
&lt;option value=&quot;India&quot;&gt;India&lt;/option&gt;
&lt;option value=&quot;Indonesia&quot;&gt;Indonesia&lt;/option&gt;
&lt;option value=&quot;Iran&quot;&gt;Ir&amp;aacute;n&lt;/option&gt;
&lt;option value=&quot;Iraq&quot;&gt;Ir&amp;aacute;q&lt;/option&gt;
&lt;option value=&quot;Israel&quot;&gt;Israel&lt;/option&gt;
&lt;option value=&quot;Jamaica&quot;&gt;Jamaica&lt;/option&gt;
&lt;option value=&quot;Japon&quot;&gt;Jap&amp;oacute;n&lt;/option&gt;
&lt;option value=&quot;Jordania&quot;&gt;Jordania&lt;/option&gt;
&lt;option value=&quot;Kuwait&quot;&gt;Kuwait&lt;/option&gt;
&lt;option value=&quot;RepublicaCheca&quot;&gt;La
Rep&amp;uacute;blica Checa&lt;/option&gt;
&lt;option value=&quot;RepublicaEslovaca&quot;&gt;La
Rep&amp;uacute;blica Eslovaca&lt;/option&gt;
&lt;option value=&quot;Letonia&quot;&gt;Letonia&lt;/option&gt;
&lt;option value=&quot;Libia&quot;&gt;L&amp;iacute;bia&lt;/option&gt;
&lt;option value=&quot;Lituania&quot;&gt;Lituania&lt;/option&gt;
&lt;option value=&quot;Luxemburgo&quot;&gt;Luxemburgo&lt;/option&gt;
&lt;option value=&quot;Malasia&quot;&gt;Malasia&lt;/option&gt;
&lt;option value=&quot;Malta&quot;&gt;Malta&lt;/option&gt;
&lt;option value=&quot;Marruecos&quot;&gt;Marruecos&lt;/option&gt;
&lt;option value=&quot;Mexico&quot;&gt;M&amp;eacute;jico&lt;/option&gt;
&lt;option value=&quot;Monaco&quot;&gt;M&amp;oacute;naco&lt;/option&gt;
&lt;option value=&quot;Nepal&quot;&gt;Nepal&lt;/option&gt;
&lt;option value=&quot;Nicaragua&quot;&gt;Nicaragua&lt;/option&gt;
&lt;option value=&quot;Niger&quot;&gt;N&amp;iacute;ger&lt;/option&gt;
&lt;option value=&quot;Nigeria&quot;&gt;Nigeria&lt;/option&gt;
&lt;option value=&quot;Noruega&quot;&gt;Noruega&lt;/option&gt;
&lt;option value=&quot;NuevaZelanda&quot;&gt;Nueva
Zelanda&lt;/option&gt;
&lt;option value=&quot;PaisesBajos&quot;&gt;Pa&amp;iacute;ses
Bajos&lt;/option&gt;
&lt;option value=&quot;Pakistan&quot;&gt;Pakist&amp;aacute;n& lt;/option&gt;
&lt;option value=&quot;Paraguay&quot;&gt;Paraguay&lt;/option&gt;
&lt;option value=&quot;Peru&quot;&gt;Per&amp;uacute;&lt;/option&gt;
&lt;option value=&quot;Polonia&quot;&gt;Polonia&lt;/option&gt;
&lt;option value=&quot;Portugal&quot;&gt;Portugal&lt;/option&gt;
&lt;option value=&quot;PuertoRico&quot;&gt;Puerto
Rico&lt;/option&gt;
&lt;option value=&quot;RepublicaCentroafricana&quot;&gt;Rep&a mp;uacute;blica
Centroafricana&lt;/option&gt;
&lt;option value=&quot;RepublicaCongo&quot;&gt;Rep&amp;uacute ;blica
del Congo (Zaire)&lt;/option&gt;
&lt;option value=&quot;RepublicaDominicana&quot;&gt;Rep&amp;u acute;blica
Dominicana&lt;/option&gt;
&lt;option value=&quot;Rumania&quot;&gt;Ruman&amp;iacute;a&lt ;/option&gt;
&lt;option value=&quot;Rusia&quot;&gt;Rusia&lt;/option&gt;
&lt;option value=&quot;Sudan&quot;&gt;Sud&amp;aacute;n&lt;/option&gt;
&lt;option value=&quot;Suecia&quot;&gt;Suecia&lt;/option&gt;
&lt;option value=&quot;Suiza&quot;&gt;Suiza&lt;/option&gt;
&lt;option value=&quot;Tailandia&quot;&gt;Tailandia&lt;/option&gt;
&lt;option value=&quot;Taiwan&quot;&gt;Taiw&amp;aacute;n&lt;/option&gt;
&lt;option value=&quot;Tunez&quot;&gt;T&amp;uacute;nez&lt;/option&gt;
&lt;option value=&quot;Turquia&quot;&gt;Turqu&amp;iacute;a&lt ;/option&gt;
&lt;option value=&quot;Ucrania&quot;&gt;Ucrania&lt;/option&gt;
&lt;option value=&quot;Uruguay&quot;&gt;Uruguay&lt;/option&gt;
&lt;option value=&quot;Venezuela&quot;&gt;Venezuela&lt;/option&gt;
&lt;option value=&quot;Vietnam&quot;&gt;Vietnam&lt;/option&gt;
&lt;option value=&quot;Yugoslavia&quot;&gt;Yugoslavia&lt;/option&gt;
&lt;option value=&quot;Otros&quot;&gt;Otros&lt;/option&gt;
&lt;/select&gt;
&lt;/td&gt;

&lt;td bgcolor=&quot;#759AFB&quot;&gt;&lt;b&gt;&lt;dfn&gt ;&lt;font size=&quot;1&quot; face=&quot;Verdana&quot;&gt;&amp;nbsp;&amp;nbsp;
&lt;input name=&quot;Buscar&quot; style=&quot;BACKGROUND-COLOR: #77bbff; BORDER-BOTTOM-COLOR: #000096; BORDER-BOTTOM-STYLE: solid; BORDER-LEFT-COLOR: #000096; BORDER-LEFT-STYLE: solid; BORDER-RIGHT-COLOR: #000096; BORDER-RIGHT-STYLE: solid; BORDER-TOP-COLOR: #000096; BORDER-TOP-STYLE: solid; COLOR: #004080; FONT-FAMILY: Verdana; FONT-SIZE: 10px; FONT-WEIGHT: bold&quot; type=&quot;submit&quot; value=&quot;Buscar&quot;&gt;
&lt;/font&gt;&lt;/dfn&gt;&lt;/b&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;/table&gt;
&lt;/div&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/table&gt;
&lt;/div&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;/form&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;

&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;/table&gt;

&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;3&quot; width=&quot;525&quot;&gt;
&lt;tr&gt;

&lt;td width=&quot;529&quot; bgcolor=&quot;#000000&quot;&gt;
&lt;table cellspacing=&quot;1&quot; cellpadding=&quot;0&quot; width=&quot;512&quot; border=&quot;0&quot; height=&quot;15&quot;&gt;
&lt;tbody&gt;
&lt;tr&gt;

&lt;td bgcolor=&quot;#B5CBFB&quot; width=&quot;526&quot; height=&quot;15&quot;&gt;
&lt;table border=&quot;0&quot; cellPadding=&quot;0&quot; cellSpacing=&quot;0&quot; width=&quot;523&quot;&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;
&lt;div align=&quot;center&quot;&gt;
&lt;center&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;5&quot;&gt;
&lt;tr&gt;

&lt;td width=&quot;904&quot; bgcolor=&quot;#B5CBFB&quot;&gt;
&lt;div align=&quot;center&quot;&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot;&gt;
&lt;tr&gt;

&lt;td&gt;&lt;font face=&quot;Verdana&quot; size=&quot;1&quot;&gt;&lt;b&gt;RESULTADOS
OBTENIDOS&lt;/b&gt;&lt;/font&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;/table&gt;
&lt;/div&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/table&gt;
&lt;/center&gt;
&lt;/div&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/table&gt;
&lt;% if tabla.bof and tabla.eof then %&gt;
&lt;p&gt;&lt;font face=&quot;Tahoma&quot; size=&quot;2&quot;&gt; No se ha encontrado nada en la base de datos&lt;/font&gt;&lt;/p&gt;
&lt;%
else
aDatos = tabla.GetRows
nombre=6
edad=4
pais=10
foto=14
descripcion=15
%&gt;
&lt;%
Tabla.Close
set tabla=nothing
Conexion.Close
set conexion=nothing
%&gt;
&lt;%
pag = CInt(Request.QueryString(&quot;P&quot;))
'Y llamo a PaginarGR
iEstado = PaginarGR (5, pag, aDatos)
'================================================= ====================================
' PaginarGR -- Pagina un vector bidimensional
' vector es el vector a paginar, iPag la página a mostrar y iRegsPorPag el nº de
' registros por cada página que queremos.
'================================================= ====================================
Function PaginarGR (iRegsPorPag, iPag, aDatos)
'
'I, J se utilizan para recorrer el vector
Dim I, J
'Total de páginas y la página que queremos mostrar
Dim iPaginas, iPagActual
'Total de registros, registro en que empezamos y registro en que terminamos
Dim iTotal, iComienzo, iFin

'Hallo el total de registros devueltos
iTotal = UBound(aDatos,2)+1
'Calculo el numero de páginas que tenemos
iPaginas = (iTotal \ iRegsPorPag)
'Si daba decimales, añado una más
'para mostrar los últimos registros
if iTotal mod iRegsPorPag &gt; 0 then
iPaginas = iPaginas + 1
end if
'Si no es una página válida, comienzo en la primera
if iPag &lt; 1 then
iPag = 1
end if
'Si es una página mayor al nº de páginas, comienzo en la última
if iPag &gt; iPaginas then
iPag = iPaginas
end if

'for I= iComienzo to iFin
'for J=0 to UBound(aDatos,2)
registro=iPag*iRegsPorPag
for i=1 to iRegsPorPag
response.write(&quot;&lt;table border=&quot;&quot;0&quot;&quot; cellpadding=&quot;&quot;0&quot;&quot; cellspacing=&quot;&quot;3&quot;&quot; width=&quot;&quot;1&quot;&quot; dwcopytype=&quot;&quot;CopyTableCell&quot;&quot;&g t;&lt;tr&gt; &lt;td width=&quot;&quot;602&quot;&quot; bgcolor=&quot;&quot;#000000&quot;&quot;&gt; &lt;table cellspacing=&quot;&quot;1&quot;&quot; cellpadding=&quot;&quot;0&quot;&quot; width=&quot;&quot;521&quot;&quot; border=&quot;&quot;0&quot;&quot; height=&quot;&quot;15&quot;&quot;&gt;&lt;tbody&gt; &lt;tr&gt; &lt;td bgcolor=&quot;&quot;#FFF8D2&quot;&quot; width=&quot;&quot;1215&quot;&quot; height=&quot;&quot;10&quot;&quot;&gt;&lt;font face=&quot;&quot;Verdana&quot;&quot; size=&quot;&quot;1&quot;&quot;&gt;&lt;b&gt;&quot;& amp;aDatos(nombre,registro+i)&amp;&quot;&lt;/b&gt;&lt;/font&gt; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;font face=&quot;&quot;Verdana&quot;&quot; size=&quot;&quot;1&quot;&quot;&gt;&lt;b&gt;&quot;& amp;aDatos(edad,registro+i)&amp;&quot; años&lt;/b&gt;&lt;/font&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;font face=&quot;&quot;Verdana&quot;&quot; size=&quot;&quot;1&quot;&quot;&gt;&lt;b&gt;&quot;& amp;aDatos(pais,registro+i)&amp;&quot;&lt;/b&gt;&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/tbody&gt;&lt;/table&gt;&lt;/td&gt;&lt;/tr&gt;&quot;)
response.write(&quot;&lt;tr&gt; &lt;td width=&quot;&quot;602&quot;&quot; bgcolor=&quot;&quot;#000000&quot;&quot;&gt; &lt;table cellspacing=&quot;&quot;1&quot;&quot; cellpadding=&quot;&quot;0&quot;&quot; width=&quot;&quot;22&quot;&quot; border=&quot;&quot;0&quot;&quot; height=&quot;&quot;1&quot;&quot;&gt;&lt;tbody&gt; &lt;tr&gt; &lt;td bgcolor=&quot;&quot;#FFFFFF&quot;&quot; width=&quot;&quot;716&quot;&quot; height=&quot;&quot;1&quot;&quot;&gt;&lt;table cellspacing=&quot;&quot;5&quot;&quot; cellpadding=&quot;&quot;0&quot;&quot; width=&quot;&quot;519&quot;&quot; border=&quot;&quot;0&quot;&quot; height=&quot;&quot;12&quot;&quot;&gt;&lt;tbody&gt; &lt;tr&gt; &lt;td width=&quot;&quot;87&quot;&quot; height=&quot;&quot;79&quot;&quot;&gt;&lt;a href=&quot;&quot;detalle.asp?Cliente=&quot;&amp; aDatos(id,registro+i)&amp;&quot;&quot;&quot;&gt;&l t;img src =&quot;&quot;&quot;&amp;aDatos(foto,registro+i)&am p;&quot;&quot;&quot;&gt;&lt;/td&gt;&lt;td width=&quot;&quot;417&quot;&quot; height=&quot;&quot;79&quot;&quot;&gt;&lt;p align=&quot;&quot;justify&quot;&quot;&gt;&lt;span class=&quot;&quot;small&quot;&quot;&gt;&lt;font size=&quot;&quot;1&quot;&quot;face=&quot;&quot;Ver dana&quot;&quot;&gt;&lt;span class=&quot;&quot;normal&quot;&quot;&gt;&quot;&amp ;aDatos(descripcion,registro+i)&amp;&quot;&lt;/span&gt;..&lt;/font&gt;&lt;/span&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/tbody&gt; &lt;/table&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/tbody&gt; &lt;/table&gt;&lt;/td&gt;&lt;/tr&gt;&quot;)

response.write(&quot;&lt;/tr&gt;&quot;)
next
response.write(&quot;&lt;/table&gt;&quot;)

Response.Write(&quot;Página &quot; &amp; iPag &amp; &quot; de &quot; &amp; iPaginas &amp; &quot; (&quot; &amp; iTotal &amp; &quot; registros)&lt;br&gt;&quot;)
'Calculo el índice donde comienzo:
iComienzo = (iPag-1)*iRegsPorPag
'y donde termino:
iFin = iComienzo + (iRegsPorPag-1)
'Si no tengo suficientes registros restantes,
'voy hasta el final
if iFin &gt; UBound(aDatos, 2) then
iFin = UBound(aDatos, 2)
end if

'Imprimo enlaces, si son necesarios
if iPag &gt; 1 then
Response.Write(&quot;&lt;A HREF=&quot;&quot;general.asp?P=&quot;&amp;iPag-1&amp;&quot;&quot;&quot;&gt;Anterior&lt;/A&gt;&amp;nbsp;&amp;nbsp;&quot;)
end if
if iPag &lt; iPaginas then
Response.Write(&quot;&lt;A HREF=&quot;&quot;general.asp?P=&quot;&amp;iPag+1&a mp;&quot;&quot;&quot;&gt;Siguiente&lt;/A&gt;&amp;nbsp;&quot;)
end if

PaginarGR = 0


End Function
'================================================= ====================================
%&gt;
&lt;% end if %&gt;
&lt;/body&gt;
&lt;/html&gt;