Re^3: Template::Toolkit - How do i access alias-based results?

[tangent]

Using that code your @aRows will end up like this:

row1-iVertragsnummer
row1-sArtikelNr
row1-sVertragsStatus
row1-sVertragsDatum
row1-iMsgID
row2-iVertragsnummer
row2-sArtikelNr
row2-sVertragsStatus
row2-sVertragsDatum
row2-iMsgID
...etc

I suspect you need something like this:

{
    iVertragsnummer => 'row1-iVertragsnummer',
    sArtikelNr => 'row1-sArtikelNr',
},
{
    iVertragsnummer => 'row2-iVertragsnummer',
    sArtikelNr => 'row2-sArtikelNr',
},

So try changing to:

while ( my $row =  $hStatement->fetchrow_hashref() ) {
   push ( @aRows, $row );
}

[Yaerox]

Yeah this fixed it. I was trying around with fetchrow_arrayref but then I was in an endless loop. I should have better taken hasref ;)

Anyway, thank you sir.

[sundialsvc4]

Bingo.   I think that the data-structure is wrong.   Data::Dumper will quickly show you what the data actually looks like, and (as noted elsewhere) so will Template itself.

What you need to come up with is an array of hashrefs, one per record, preferably the correct “slice” of a larger result set.   The template then loops through this array.