Ruby Array map for integers

Question

I have this Rails 3.1 ActiveRecord query:

Show.where('event_id = ? AND id not in (?)', params[:event_id], @dog.show_entries.map(&:show_id).join(','))

It worked fine when @dog.show_entries.count == 1. When it had more I had problems with the SQL generated, which was:

SELECT "shows".* FROM "shows" WHERE (event_id = 1 AND id not in ('2,1')) ORDER BY date ASC

How do I stop it from enclosing the 2,1 in quotes?

Swanand · Accepted Answer · 2012-01-24 07:38:12Z

2

Drop the join(','):

Show.where('event_id = ? AND id not in (?)', params[:event_id], 
  @dog.show_entries.map(&:show_id))

answered Jan 24, 2012 at 7:38

Swanand

12.4k7 gold badges48 silver badges62 bronze badges

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

1 Answer 1