in reply to DBI gives "undef" for specific row

G'day hpeters,

Welcome to the monastery.

As already pointed out, you seem to be using the term "row" where you mean "column". Please provide a clarification on that.

If $VAR1 represents a row, then you have columns with names like 'rowN'. That seems somewhat strange and leads me to wonder if $VAR1 really does represent a row. Again, please clarify.

Assuming $VAR1 is a row and the keys shown are the column names, then you have two columns with the same name (i.e. 'row2'):

'row2' => undef, 'row2' => '36688.00',

Perhaps a typo by you or a wrong assumption by me: either way, a correction or further clarification is required.

-- Ken