Re: script retrieval of column names

[Mike<mickalo>Blezien]

On Fri, 23 Feb 2001 09:53:47 -0800, Robb Garrioch <[EMAIL PROTECTED]>
wrote:

Robb,

Here's a snip that may help:
        # do the SELECT query here....

        $sth->execute ();

        # get column names to use for labels

        @label = @{$sth->{NAME}};
        for ($i=0;  $i<@label; $i++) 
          {
          print qq|Column Name: $label[$i]|;
          }

You can also for case by using NAME_lc(lowercase) or NAME_uc(uppercase)...

Hope this helps

Mickalo
>>Does anyone know of a DBI method ~or~ MySQL specific way that would
>>retrieve the column names of a MySQL database.table dynamically within a
>>Perl script using DBI? or Oracle if known.
>>
>>Thanks for any info!
>>
>>Robb
>>
>>

Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225) 686-2002