On Sat, Sep 19, 2009 at 3:23 PM, Wallace Reis <[email protected]> wrote:
> On Sat, Sep 19, 2009 at 2:16 PM, Shawn Marincas
> <[email protected]> wrote:
>> It seems that the above query won't work in any case since searching for
>> tag_id IN a set will still returned the results OR'd together, and I need
>> the set of products which contain BOTH tags. I've been toying with it some
>> more and came up with a solution which uses a subquery, still not sure if
>> this is the optimum solution yet or not.
>
> Right. You need of a query using XOR op in WHERE clause plus DISTINCT clause.
Hmm. Sorry, that won't work for your case.
--
wallace reis/wreis Catalyst and DBIx::Class consultancy with a clue
Software Engineer and a commit bit:
http://shadowcat.co.uk/catalyst/
Shadowcat Systems Limited
http://www.shadowcat.co.uk http://www.linkedin.com/in/wallacereis
_______________________________________________
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]
