Using an array in an active record query

rubyonrails-talk
1

Hi, I’m trying to take the input of a text area, and pass it onto an active record query.

So, far I’ve got the following code…

@blah = params[:sku] #this is a example, 

@blah2= @blah.split(" ")

@sku_lookup_items = Good.where('sku IN (?)', [@blah2])

the query works if I add string values like “1”,“2” so something is wrong with @blah2

gives me a type error…

TypeError at /quotetemplates/sku

can’t quote Array

Any hints? Thanks, Joe

2

ok, solved it.

@blah2 , instead of [@blah2] in the query