[Dbix-class] Many to many relationship searching

Matt S Trout dbix-class at trout.me.uk
Sun Jul 20 00:33:19 BST 2008


On Mon, Jun 23, 2008 at 04:56:57PM +0200, jakac wrote:
> Actually in this case I must also use "distinct" ...
> 
> select DISTINCT a.* from articles a, categories c, categories_articles_rel 
> rel
> where
> a.article_id = rel.article_id
> and
> c.category_id = rel.category_id
> and
> c.user_id = '$someuser'
> order by a.title;
> 
> 
> Can somebody please "translate" this into DBIx::Class? thanx!

No. If you want to post the code you have so far, in full, we could try
and explain stuff.

But this is a mailing list for discussion and helping each other learn,
not one where you post a request and we write your code for you. We usually
call that "contract work" around here :)

-- 
      Matt S Trout       Need help with your Catalyst or DBIx::Class project?
   Technical Director                    http://www.shadowcat.co.uk/catalyst/
 Shadowcat Systems Ltd.  Want a managed development or deployment platform?
http://chainsawblues.vox.com/            http://www.shadowcat.co.uk/servers/



More information about the DBIx-Class mailing list