Re: scrolling list

I'm afraid you'll need to be a bit more specific -- perhaps provide some code? fetchrow_array by itself just returns a perfectly normal array. Thus:

my $sth = $dbh->prepare("SELECT foo,bar FROM baz");
$sth->execute;
while (my @row = $sth->fetchrow_array) {
  print join "\t", @row;
  print "\n";
}
[download]

By "scrolling list," do you mean some sort of CGI form? A Tk widget? Give us a little more to go on..

Update: Applying judicious use of the PSI::ESP module, I'm assuming:

You want an HTML scrolling list
You're using CGI.pm (which should be a given if the first is true)
Your query only returns one column, and you want that whole column in the scrolling list

my $sth = $dbh->prepare("SELECT foo,bar FROM baz");
$sth->execute;
my @data;
while (my @row = $sth->fetchrow_array) {
  push @data, $row[0];
}
print $query->scrolling_list(-name   => 'list_name',
                             -values => [@data]);
[download]