| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 1.12.3 |
| Bug #81 | PEAR::DB mssql implementation uses fetch_array where intension is fetch_assoc | ||
|---|---|---|---|
| Submitted: | 2003-10-09 00:01 UTC | ||
| From: | jcalixto at activevoice dot com | Assigned: | lsmith |
| Status: | Closed | Package: | DB |
| PHP Version: | Irrelevant | OS: | all |
| Roadmaps: | (Not assigned) | ||
[2003-10-09 00:01 UTC] jcalixto at activevoice dot com
Description:
------------
Found while trying to access a ms sql server using tiki wiki's dsn feature.
The result set that mssql.php returns when called like this:
$result->fetchRow(DB_FETCHMODE_ASSOC);
is not an associative array but a plain array.
Reproduce code:
---------------
The fetchInto function currently does:
if ($fetchmode & DB_FETCHMODE_ASSOC) {
$ar = @mssql_fetch_array($result);
when it should do this:
if ($fetchmode & DB_FETCHMODE_ASSOC) {
$ar = @mssql_fetch_assoc($result);
Expected result:
----------------
only 1 set of columns per result with the headers being the names of the columns
Actual result:
--------------
duplicate columns -> the first set has the column index as the header, the second set has the actual column name as the header
Comments
[2003-11-04 09:47 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!