Hello,

fetchall_arrayref() returns a reference to an array of array.

$ref = $sth->fetchall_arrayref();
$ref = [
        ['test1', 1],
        ['test2', 2]
       ];
[download]

It does not return a reference to an array of hashes.

$ref = [
        {data => 'test1', ID => 1},
        {data => 'test2', ID => 2}
       ];
[download]

And because of that difference you can not pass it directly to the template-module. But you could change your template-module to accecpt arrays instead of hashes.

Good bye,
uwe