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
