Re: pager

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

From: Cees Hek
Subject: Re: pager
Date: 00:22 on 22 Oct 2004
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 );



Cheers,

        -- 
        Cees Hek

(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