Re: NAME on statement handle???

Felipe Gasper <[email protected]>
Newsgroups gmane.comp.db.mysql.perl
Message-ID <[email protected]>
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/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.