That worked, thank you.

Now how do I populate that with data? I am trying this:

my $dbh = DBI->connect( "dbi:xxx:xxx", "xxxx", 'xxxx');
                my $sth = $dbh->prepare('SELECT title, url FROM fd_ent
+ries ORDER BY timestamp DESC LIMIT 200');
                $sth->execute();

# create a callback subroutine to generate the data to be paged
my $get_data_sub = sub {
   my ($offset, $rows) = @_;

   #my @return_array;
    my $return_array = $sth->fetchrow_array();

   for (my $x = 0; $x < $rows; $x++) {
      push(@return_array, [ $data[$offset + $x]{title},
                            $data[$offset + $x]{url}
                          ]
      );
   }
   return \@return_array;
}
;

[download]
I know that is way off, but I don't how how far.

Thank you.

In reply to Re^2: Pagination with in HTML::Template by Anonymous Monk
in thread Pagination with in HTML::Template by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.