Sorry - again with the newbie questions!

I have a model:

class Film
  define_index do
    indexes participants(:name), :as => :actor_name
    indexes directors(:name), :as => :director_name
    indexes :title, :as => :title_en, :sortable => true
    indexes titles_es.title, :as => :title_es, :sortable => true
  end
end

How do I search for all films with the word 'midnight' in the title
AND have 'clint eastwood' as an actor or a director?
I can't figure it out.

I can do the word midnight in either title_en or title_es:
"@(title_en,title_es) #{title_query}"
or clint as actor or director:
"@(actor_name, director_name) #{name_query}"

but how can I 'AND' these two queries?

Thanks for any help!


--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to