Jeff Burlysystems wrote:
> How about:
>
> ...
> require 'time'
> ...
> invoices = Invoice.find(:all, :conditions=>['issue_date is not null
> and (issue_date >= ? or issue_date <= ?)', Time.parse('2009-02-09
> 00:00:00'), Time.parse('2009-02-09 23:59:59')] :order=>'issue_date')
> ...
>
> Jeff
Thanks for your reply, and your help! It gave me a hint and solved the
problem like this:
self.cond << ["invoices.issue_date > ?", from - 1] unless from.blank?
self.cond << ["invoices.issue_date < ?", to + 1] unless to.blank?
because issue_date is a datetime, and generating an invoice means saving
both date and time of the day. This way the search will have the same
results as in your example.
Once again, thank you for your help!
--
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 [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
-~----------~----~----~----~------~----~------~--~---
