[Dbix-class] Problem getting data from resultset

[Kenneth S Mclane]

Well, I cannot seem to get anything out of the resulset, so I'm grasping 
at whatever I can find. Perhaps you have something constructive to add?

Rob Kinyon <rob.kinyon at gmail.com> wrote on 07/05/2012 11:34:23 AM:

> From:
> 
> Rob Kinyon <rob.kinyon at gmail.com>
> 
> To:
> 
> "DBIx::Class user and developer list" <dbix-class at lists.scsys.co.uk>
> 
> Date:
> 
> 07/05/2012 11:46 AM
> 
> Subject:
> 
> Re: [Dbix-class] Problem getting data from resultset
> 
> On Thu, Jul 5, 2012 at 9:28 AM, Kenneth S Mclane <ksmclane at us.ibm.com> 
wrote:
> > I have a resultset I stuff into the stash for display. This works 
fine, but
> > I am working on exporting the data to Excel using 
Spreadsheet::WriteExcel.
> > When I use $sr->result_source->columns I get a list of the fields in 
the
> > main table, but none of the columns from related tables, and I get all 
the
> > fields from that table even though I am only calling for 4 with a 
"columns
> > => [list of columns]". Then when I try to iterate though the data with
> > $sr->next(); the server stops responding. I have scoured the docs and 
cannot
> > find any help.
> 
> What do you think asking the resultsource should tell you? The
> resultsource is the definition of the source of the data. It doesn't
> change just because you only picked N columns for this specific
> resultset.
> 
> Rob
> 
> _______________________________________________
> List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive: 
http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20120705/409e1f71/attachment.htm