I want to use thinking sphinx in my application, basically i have a filter criteria screen, and depending on the user input, the sql query is generated, which joins all the tables based on user input, now i want to use thinking sphinx for this query, my problem is how to pass sql query to thinking sphinx and then how to differentiate between fields which has same name but are from different tables(eg, id will be there in all the tables) -- 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Check this out: http://railscasts.com/episodes/120-thinking-sphinx On 21 dic, 00:25, Mohit Negi <li...-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org> wrote:> I want to use thinking sphinx in my application, basically i have a > filter criteria screen, and depending on the user input, the sql query > is generated, which joins all the tables based on user input, now i want > to use thinking sphinx for this query, > my problem is how to pass sql query to thinking sphinx and then how to > differentiate between fields which has same name but are from different > tables(eg, id will be there in all the tables) > -- > Posted viahttp://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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Have a look at the thinking sphinx documentation. I believe field conditions might what you need. http://freelancing-god.github.com/ts/en/searching.html#conditions Konstantinos On Dec 21, 2009, at 7:25 AM, Mohit Negi wrote:> I want to use thinking sphinx in my application, basically i have a > filter criteria screen, and depending on the user input, the sql query > is generated, which joins all the tables based on user input, now i want > to use thinking sphinx for this query, > my problem is how to pass sql query to thinking sphinx and then how to > differentiate between fields which has same name but are from different > tables(eg, id will be there in all the tables) > -- > 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en. > >-- 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.