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

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 http: