Re: MSSQL and DB::limitQuery
| From: | James 'Chip' Kaufman | Date: | Wed, 18 Jun 2003 14:12:09 +0000 |
| Subject: | Re: MSSQL and DB::limitQuery | ||
| References: | 1 2 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-6091@lists.php.net to get a copy of this message | ||
On Tuesday 17 June 2003 18:17, Mark B. Elrod wrote:
> I am writing an app in PHP and I wanted it to be fairly portable
> across different DBs so I decided to try using PEAR. So far I have
> been pretty happy but I am now having a problem with DB::limitQuery.
> In short it always returns the complete result set. Is this a known
> bug? I looked through the archives and found some advice to use
> DB_Pager so I might just go that route but I see now reason why
> limitQuery would not work. Maybe it is not implemented yet?
>
> elrod
1) limitQuery is still marked as 'experimental'
2) limitQuery works differently depending on the backend db. Which db
are you using? For example, it should return a limited result set for
MySQL, but return all values for Informix.
3) If you have access to the PEAR tree on your server, look at the db
specific files (eg, mysql.php, ifx.php, etc.) Look at modifyLimitQuery
and see what it does.
--
James 'Chip' Kaufman
jkaufman@wamnet.com
PGP key: 697D43DE