I use. I found no problems.
2007/3/15, Christopher H. Laco <[EMAIL PROTECTED]>:
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
_______________________________________________
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]/
_______________________________________________
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]/
