In ruby on rails how do I pass an array as a series of parameters

Question

I have a simple query that I'm attempting to construct.
I want to pass in parameters to the query.

Product.where('id = ?', 1)

Easy as right.. What to do if the field list and the values are arrays

fields = ['id = ? ', 'type_id = ?', 'brand_id = ?']
values = [1, 1, 1]
Product.where(fields.join(' and '), values)  #does not compute, does not compute!

Anyone know how to pass in the values for a parametrized query?

FYI: prepared statement !== parametrized query

tereško
– tereško

2013-01-22 06:55:15 +00:00
Commented Jan 22, 2013 at 6:55 — tereško
– tereško, Commented Jan 22, 2013 at 6:55

Paal Øye-Strømme · Accepted Answer · 2013-01-22 06:26:48Z

5

You can use * to convert an array into a parameter list:

fields = ['id = ?','type_id = ?','brand_id = ?']
values = [1, 1, 1]
Product.where(fields.join(' and '), *values)

edited Jan 22, 2013 at 6:26

Paal Øye-Strømme

5,9514 gold badges24 silver badges24 bronze badges

answered Jan 22, 2013 at 6:22

Marc Baumbach

10.5k2 gold badges32 silver badges47 bronze badges

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

Collectives™ on Stack Overflow

In ruby on rails how do I pass an array as a series of parameters

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related