On Jan 22, 2012, at 23:36 , John Merlino wrote:
> 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)
try to add logger:
logger.debug "*** '#{date_range}', class is #{date_range.class}"
>
> 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
better to write as
def self.sum_distance_by(time = nil)
time ||=Date.today
reports = find_by_sql(...., time)
end
as Date.today is Date class, the same as Date.parse()
tom
>
> 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+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/rubyonrails-talk?hl=en.
--
===============================================================================
Tomas Meinlschmidt, MS {MCT, MCP+I, MCSE, AER}, NetApp Filer/NetCache
www.meinlschmidt.com www.maxwellrender.cz www.lightgems.cz
===============================================================================
--
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+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.
