On 10/28/08, Brandi Cantarel <[EMAIL PROTECTED]> wrote: > I would like to join 2 tables using DBIx::Class but I get this error: > > Can't handle this yet :( > > when my starting table "belongs" to the second table?? I don't > understand, can I only join starting from tables where that table is > the owner of the primary key from which to join? I would actually > like to join many tables and would like to start the join with this > "belongs_to" table as I would if I were using simple DBI. > > There is a one to one relationship between the two tables I would > like to join. > > > BTW, does anyone know how to "print" the SQL the program is > producing. Sometimes I get errors and I feel like looking at the > actual SQL would help alot.
Hi Brandi, I think you might want to take a look at the DBIx::Class Cookcook: http://search.cpan.org/perldoc?DBIx::Class::Manual::Cookbook The "JOINS AND PREFETCHING" and "DEBUGGING AND PROFILING" sections should get you going in the right direction! -- Cory 'G' Watson http://www.onemogin.com _______________________________________________ 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]
