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 temporary table

fields query

2001-09-05 Thread Anthony E.
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

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 table