Re: SQL:Statement/Parser

On Thu, 2014-09-11 at 08:19 +1000, Ron Savage wrote:
> Hi Mauricio
> 
>  >Good morning!
> 
>  >I'm a Mexican PERL fan, and I write first for congratulate you for 
>  >this great job.

Welcome!  I blame Tim for most of the awesome.

> Glad to hear you're using Perl.
> 
> And yes, it's Perl, not PERL.

Well it's officially either Perl or perl (if you're speaking of the
interpreter) but we generally don't mind you calling it PERL for the
most part.  I've always been a fan of the backronym "Pathologically
Eclectic Rubbish Lister," which is, along with PERL, one of the
unofficial names.

(be nice, Ron! https://wp.colliertech.org/cj/?p=1069#lyrics)

>  >I've just download the SQL:Statement from CPAN via MCPAN shell since 
>  >my Ubuntu console, but I have some issues with the map {$_->name} 
>  >$stmt->column_defs() method for parsing it.
> 
>  >Indeed {$_->name} returns an error saying that name can't be found on 
>  >unbless object.
> 
> We need to see the code. Post the shortest possible sample code which 
> produces this error.

remember that the map operator iterates over the list in the second
argument executing the code in the first argument for each element of
the list.  $_ is set to the value currently being iterated.

This means that you expect $stmt->column_defs() to return a list of
objects which have the method 'name' defined in their package.  

I don't see the example code you've given in the perldoc for
SQL::Statement.  Can you tell us where you got it and what you're trying
to do?

> Are you connecting to a real, pre-existing database with pre-existing 
> tables?
> 
> If so, how /exactly/ are you doing that?

Yes, can you confirm that you've got a valid database handle and that
you can issue queries against it?

>  >I will appreciate too much, any information about this error that was 
>  >taken from CPAN documentation of this module.

URL please?

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)

iQEcBAABCAAGBQJUEOpuAAoJEEyimPmPQm23KzMIAKhRL1CN6d7t4tsPx66cGh6P
uVJ0rPme1XfPJIDijAQWP1MP4QjO0ul7jCuTBrzNAMtehSYzdzUMMZMbw/uUcwEl
jkLo1XX/d6Kq9tNC0/Bx8J8GrLHf/d0nmGM2IG91eOi/T6T+SKgYuEB9ruqyhs20
CfR/JUZPeHhiNUJaattda/14YM+BOBkXbSsJpFl/Z1sPTZ9Ic/SnlV/9bEexcFnU
D6O8HSUe3H1U4aW65kpHyLvlT92aq3Bw6R3ijdWUsLPpHXjtWUpsGM1jw+A+KIkz
IjqkvFWRhwS/WxjuKkPx+QCeanjVpFdiy1oVx/ja4Pr0D0ddQ6W4ilKJ5IQT+kA=
=ADjn
-----END PGP SIGNATURE-----