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