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
-~----------~----~----~----~------~----~------~--~---

Reply via email to