| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 1.12.2 |
| Bug #1432 | limitQuery() unable to return very first record in Oracle DB | ||
|---|---|---|---|
| Submitted: | 2004-05-18 16:22 UTC | ||
| From: | roger at bgnet dot bgsu dot edu | Assigned: | danielc |
| Status: | Bogus | Package: | DB |
| PHP Version: | 4.3.4 | OS: | Unix |
| Roadmaps: | (Not assigned) | ||
[2004-05-18 16:22 UTC] roger at bgnet dot bgsu dot edu
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
Comments
[2004-05-18 16:40 UTC] roger at bgnet dot bgsu dot edu
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
[2004-05-18 16:50 UTC] danielc
"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.