headers
Tim Conner | 18 Jul 13:56

ActiveRecord: SQL IN operator


I want to use an array in the :conditions of an ActiveRecord Find so
that a SQL IN statement is created.  However, I also want to specify a
greater than condition on a timestamp column too.
From the Docs:
An array may be used in the hash to use the SQL IN operator:
  Student.find(:all, :conditions => { :grade => [9,11,12] })

How do I modify this so that it also contains the timestamp condition?
:condition => ['created_at > ?',time]
--

-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
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@...
To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
Permalink | Reply |
headers
Brian Hogan | 18 Jul 16:08

Re: ActiveRecord: SQL IN operator

Hey...
I've been doing Rails for a while and have never adopted the hash syntax for conditions.  Someone else might be able to help you with that, but I know this will work:
 
Student.find :all, :conditions = >["grade in (?) and created_at > ?", [9,11,12], time]

On Fri, Jul 18, 2008 at 6:57 AM, Tim Conner <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:

I want to use an array in the :conditions of an ActiveRecord Find so
that a SQL IN statement is created.  However, I also want to specify a
greater than condition on a timestamp column too.
From the Docs:
An array may be used in the hash to use the SQL IN operator:
 Student.find(:all, :conditions => { :grade => [9,11,12] })


How do I modify this so that it also contains the timestamp condition?
:condition => ['created_at > ?',time]
--
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Permalink | Reply |
headers
Rob Biedenharn | 18 Jul 16:26

Re: ActiveRecord: SQL IN operator

On Jul 18, 2008, at 10:08 AM, Brian Hogan wrote:

Hey...
I've been doing Rails for a while and have never adopted the hash syntax for conditions.  Someone else might be able to help you with that, but I know this will work:
 
Student.find :all, :conditions = >["grade in (?) and created_at > ?", [9,11,12], time]

Yes, that's it.  If you like the Hash form for conditions, you might like DataMapper where the same query would look like:

  Student.all(:grade => [9,11,12], :created_at.gt => time)


-Rob

On Fri, Jul 18, 2008 at 6:57 AM, Tim Conner <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:

I want to use an array in the :conditions of an ActiveRecord Find so
that a SQL IN statement is created.  However, I also want to specify a
greater than condition on a timestamp column too.
From the Docs:
An array may be used in the hash to use the SQL IN operator:
 Student.find(:all, :conditions => { :grade => [9,11,12] })


How do I modify this so that it also contains the timestamp condition?
:condition => ['created_at > ?',time]


--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Permalink | Reply |

Gmane