Ruby on Rails

Hey all,

I am getting this error:

NoMethodError (undefined method `gsub!' for 2012-01-22 17:00:00
-0500..2012-01-23 00:00:00 -0500:Chronic::Span):

in this code:

date_range = Chronic.parse(the_date, :guess =>
false)

reports.sum_distance_by_date(date_range).each do |d|
u[:m] << d
end

def self.sum_distance_by_date(time)

time = time ? Date.parse(time) : Date.today.to_s
reports = find_by_sql(["SELECT date_trunc('day', time),
SUM(distance * 0.000621371192) AS sum FROM reports WHERE \"time\" = ?
GROUP BY date_trunc('day', time)", time])
reports
end

Basically Chronic returns a range back, and I just want to be able to
use that result inside the find_by_sql query to get all records by
that date.

thanks for response

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