my @all_user_notes =
$schema->resultset('User')->search( username => $username )->notes;
Easier, if you've already got the user object instantiated.
my @all_user_notes = $user->notes;
I think that does (a lot more simply) what you want.
Devin Austin wrote:
I'm using this code to attempt to retrieve a related table's info:
my @all_user_notes = $user_notes->search_related('notes',
{
username => $session->param('username')
}
);
my @user_notes = map {
{
'noteid' => $_->noteid,
'number' => $_->number,
'date' => $_->date,
'private' => $_->private,
}
} @all_user_notes;
And I'm getting this when I run Data::Dumper on @user_notes:
$VAR1 = {
'number' => undef,
'date' => undef,
'private' => undef,
'noteid' => undef
};
Why would all my fields be coming up empty?
--
timorperfectus.com <http://timorperfectus.com> - web design to
frightening perfection.
One last song
Given to an Angel's Son
As soon as you were gone
As soon as you were gone
------------------------------------------------------------------------
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/[email protected]/
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/[email protected]/
