search for: search_date

What would be the best way to search a MySQL datetime field with rails? I have an table in a db which will have many rows, I primarily search it by date. I have a datetime column named simply "datetime", of course along with the date it keeps the time info. I do need the time info, however I only need to search the rows via the dates, so what would be the easiest way to search via

Hello All, I am having an issue with AAF and sorting results of a search. Right now, I have results being split onto pages of 10. The results are being sorted alphabetically, but not across multiple pages - it''s just sorting the 10 it pulls down on each page. I noticed another post from April regarding this same issue (http://www.ruby-forum.com/topic/62993#66934) where the issue was

...had to fix the incorrect data, and I figured while i was at it, I would normalize and minimize everything to this format: "19991018000000". Now it seems that sorting on this column does not work at all. I have not changed how the data is stored in the index, it has always been: :search_date => {:term_vectors => :no, :index => :untokenized, :store => :yes } Any ideas? Thanks. John