<font size=2 face="sans-serif">Yes, I can get the data that way, but I
have to specify each column by name that way and I am trying to get this
to be a bit more re-usable. I need to be able to use this on many different
pages, supplying a function that doesn't need to be embedded and custom
hard coded for each query. I am looking to be able to first, grab the names
of the columns so I can write the header row, then write the data, save
the file and offer it up to the browser to be saved. I can't find a way
to get a list of the field names from the result set, that would work as
I could then store them in vars and then loop through using the column
names to get the values for each cell.</font>
<br>
<br><tt><font size=2>Rob Kinyon <rob.kinyon@gmail.com> wrote on 07/05/2012
12:35:42 PM:<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 12:39 PM</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 10:21 AM, Kenneth S Mclane <ksmclane@us.ibm.com>
wrote:<br>
> > Well, I cannot seem to get anything out of the resulset, so I'm
grasping at<br>
> > whatever I can find. Perhaps you have something constructive
to add?<br>
> <br>
> How are you trying to get stuff out of the resultset? Have you tried:<br>
> foreach my $row ( $rs->all ) {<br>
> # Do something with $row->col1, $row->col2, etc<br>
> }<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>