Zend Framework 2 - Zend\Db\Adapter\Driver\Sqlsrv\Result

[denozawr]

ZF2 2.0.6
In many cases very usefull fetchType=SQLSRV_FETCH_NUMERIC, but in function load of class Result i found only SQLSRV_FETCH_ASSOC. I think using SQLSRV_FETCH_BOTH will be better for all cases.

original code

Code: Select all

    protected function load($row = SQLSRV_SCROLL_NEXT)
    {
        $this->currentData = sqlsrv_fetch_array($this->resource, SQLSRV_FETCH_ASSOC, $row);
        $this->currentComplete = true;
        $this->position++;
        return $this->currentData;
    }


Why using SQLSRV_FETCH_ASSOC ?
I am executting many different stored procedures and user defined functions. In some cases i don't know collumn names...

[denozawr]

In Zend Framework 2.1.4 the problem still exists.

line 118

Code: Select all

$this->currentData = sqlsrv_fetch_array($this->resource, SQLSRV_FETCH_ASSOC, $row);

i fix it by this

Code: Select all

$this->currentData = sqlsrv_fetch_array($this->resource, SQLSRV_FETCH_BOTH, $row);