Hi, I'm not sure how your code was, but you can do this as well:
@states = States.find(:all, :conditions => ["country=? OR country=?", LOCALE, 'International']) It's just an array where every question mark will get replaced with it's successive array element after having being Escaped by Rails. So the first <?> gets replaced with the 2nd element The second <?> with the 3rd element And so on Jan On 21 okt, 13:35, Schalk Neethling <[EMAIL PROTECTED]> wrote: > 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 [email protected] 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 -~----------~----~----~----~------~----~------~--~---
