Anyone use "-in" in SQL::Abstract/DBIC?
> warn "TAGS", @tags, scalar @tags;
> $schema->resultset('Products')->search({
> 'tag.name' => {-in => [EMAIL PROTECTED]
> }, {
> distinct => 1,
> join => [
> {'map_product_tag' => 'tag'}
> ]
> }This yields: > TAGS computerwidget2 at > C:/Development/CPAN/Mango/script/../lib/Mango/Provider/Products.pm line 35. > SELECT me.id, me.sku, me.name, me.description, me.price, me.created, > me.updated FROM product me LEFT JOIN product_tag map_product_tag ON ( m > ap_product_tag.product_id = me.id ) JOIN tag tag ON ( tag.id = > map_product_tag.tag_id ) WHERE ( tag.name IN ( ?, ? ) ) GROUP BY me.id, me.s > ku, me.name, me.description, me.price, me.created, me.updated: 'computer' Only the first tag is in the bind params to IN.... Is this an SQL::Abstract issues, or possibly a DBIC bind params issue? -=Chris
signature.asc
Description: OpenPGP digital signature
_______________________________________________ List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class Wiki: http://dbix-class.shadowcatsystems.co.uk/ IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/ Searchable Archive: http://www.mail-archive.com/[email protected]/
