Hi

Say I have two tables, invoices and invoice_lines, where the relationship is one to many. If we pass a resultset of the invoices to a TT template, is it possible to chain an a method on the resultset to get a count of he invoice lines? I don't mind going back to the db to do exta fetches per line as there will never be more than 20 invoices. i.e., I want to do something like this:

        [% WHILE (invoice = invoices.next) %]
        <tr>
            <td>[% invoice.invoice_number %]</td>
<td>[% invoice.invoice_lines.count %]</td> <-- something that does this
        </tr>
        [% END %]

Regards

Dan


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

Reply via email to