i have added 'has_many' to the supported relationship by prefetch. see attachment.
cheers, Qiang
--- ResultSet.pm.orig 2008-07-12 03:41:28.917805920 -0500 +++ ResultSet.pm 2008-07-12 03:41:48.506827936 -0500 @@ -2447,7 +2447,7 @@ for a C<join> attribute in the above search. C<prefetch> can be used with the following relationship types: C<belongs_to>, -C<has_one> (or if you're using C<add_relationship>, any relationship declared +C<has_one>, C<has_many> (or if you're using C<add_relationship>, any relationship declared with an accessor type of 'single' or 'filter'). A more complex example that prefetches an artists cds, the tracks on those cds, and the tags associted with that artist is given below (assuming many-to-many from artists to tags):
_______________________________________________ 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]