3 messages in com.mysql.lists.perlRe: $sth->{NAME} returns nothing
FromSent OnAttachments
James Gilbert17 May 2000 06:14 
Jochen Wiedmann17 May 2000 07:39 
James Gilbert17 May 2000 08:20 
Subject:Re: $sth->{NAME} returns nothing
From:James Gilbert (jg@sanger.ac.uk)
Date:05/17/2000 08:20:31 AM
List:com.mysql.lists.perl

Thanks Jochen,

It now works!

James

On Wed, 17 May 2000, Jochen Wiedmann wrote:

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.

James G.R. Gilbert The Sanger Centre Wellcome Trust Genome Campus Hinxton Cambridge Tel: 01223 494906 CB10 1SA Fax: 01223 494919