List:MySQL and Perl« Previous MessageNext Message »
From:James Gilbert Date:May 17 2000 1:14pm
Subject:$sth->{NAME} returns nothing
View as plain text  

Hi,

I'm writing an interactive command line tool that
accesses either the Oracle or MySQL databases
which we have here.

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.

	James

James G.R. Gilbert
The Sanger Centre
Wellcome Trust Genome Campus
Hinxton
Cambridge                        Tel: 01223 494906
CB10 1SA                         Fax: 01223 494919
Thread
• $sth->{NAME} returns nothingJames Gilbert17 May
  • Re: $sth->{NAME} returns nothingJochen Wiedmann17 May
    • Re: $sth->{NAME} returns nothingJames Gilbert17 May