Re: fields query

2001-09-06 Thread Adams, Bill TQO
Harald Fuchs wrote: > In article <[EMAIL PROTECTED]>, > "Adams, Bill TQO" <[EMAIL PROTECTED]> writes: > > >> I need to read the fields of a table dynamically using > >> DBI.pm > >> > >> The resulting cgi script should be a form that has a > >> checkbox for each field...the user will then create a

Re: fields query

2001-09-05 Thread Adams, Bill TQO
my $dbh = DBI->connect( ... ); my $sth = $dbh->prepare( "SHOW COLUMNS FROM $table" ) or die; $sth->execute( ) or die; my @columns; while( my( $column_name ) = $sth->fetchrow_array( )){ push @columns, $column_name; } $sth->finish( ); b. "Anthony E." wrote: > I need to read the fields of a ta