limitQuery

From: Date: Tue, 18 May 2004 16:01:06 +0000
Subject: limitQuery
Groups: php.pear.general 
Request: Send a blank email to pear-general+get-12568@lists.php.net to get a copy of this message
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? Thanks, Roger

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