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