Bart Lateur writes:
> [beginners list snipped]
>
> On Fri, 11 Jan 2002 11:40:03 +0100, Marius Keraitis wrote:
>
> >Second step is to show every table contents (by clicking on link with table
> >name).
> >To do this I need to know how many columns is in table, and all names of columns
> >in table.
>
> You can do (very portable):
>
> my $sth = $dbh->prepare("SELECT * FROM $table");
I would add WHERE 1=0 there to make sure that no actual rows are
fetched (although that may not work on all database servers it's a
common idiom).
Michael
--
Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
[EMAIL PROTECTED] - [EMAIL PROTECTED]
International Sybase User Group - http://www.isug.com