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