Thank you. Method from in resultset helped me. On Sat, May 30, 2009 at 2:04 AM, Peter Rabbitson <[email protected]<rabbit%[email protected]> > wrote:
> Андрей Костенко wrote: > > Has I can write in DBIx::Class this query: > > > > SELECT * FROM table1 LEFT JOIN table2 ON table2.table1_id=table2.id > > <http://table2.id>* AND table2.user_id=123*? > > > > Where* user_id* is an any random number. > > > > For now you have to do this manually. > > If the user_id is static (i.e. doesn't change) use: > > http://search.cpan.org/~ribasushi/DBIx-Class-0.08103/lib/DBIx/Class/Manual/Cookbook.pod#Arbitrary_SQL_through_a_custom_ResultSource<http://search.cpan.org/%7Eribasushi/DBIx-Class-0.08103/lib/DBIx/Class/Manual/Cookbook.pod#Arbitrary_SQL_through_a_custom_ResultSource> > > If the join condition is dynamic use the last example at: > > http://search.cpan.org/~ribasushi/DBIx-Class-0.08103/lib/DBIx/Class/ResultSet.pm#from<http://search.cpan.org/%7Eribasushi/DBIx-Class-0.08103/lib/DBIx/Class/ResultSet.pm#from> > > _______________________________________________ > 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] >
_______________________________________________ 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]
