Re: Perl DBI -- How to select all returned values into an array

[Paul DuBois]

At 10:07 AM -0700 8/24/01, Katherine Porter wrote:
>For single values I usually use this DBI function and query:
>
>   my $val =3D $dbh->selectrow_array("SELECT value FROM tab1 WHERE test=3D=
>2");
>
>However, what if I want to store a bunch of values into an array?
>
>   my @vals =3D $dbh->?????("SELECT value FROM tab1 WHERE test > 10");
>
>What's the syntax I'm missing above?  Any help appreciated!
>
>[.kate]


my $ref = $dbh->selectcol_arrayref (single-column query);
my @val = (defined ($ref) ? @{$ref} : () );

-- 
Paul DuBois, paul@stripped