Pass sql query to Thinking Sphinx

[mohitnegi]

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)

[Pat Allan]

Hi Mohit

You will find the Thinking Sphinx docs to be pretty helpful with setting all this up. You will need to keep in mind that Sphinx doesn't use SQL queries for filters, but has it's own filter system (with exact filter matches on attributes, and keyword matches on fields).
http://freelancing-god.github.com/ts/en/

It's also worth noting that you can bring in data from associations quite easily when defining fields and attributes. Have a look through the examples on the indexing page:
http://freelancing-god.github.com/ts/en/indexing.html

If you get stuck with anything in particular, let us know.

--
Pat

> --
>
> You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group.
> To post to this group, send email to thinkin...@googlegroups.com.
> To unsubscribe from this group, send email to thinking-sphi...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
>
>