ayudaaaaaaa paginacion!!!!

ralea · #1 (**permalink**) 29/06/2002, 12:42

Por favor necesito vuestra ayuda,tengo un formulario de busqueda y los resultados son correctos,pero no los puedo paginar.Utilizo Getrows para mostrar los resultados,pero a la hora DE PAGINARLOS NO PUEDOOOOOO.

Por favor ayuda, os envio el codigo:

Código:

&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;ntilde;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&amp;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;uacute;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=0 to UBound(aDatos,2)
for I= iComienzo to iFin
	for J=0 to UBound(aDatos,2)
 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;&gt;&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,J)&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,J)&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,J)&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,J)&amp;&quot;&quot;&quot;&gt;&lt;img src =&quot;&quot;&quot;&amp;aDatos(foto,J)&amp;&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;Verdana&quot;&quot;&gt;&lt;span class=&quot;&quot;normal&quot;&quot;&gt;&quot;&amp;aDatos(descripcion,J)&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;)
next
response.write(&quot;&lt;/tr&gt;&quot;)
next
response.write(&quot;&lt;/table&gt;&quot;)
'Pinto la tabla
'Response.Write(&quot;&lt;TABLE BORDER=&quot;&quot;1&quot;&quot;&gt;&quot;)

		'Response.Write(&quot;&lt;TD&gt;&quot; &amp; aDatos(J,I) &amp; &quot;&lt;/TD&gt;&quot;)
	
	'next
'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;personal.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;personal.asp?P=&quot;&amp;iPag+1&amp;&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;

korev · #2 (**permalink**) 25/12/2002, 07:18

Podrías editar el mensaje y partir los dos response.write que se cargan el html del foro

. También eliminar el código antes del else que se encarga del getrows, eso se supone que ocurre si no hay datos en la bd y parece que sí existen.

Bueno, al tema... tu mensaje es un pelín 'denso' (por lo que he mencionado). ¿Qué error te da? Uso ese código de Carlos de la Orden hace tiempo y no me da problemas.

maestro · #3 (**permalink**) 25/12/2002, 11:55

Podrias haberte dado con una piedra en una mano antes de haber puesto este rollo.
¿Y ademas, cual es la duda?

Tomate unos links sobre paginacion.
http://aspfacil.com/articulos/paginar.asp