[Catalyst] Can't get value from model

[Kenneth S Mclane]

David Schmidt <davewood at gmx.at> wrote on 06/13/2012 04:15:57 PM:

> From:
> 
> David Schmidt <davewood at gmx.at>
> 
> To:
> 
> The elegant MVC web framework <catalyst at lists.scsys.co.uk>
> 
> Date:
> 
> 06/13/2012 04:16 PM
> 
> Subject:
> 
> Re: [Catalyst] Can't get value from model
> 
> Hi Kenneth,
> 
> that's a DBIC question
> 
> 
> anyways, what is the output of ...
> 
> if ( $dept ) {
>    warn "REF: " . ref $dept . " DEPT_ID: " . $dept->department_id;
> } else {
>    warn "No dept found";
> }
> 
> ... after your query?
> 
> On 13 June 2012 22:54, Kenneth S Mclane <ksmclane at us.ibm.com> wrote:
> > I am trying to get the value from a model call into a variable so I 
can use
> > it for creating a DB record. I have tried multiple ways and cannot get 
the
> > value to return. Here is my current attempt:
> >
> > my $dept = 
$c->model('ORANGES::Departments')->search_rs({'department_code'
> > => $departmentcode}, {
> >                 columns => ['department_id'] });
> >
> > This returns "1".
> >
> > I tried this:
> >
> > my $dept = 
$c->model('ORANGES::Departments')->search_rs({'department_code'
> > => $departmentcode}, {
> >                 columns => ['department_id'] })->single;
> >
> > and got a hash reference. I know I am missing something very simple. 
If I
> > was putting this into the stash I know I could access the value, but I 
am at
> > a loss as to how to get to it inside my code.
> >
> >
[error] Caught exception in dbms::Controller::Account->add "Can't locate 
object method "department_id" via package "DBIx::Class::ResultSet" at 
/home/ksmclane/catalyst/dbms/script/../lib/dbms/Controller/Account.pm line 
49."

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20120613/5d3aac60/attachment.htm