Description: ------------ Using limitQuery() to try and grab record 1 through 5 in an Oracle database table. The result is always records 2 thorugh 6. I'm not sure if this is a bug, but someone from the mailing list stated that I may want to report it as one... Thanks, Roger Reproduce code: --------------- To get records 1 through 5: $res =& $db->limitQuery("SELECT ID,Name,Rate FROM newRecords ORDER BY st", 1, 5); Returns records 2 through 6 Tried this also: $res =& $db->limitQuery("SELECT ID,Name,Rate FROM newRecords ORDER BY st", 0, 5); Returns no records Expected result: ---------------- Records 1 through 5 Actual result: -------------- Records 2 through 6

I'm quite sure you're using an oudated version of DB.

How can I tell which version of PEAR is being used? Also, how can I tell which version of DB is being used? Thanks, Roger

"pear info DB" To upgrade DB: "pear upgrade DB" Or, to upgrade everything: "pear upgrade-all" FYI: type in the command "pear" and you'll see the help/usage output, which lists all sorts of intersting commands. Of course, these commands will only work as such if the pear directory is in your PATH or you are presently in the pear directory.

DB 1.5.ORC2 PEAR 1.3b3 Not sure what all of that means, but let me know if they are outdated.... Thanks, Roger

If I read everything correctly, the latest version is 1.6 something or other. I\'ll update my DB to the newest version... Thanks, Roger