Re: setLimit and _modifyQuery broken on MDB2
| From: | Justin Patrin | Date: | Wed, 06 Apr 2005 20:53:42 +0000 |
| Subject: | Re: setLimit and _modifyQuery broken on MDB2 | ||
| References: | 1 2 3 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-18555@lists.php.net to get a copy of this message | ||
On Apr 6, 2005 1:35 PM, Dan Rossi <pear@electroteque.org> wrote:
>
> On 07/04/2005, at 2:08 AM, Justin Patrin wrote:
>
> >
> > Well, that's in the common driver object. The mysql driver, for
> > instance, does do something here. But I don't think that _modifyQuery
> > does what you think it does. It looks like it's only for drivers to
> > alter SQL to make it work on their DB.
> >
> > The setLimit values ae used in (at least in the mysql driver's case)
> > in the query method to add a LIMIT to the SQL. The LIMIT values should
> > be used...
> >
> > What DB are you using for all of these tests? Perhaps the driver for
> > your DB isn't as fully featured as you think?
> >
>
> Mysql ? lol . Its there, i think there is a bug, i echoed the output
> within _modifyQuery limit was there, i echoed the output of
> _modifyQuery from within the query method in the common class, no limit
> was there freak!
>
Why are you calling me a freak?
Are you using =& when getting your MDB object? This *might* help.
--
Justin Patrin