Re: pager

[prev] [thread] [next] [Date index for 2004/10/22]

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

On 22 Oct 2004 at 10:22, Cees Hek wrote:

> On Wed, 20 Oct 2004 22:00:46 +0100, David R. Baird
> <dave@xxxxxxxxxxxxx.xx.xx> wrote:
> >     use Class::DBI::Plugin::Pager;
> > 
> >     # or to use a different LIMIT syntax
> >     # use Class::DBI::Plugin::Pager::MySQL;
> > 
> >     __PACKAGE__->set_db(...);
> 
> Should the pager plugin not be able to automatically detect which
> database is currently being used, and use the correct syntax based on
> that.
> 
> A system for providing a custom syntax would still be needed for
> Databases that are not supported, but it should be able to work
> automatically for the majority should it not.   The 'get_info' method
> of DBI can provide the database name?   The following is from the DBI
> docs:
> 
> Type  Name                        Example A     Example B
> ----  --------------------------  ------------  ----------------
> 17  SQL_DBMS_NAME               'ACCESS'      'Oracle'
> 18  SQL_DBMS_VER                '03.50.0000'  '08.01.0721 ...'
> 
> $dbms_name = $dbh->get_info( 17 );

OK, that would be good, but now I need to know which databases use 
which syntax. Any info gratefully received. But I suppose these can 
be added over time. At the moment all I know is Postgre, MySQL, and 
InterBase/FireBase. I suspect various other databases use the same 
syntax as one of these. And I think both MySQL and Postgre changed 
their LIMIT syntax in fairly recent versions, I'm sure I can track 
that down. 

Cheers,

d.


> 
> 
> 
> Cheers,
> 
> -- 
> Cees Hek




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