Re: Select quuery result sets

[petecm99]

in reply to Select quuery result sets

You should be able to reference them as individual fields, like so:

$emp_qry->execute();
while ( my $emprec = $emp_qry->fetchrow_hashref ) {
    $tmp_e1 = $emprec->{e1};
    $tmp_e2 = $emprec->{e2};
    $tmp_e3 = $emprec->{e3};
    $tmp_e4 = $emprec->{e4};
}
$emp_qry->finish();

Hope this helps...