Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re: DBIx::Class and many-to-many searching

by zby (Vicar)
on May 30, 2006 at 12:25 UTC ( #552479=note: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    SELECT * FROM 
    article, articlelinks, articlelinks articlelinks_2, articlelinks artic
    +lelinks_3 ...
    ...
    article.id = articlelinks.article AND articlelinks.id = $with[0] AND
    article.id = articlelinks_1.article AND articlelinks_1.id = $with[1] A
    +ND
    ...
    
  2. or download this
    my %params;
    $params{'articlelinks.id'} = $with[0];
    ...
            join => [ 'articlelinks' x scalar( @with ) ]
        }
    );
    

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://552479]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others examining the Monastery: (4)
As of 2023-12-04 10:34 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    What's your preferred 'use VERSION' for new CPAN modules in 2023?











    Results (25 votes). Check out past polls.

    Notices?