[Dbix-class] Problem getting data from resultset

[John Romkey]

On Jul 9, 2012, at 2:04 PM, Kenneth S Mclane wrote:
> John Romkey <romkey at romkey.com> wrote on 07/09/2012 12:25:31 PM:
> 
> > > 
> > > Try: 
> > > 
> > > while( my $data_scalar = $sr->next )  { 
> > >       my @data = $data_scalar->all; 
> > > 
> > > instead 
> > > 
> > 
> > I actually changed it to this: my @data = $sr->all; I think this is 
> > equivalent isn't it? This does not give me any errors, but only 
> > outputs one row to the file. 
> > 
> > $sr is your resultset 
> > 
> > $sr->next gives you the next row 
> > 
> > $sr->all gives you all records 
> > 
> > http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/ResultSet.pm#all 
> > 
> > in my example $data_scalar->all will return the values of all the 
> > columns in that row - very different from getting all the rows in 
> > the resultset 
> > - john romkey 
> > http://romkey.com/ 
> 
> OK, I changed the code to your suggestion, but it resulted in this error: 
> 
> [error] Caught exception in dbms::Controller::AccountView->list "Can't locate object method "all" via package "dbms::Model::ORANGES::Accountv" at /opt/catalyst/dbms/script/../lib/dbms/Controller/AccountView.pm line 56." that is pointing at this line: 

Sorry Kenneth, I have had multiple brainfarts here.  I shouldn't try to be helpful on inadequate coffee. I think I just lost my Perl/DBIx::Class coding privileges. ;) You should just ignore me; I'm not making sense right now ;)
	- john

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20120709/7b87b4ff/attachment.htm