Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Column names

Mar 20, 2003, 12:21 PM
afinlr
Veteran (1921 posts)
Mar 20, 2003, 12:21 PM
Post #1 of 6
Views: 2025
Shortcut
Quote Reply
Column names
Hi,

I'm trying to find a way to read the column names from a table into a list - so that I can input the name of any table and a list of the columns is returned. Any ideas?

Thanks,

Laura.
The UK High Street
Mar 20, 2003, 12:44 PM
yogi
Veteran / Moderator (2199 posts)
Mar 20, 2003, 12:44 PM
Post #2 of 6
Views: 1959
Shortcut
Quote Reply
Re: [afinlr] Column names In reply to
Code:
$DB->table('table_name')->{schema}->{cols}

Ivan
-----
Iyengar Yoga Resources / GT Plugins
Mar 20, 2003, 12:50 PM
afinlr
Veteran (1921 posts)
Mar 20, 2003, 12:50 PM
Post #3 of 6
Views: 1964
Shortcut
Quote Reply
Re: [yogi] Column names In reply to
Thanks a lot Ivan - I knew it would be a simple command, I just couldn't find it.
Mar 20, 2003, 1:20 PM
Paul
Veteran (19537 posts)
Mar 20, 2003, 1:20 PM
Post #4 of 6
Views: 1950
Shortcut
Quote Reply
Re: [afinlr] Column names In reply to
This may be useful to you:

Code:
require GT::Dumper;

print $IN->header();
print GT::Dumper::Dumper($DB->table('Links'));

...that will show you everything the table object contains. You can substitute "Links" for any table.
Mar 20, 2003, 1:52 PM
webmaster33
Veteran (2312 posts)
Mar 20, 2003, 1:52 PM
Post #5 of 6
Views: 1953
Shortcut
Quote Reply
Re: [yogi] Column names In reply to
Quote:
$DB->table('table_name')->{schema}->{cols}
or
$DB->table('table_name')->cols

It returns a hashref.

Best regards,
Webmaster33

Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...
Mar 20, 2003, 2:06 PM
afinlr
Veteran (1921 posts)
Mar 20, 2003, 2:06 PM
Post #6 of 6
Views: 1930
Shortcut
Quote Reply
Re: [Paul] Column names In reply to
Very useful. Thanks Paul.