my $sql = $dbh->prepare ("sp_help") || die;; my $sth = $sql->execute or die "no ".$DBI::errstr; print "\n"; my $THdone; while (my $result_ref = $sql->fetchrow_hashref()){ unless ($THdone) { foreach (sort keys %$result_ref) { print ""; } $THdone = "yes, indeedy!"; } print ""; foreach (sort keys %$result_ref) { if (! defined $$result_ref{$_}) {print "";next} print ""; } print "\n";
Select me!$_
",checkbox(-name=>"view",-checked=>"", -value=>"$$result_r +ef{Name}"),"--undef--$$result_ref{$_}