rails find - condition on array of db-fields

Question

I am stuck and I guess it is a syntax thing I just don't get:

It's a one(category)_to_many(product) relationship.

In my category model I have the columns pick1, pick2, pick3, pick4, pick5. Each of those holds the id of a product.

In my category_controller I want to retrieve those in a find:

@productpicks = Product.find(:all, :conditions => 
  ['online = ? and category_id IN (?)', true,
  [@category.pick1, @category.pick2, @category.pick3, @category.pick4, @category.pick5]])

... and iterate over them in the view like this:

do something

But there is nothing to be found in that array ...

Does anyone have an idea what I am doing wrong?

Thanks for helping!

Val

Tony Fontenot · Accepted Answer · 2009-11-24 23:27:44Z

1

Shouldn't it be:

@productpicks = Product.find(
  :all,
  :conditions => [
    'online = ? and id IN (?)',
    true, [
      @category.pick1,
      @category.pick2,
      @category.pick3,
      @category.pick4,
      @category.pick5
    ]
  ]
)

Replacing category_id with id in the where clause?

As pick1-5 hold product ids, and you are trying to find those specific products.

edited Nov 24, 2009 at 23:27

answered Nov 24, 2009 at 15:56

Tony Fontenot

5,1011 gold badge23 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

val_to_many Over a year ago

Hey Tony! Thank you so much! You can't imagine for how long I have been thinking about this. Stupid me ;-)

Collectives™ on Stack Overflow

rails find - condition on array of db-fields

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related