Thanks Jan. javinto wrote: > 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 -~----------~----~----~----~------~----~------~--~---
