in reply to Re: DBD:Pg getting output in an array
in thread DBD:Pg getting output in an array

Actually I need to use the arrays to generate a chart.
  • Comment on Re^2: DBD:Pg getting output in an array

Replies are listed 'Best First'.
Re^3: DBD:Pg getting output in an array
by poj (Abbot) on Jul 27, 2014 at 19:33 UTC
    Try
    my $labels = []; my $data = []; while (my $ref = $sth->fetchrow_hashref()) { push @$labels,$ref->{'Labels'}; push @$data,$ref->{'Data'}; }
    poj
      Thanks Poj, its
      my $labels = []; my $data = []; while (my @row = $sth->fetchrow_array) { push @$labels, $row[0]; push @$data, $row[1]; }
      Rgds. Terry
Re^3: DBD:Pg getting output in an array
by Corion (Patriarch) on Jul 27, 2014 at 19:27 UTC

    So instead of using the parts to output them as a table, maybe use the two separate parts to generate your chart?

    I'm not exactly sure where your problem lies in taking the data and putting it to use, so I'm uncertain about how to help you better. Maybe you can tell me what parts you have problems with?