Home > Archive > PHP Pear > November 2004 > Re: [PEAR] Re: DB getRow() and limit 1
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: [PEAR] Re: DB getRow() and limit 1
|
|
| Justin Patrin 2004-11-24, 8:56 pm |
| On Wed, 24 Nov 2004 22:59:29 +0100, Lukas Smith <lsmith@php.net> wrote:
> Brice Joly wrote:
>
> no it does not.
>
Because some DB backends don't support it or have different syntax for
it? Could the backends which support it implement a wrapper which adds
it?
--
Justin Patrin
| |
| Lukas Smith 2004-11-24, 8:56 pm |
| Justin Patrin wrote:
> On Wed, 24 Nov 2004 22:59:29 +0100, Lukas Smith <lsmith@php.net> wrote:
>
>
>
> Because some DB backends don't support it or have different syntax for
> it? Could the backends which support it implement a wrapper which adds
> it?
there is emulation in place for all relevant drivers to handle limit.
however in some cases its rather nasty, so the best way is just to write
proper queries.
regards,
Lukas
| |
| Lukas Smith 2004-11-25, 8:59 am |
| Lukas Smith wrote:
> Justin Patrin wrote:
>
>
>
> there is emulation in place for all relevant drivers to handle limit.
> however in some cases its rather nasty, so the best way is just to write
> proper queries.
note however that I have added it to MDB2 a while back if i remember
correctly. The two main reasons why I have it there is that in MDB2 its
easier to combine limits with any query that executes a query and also I
have stayed away from overly complex limit emulations (which means that
for those RDBMS they get a more severe performance hit when people rely
on limit).
regards,
Lukas
|
|
|
|
|