On 27 Aug, 06:13, Terry Michaels <[email protected]> wrote:
> Forgive this question, but I'm new to rails, and my SQL is rather rusty.
> I have a line like so to get all records for a particular time period:
>
> @recordings_for_period = Recording.find(:all, :order => "date_of_event
> DESC", :conditions => ["date_of_event >= ? AND date_of_event < ?",
> start_date, end_date])
>
> Let say, instead, I just want to know the number of recordings that are
> available for that time period. Should I just run the above code and
> then get the length of the array? Or is there some construction I should
> be using with COUNT that would be better? (I.e., is less work for the
> database to process.)

There's a count method that does what you want

Fred




>
> Oh, and (unfortunately) I am still using rails 2.3.5.
> --
> Posted viahttp://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 [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