UnionOfRAD/lithium — Issue #252: mysql read resource returns numeric array instead of associative.
Author: andraskende
Created: 2012-01-07 05:39:11+00:00
State: open

I just noticed this below, used to work before.
I think this is also recent nysql pdo related:

Controller:

use lithium\data\Connections;
...
$products = Connections::get('default')->read('SELECT * from products', array('return' => 'resource'));

View:

Produces numeric array :

Array ( [0] => 1 [1] => Product 1 [2] => product1 [3] => description product 1 [4] => 1.jpg [5] => 9.95 [6] => 1.00 [7] => 2011-10-12 04:04:08 [8] => 2011-11-28 06:32:03 )