in reply to Dereferencing fetchall_arrayref({})

This is one of those moments when as an adjunct professor I always take time out to tell my students how the watch works before I tell them what time it is.

First off a quick review of what an array reference is:

# make an array reference: my $ref = \@rry; # # or an anoonymous array: my $ref2=[ "stuff", "things", "goodies"]; </ocde> If I have a function returning an arrey reference: <code> my $rows=$sth->fetchall_arrayref;
Then to dereference it I would do the following:
my @array=@{$sth->fetchall_arrayref};

But wait! If I am passing an array to HTML::Template's param method then I'm going to want to pass an anoymous array such as:

$template->param(selscene => [ @array ] );

Hope my brain fried ramblings make sense and help...