sybperl-l Archive

From: "Louis Proyect" <lnp3 at columbia dot edu>
Subject: Column headings question
Date: Oct 7 2009 3:39PM

Is there an easier way to access column headings than this:

@res=$dbh->ct_sql("exec stored_procedure");

@res2=$dbh->ct_sql("sp_help table_name"); ---> this is the table that
maps to the stored procedure results

$cntr = 0;

foreach $row (@res2)   # Loop through each row
{
  print "@$row[0]: ";
  print "$res[0][$cntr]\n";
  $cntr++;
}

Most importantly, this only works if the stored procedure is returning
results that map to a single table. If the results are from joined
tables, you are out of luck.