Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

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

by zby (Vicar)
on May 30, 2006 at 12:25 UTC ( [id://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 lurking in the Monastery: (3)
As of 2024-06-13 00:43 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?
    erzuuli‥ 🛈The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.