Re: limitQuery

From: Date: Tue, 18 May 2004 16:10:52 +0000
Subject: Re: limitQuery
References: 1  Groups: php.pear.general 
Request: Send a blank email to pear-general+get-12569@lists.php.net to get a copy of this message
Roger Spears wrote:
Hello, I'm using PEAR to query an Oracle database. I'm wondering if anyone else has experience with this combination because when I use limitQuery, I'm never able to retrieve the very first record. It's not a big problem for me as far as functionality goes, but I'm curious if I'm doing something wrong... I'm trying to grab records 1 through 5. Here's my statement: $res =& $db->limitQuery("SELECT ID,Name,Rate FROM newRecords ORDER BY st", 1, 5); Oddly enough, it returns record 2 through 6. I've tried to use 0 and 5, but that doesn't return anything. I'm unable to get that very first record.?.?. Can anyone point out if I'm doing something wrong?
hmm that sounds like it could potentially be a bug .. i dont see anything wrong in your sample code. i suggest you submit a bug report for this one: pear.php.net/bugs regards, Lukas Smith smith@backendmedia.com _______________________________ BackendMedia www.backendmedia.com berlin@backendmedia.com Linn Zwoch Smith GbR Pariser Str. 44 D-10707 Berlin Tel +49 30 83 22 50 00 Fax +49 30 83 22 50 07

« previous php.pear.general (#12569) next »