Re: script retrieval of column names

On Fri, 23 Feb 2001 09:53:47 -0800, Robb Garrioch <robb_g@mindspring.com>
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

• script retrieval of column names by Robb Garrioch
• Re: script retrieval of column names by Tony Foiani
• Re: script retrieval of column names by Ken Speich
• Re: script retrieval of column names by Mike<mickalo>Blezien