Re: limitQuery

You should try using 0,4. Typically references start at 0, like in arrays. On May 18, 2004, at 12:01 PM, 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? Thanks, Roger -- PEAR General Mailing List (http://pear.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577