Rails conditions equal to one of an array- Syntax Errors

Question

Hi I am trying to understand why I get a syntax error for this:

:conditions => ["rank = ? and primaries.relationship = ?", ['CPT','SFC'], "Spouse"]

I need to check "rank" against an Array of options.

Seems like this should be pretty simple, any suggestions?

bjg · Accepted Answer · 2010-07-28 22:56:14Z

1

Something like this perhaps:

:conditions => ["rank IN (?, ?) AND primaries.relationship = ?", 'CPT','SFC', "Spouse"]

answered Jul 28, 2010 at 22:56

bjg

7,4771 gold badge27 silver badges21 bronze badges

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

1 Answer 1