On Tue, Apr 19, 2005 at 03:00:07AM +1000, Alex wrote:
>
> i am having a problem with a plperl function. bellow function always
> returns me an error saying "elements of Perl result array must be
> reference to hash"
[snip]
> my $row = $rv->{rows}[$rn];
> my @record;
>
> $record[0] = $row->{item_id};
> $record[1] = $row->{item_descr};
> $record[2] = $row->{start_date};
>
> push @$res, @record;
You should be pushing a hash reference, not an array. Try something
like this:
my $row = $rv->{rows}[$rn];
push @$res, {item_id => $row->{item_id},
description => $row->{item_descr},
order_date => $row->{start_date}};
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/