[Dbix-class] Problem getting data from resultset

[Rob Kinyon]

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