On 2/17/08, Paul Makepeace <[EMAIL PROTECTED]> wrote: > I have two tables of things, user and widget. I have a join table > user_widget and have set up the DBIC bits so I can say @widgets = > $user->widgets(). Now, for each of @widgets I actually want a piece of > info in user_widgets, color (i.e. each user can customize the > appearance of their widget). > > Is there any way to get that (ideally prefetched) color from the join > table, given a $bar? Or do I have to get a list of the join table
(I meant $widget here; it was previously 'foo' and 'bar' and that seemed too abstract :-)) > entries prefetching widget and then iterate over that? > > I'm aiming for, e.g., > > my @widgets :Stashed = $user->widgets; > > [% FOREACH widget = widgets %] > <td>[% widget.name %] has color [% widget.[magic here?].color %]</td> > [% END %] > > Thanks, > Paul > _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[EMAIL PROTECTED]
