Re: MSSQL, SP, Columns and datatypes

This should give you the column names:

my @col_names = keys %{$sth->fetchrow_hashref};
[download]

my @col_names = @{$sth->{NAME}};
[download]

For types try

my @col_types = @{$sth->{TYPE}};
[download]

Comment on Re: MSSQL, SP, Columns and datatypes Select or Download Code

Replies are listed 'Best First'.
Re^2: MSSQL, SP, Columns and datatypes by 2ge (Scribe) on Nov 08, 2004 at 15:17 UTC
thanks a lot Arunbear! types works, but it gives me numbers only, I read DBI docs, and I found: `my @names = map { scalar $dbh->type_info($_)->{TYPE_NAME} } @{ $sth->{ +TYPE} };` [download] which works perfectly. Thanks anyway for pointing me.	[reply] [d/l]