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