NAME on statement handle???

NAME on statement handle???

am 13.08.2005 22:53:35 von Felipe Gasper

I'm working with DBD::mysql 3.0002 in ActivePerl 5.8 for Windows, and
when I get a statement handle from a SELECT query, there's no NAMES
attribute on the handle object.

All the documentation I've seen indicates that this property should be
there. Is it strangely missing or something? NUM_OF_FIELDS is there.....

-Felipe Gasper
Cincinnati, OH

--
Felipe M. L. Gasper, conductor/singer
http://felipegasper.com

Quidquid latine scriptum sit altum viditur.
Si hoc legere scis, nimis eruditionis habes.

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: NAME on statement handle???

am 14.08.2005 00:04:25 von Felipe Gasper

An update on this. Any suggestions, please?

This won't work:
-------------------
$sth = $dbh->prepare($qry);
$sth->execute();
#$sth->{NAME};
$data = $sth->fetchall_arrayref();
print join(',',@{$sth->{NAME}});
-------------------

.....unless that line in the middle is commented out.

Does fetchall_arrayref() "reset" something in the statement handle?

-Felipe Gasper
Cincinnati, OH

Quoth Felipe Gasper on 8/13/2005 4:53 PM...
> I'm working with DBD::mysql 3.0002 in ActivePerl 5.8 for Windows, and
> when I get a statement handle from a SELECT query, there's no NAMES
> attribute on the handle object.
>
> All the documentation I've seen indicates that this property should be
> there. Is it strangely missing or something? NUM_OF_FIELDS is there.....
>
> -Felipe Gasper
> Cincinnati, OH
>

--
Felipe M. L. Gasper, conductor/singer
http://felipegasper.com

Quidquid latine scriptum sit altum viditur.
Si hoc legere scis, nimis eruditionis habes.

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org