Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Re: Paging using Perl

by LTjake (Prior)
on Oct 23, 2006 at 13:48 UTC ( #580035=note: print w/ replies, xml ) Need Help??


in reply to Paging using Perl

There was a thread not too long ago that was pretty much exactly what you're asking: SQL Paging with Perl

I believe my reply was a suitable response -- use SQL::Abstract::Limit. Here is the snippet i posted in my reply:

use SQL::Abstract::Limit; my $sql = SQL::Abstract::Limit->new( limit_dialect => 'Top' ); # generate SQL: my ( $stmt, @bind ) = $sql->select( $table, \@fields, \%where, \@order +, $limit, +$offset ); # Then, use these in your DBI statements my $sth = $dbh->prepare( $stmt ); $sth->execute( @bind );

--
"Go up to the next female stranger you see and tell her that her "body is a wonderland."
My hypothesis is that she’ll be too busy laughing at you to even bother slapping you.
" (src)


Comment on Re: Paging using Perl
Download Code
Re^2: Paging using Perl
by Anonymous Monk on Oct 23, 2006 at 14:09 UTC
    This is as bad as writing a Stored Procedures for Microsoft Sql Server, unless you have a clear example for it.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://580035]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (5)
As of 2015-07-05 13:55 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (67 votes), past polls