Put the two queries together should do the trick - AND is implicit.
"@(title_en,title_es) #{title_query} @(actor_name, director_name)
#{name_query}"
Cheers
--
Pat
On 05/06/2009, at 7:41 AM, phil wrote:
>
> 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
-~----------~----~----~----~------~----~------~--~---
