Re: pager

[prev] [thread] [next] [Date index for 2004/11/07]

From: David R. Baird
Subject: Re: pager
Date: 23:30 on 07 Nov 2004
On 22 Oct 2004 at 17:09, David R. Baird wrote:
> 
> On 22 Oct 2004 at 17:33, Emanuele Zeppieri wrote:
> 
> > something more general than a CDBI plugin - again, an SQL::Abstract
> > extension would be ideal IMO.)
> 
> I've got some rough code for an SQL::Abstract subclass, seems to be 
> straightforward so far. Watch this space. 


I've released SQL::Abstract::Limit to the CPAN. It auto-detects the 
appropriate dialect from a CDBI class or object, or a DBI handle, and 
generates sql that should work across a wide range of databases. It 
goes like this: 

my $sql = SQL::Abstract::Limit->new( limit_dialect => $dbh );

my( $stmt, @bind ) = $sql->select( $table, \@fields, \%where,
                                    \@order, $limit, $offset );

It _should_ work on just about any flavour of RDBMS, but I don't 
happen to have 6 or 8 of the things just at the moment, so if anyone 
is interested enough to give this a try against their own server and 
drop me a line to let me know if it works or not, I'd be very 
grateful. 


Cheers,

d.









        -- 
        Dr. David R. Baird
Riverside Content Management Systems
http://www.riverside-cms.co.uk

(message missing)

pager
David R. Baird 09:48 on 20 Oct 2004

Re: pager
David R. Baird 13:53 on 20 Oct 2004

Re: pager
David R. Baird 21:00 on 20 Oct 2004

Re: pager
merlyn (Randal L. Schwartz) 02:55 on 21 Oct 2004

Re: pager
David R. Baird 10:46 on 21 Oct 2004

Re: pager
David R. Baird 11:30 on 21 Oct 2004

Re: pager
merlyn (Randal L. Schwartz) 12:10 on 21 Oct 2004

Re: pager
David R. Baird 23:08 on 21 Oct 2004

Re: pager
Cees Hek 00:22 on 22 Oct 2004

Re: pager
Tony Bowden 08:34 on 22 Oct 2004

Re: pager
Emanuele Zeppieri 13:51 on 22 Oct 2004

Re: pager
David R. Baird 14:41 on 22 Oct 2004

Re: pager
David R. Baird 09:20 on 22 Oct 2004

Class::DBI modules not properly loaded under mod_perl ?
Michele Valzelli 10:55 on 22 Oct 2004

Re: pager
Emanuele Zeppieri 12:21 on 22 Oct 2004

Re: pager
David R. Baird 12:52 on 22 Oct 2004

Re: pager
Emanuele Zeppieri 15:33 on 22 Oct 2004

Re: pager
David R. Baird 16:09 on 22 Oct 2004

Re: pager
David R. Baird 23:30 on 07 Nov 2004

RE: pager
Emanuele Zeppieri 03:50 on 14 Nov 2004

Re: pager
Emanuele Zeppieri 13:25 on 22 Oct 2004

Generated at 11:35 on 01 Dec 2004 by mariachi v0.52