Retrieving column names using DBI and SQL Server
- From: lion_oooo@xxxxxxxxxxx
- Date: 28 Jul 2005 16:54:35 -0700
How would I retrieve the column names from the code below using DBI?
Keep in mind that I am calling a stored procedure in SQL Server in my
statement. $sth->{NAME} won't return what I'm looking for exactly...
use DBI;
....
# stored procedure call.
my $statement = "sp_example 'apples'";
my $sth = $self->dbh->prepare($statement);
$sth->execute;
my $rv = $sth->fetchrow_arrayref;
....
The stored procedure would look something like this:
create procedure sp_example (@abc varchar(100)) as
select
*
from fruits
where
type = @abc
GO
.
- Prev by Date: Need Help with Unicode on ActivePerl 5.8.6, MS SQL 2000
- Next by Date: Re: [Catalyst] DBIx-Class list, cdbi-talk closure (fwd)
- Previous by thread: Need Help with Unicode on ActivePerl 5.8.6, MS SQL 2000
- Next by thread: Re: [Catalyst] DBIx-Class list, cdbi-talk closure (fwd)
- Index(es):
Relevant Pages
|
