Cool, thanks. My IDE was moaning when I did something similar to that. One should not always trust the IDE I guess, or does it have something to do with the fact that you moved the constant to the end?
Kind Regards, Schalk javinto wrote: > Hi Schalk > > Just use: > > @states = States.find(:all, :conditions => ["country=? OR > country='International'", LOCALE]) > > Jan > > > On 21 okt, 12:50, Schalk Neethling <[EMAIL PROTECTED]> wrote: >> Hi there everyone, >> >> How does one set-up a SQL OR query in Rails. >> >> I have the following SQL query: >> >> select state, state_abbr, country from states where country = 'Country' >> or country = 'International' order by state asc; >> >> Now in Rails: >> >> @states = States.find(:all, :conditions => [:country => LOCALE, :country >> => 'International']) >> >> But the above will do a SQL AND query. What is the right keyword to use >> between those two conditions to turn this into a OR query? >> >> Thanks! >> Schalk > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
