List:MySQL and Perl« Previous MessageNext Message »
From:Jochen Wiedmann Date:May 17 2000 2:39pm
Subject:Re: $sth->{NAME} returns nothing
View as plain text  

James Gilbert wrote:

> I want to show the headings of columns in the
> answers to queries, which I can get by calling
> accessing the {NAME} parameter on the statement
> handle.  This works for Oracle, but not for MySQL
> which returns undef.  I've tried the latest
> versions of DBI and DBD::mysql from CPAN, but this
> doesn't make a difference.  Our MySQL server is
> version 3.22.32 running on DEC OSF.

Try accessing NAME *after* execute and *before* fetch.
Thread
• $sth->{NAME} returns nothingJames Gilbert17 May
  • Re: $sth->{NAME} returns nothingJochen Wiedmann17 May
    • Re: $sth->{NAME} returns nothingJames Gilbert17 May