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
temporary table
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
temporary table based on which fields are checked in
the form.
=
--
Anthony Ettinger
[EMAIL PROTECTED]
415-504-8048
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 table