Re: Help with a plperl function

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/