How does that work James??? Deal.search(:with => (0..Time.zone.now.to_i))
0..Time.zone.now.to_i .... Why 0? How does it even know how to use the start_time??? On Nov 2, 2:58 pm, James Healy <[email protected]> wrote: > Pete wrote: > > I want to create a condition on my search of "deals" so that it only > > searches for deals that: > > > :conditions => [ 'start_time < ?', Time.zone.now] > > > I am guessing that I have to add this condition somehow to my: > > > @query_results = Deal.search params[:search] > > > But I just cant work out how to write the condition in a sphinx > > friendly way... > > You will want to add start_time to your index as an attribute like so: > > has :start_time > > Then search like this: > > Deal.search(:with => (0..Time.zone.now.to_i)) > > Date attributes are stored in sphinx as integers, and there's no way to > search for documents with "an int less than", hence the range of ints. > > -- James Healy <[email protected]> Mon, 02 Nov 2009 14:57:29 +1100 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Thinking Sphinx" 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/thinking-sphinx?hl=en -~----------~----~----~----~------~----~------~--~---
