You can't create a Range over 2 Dates and iterate over those - I'm assuming that's what you want to do.
but what you can do is iterate over the lookahead
(0..look_ahead).each do |diff| yield (date+diff.....) end
ok i seems you sometimes CAN create ranges of dates - but that it doesn't work in a running app points towards some strange view-helpers being added to the date-class or something like that. my method should still work, while yours implies some kind of hidden to_i/to_date back-and-forth which could lead to that error. don't try to force it if there is another way.
Phil
You can't create a Range over 2 Dates and iterate over those - I'm assuming that's what you want to do.
but what you can do is iterate over the lookahead
(0..look_ahead).each do |diff| yield (date+diff.....) end
I think we've gotten a little off-track. Allow me to steer us back in the right direction...
This is the line throwing the error in my app:
appointments.find_all_by_date(date)
What's the stack trace of the error?
Fred
ah .. yes sorry I seem to be responding while new and clarifying messages are added to this thread.. that way I got off-track.
have you tried converting the date to a string before the find_all_by_date() ? or formulating it as a :conditions array ?
these are not solutions but you could analyse the problem from different angles like that.
P
Oh, yeah, weird. I would just change it to appointments.find_all_by_date Date.today.to_s(:db)
and cross my fingers.
Pat
What database are you using? Version, and adapter version? It looks like AR isn't treating something as a date there. Like it's sanitizing the SQL as a string...which most likely means (to me) that for some reason it doesn't know that the db column is a date. Did you perhaps mess up on the migration and create the date field as a string instead of a date?
Pat
Pat Maddox wrote:
Oh, yeah, weird. I would just change it to appointments.find_all_by_date Date.today.to_s(:db)
and cross my fingers.
Pat
What does the (:db) to?
ActiveSupport overrides Date#to_s, passing :db makes it format the
string in the way the database wants it.
Fred