my $sql = $dbh->prepare ("sp_columns $_") || die;; #### my $sql = $dbh->prepare ("SHOW COLUMNS FROM $_") || die; #### my @tables = $dbh->ListTables; print "\n"; foreach (@tables) { print ""; if(! (defined $tables[$_]) ) { print ""; } else { print ""; } print "\n"; } #### my $sql = $dbh->prepare ("sp_help") || die;; my $sth = $sql->execute or die "no ".$DBI::errstr; print "
Select me!
",checkbox(-name=>"view",-checked=>"", -value=>"$tables[$_]"),"--undef--$tables[$_]
\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"; #### if (! defined $$result_ref{$_}) { print ""; print ""; next; } print ""; print "";
Select me!$_
",checkbox(-name=>"view",-checked=>"", -value=>"$$result_r +ef{Name}"),"--undef--$$result_ref{$_}
",checkbox(-name=>"view",-checked=>"", -value=>),"--undef--",checkbox(-name=>"view",-checked=>"", -value=>"$$result_ref{$_}"),"$$result_ref{$_}