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 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]
