Hi Markus If you look at the generated query in your config file, you'll be able to figure out which table alias/name to use (the query will be referring to multiple tables with a column called onsale). I'm guessing that maybe it's top_containers - given the name of the index - so you'd want it to be something like follows:
where "top_containers.onsale = 1" Adapt as needed. Cheers -- Pat On 13/07/2010, at 9:22 PM, Maechi wrote: > Hi there, > > I have a container table which acts as a tree. Every container has a > boolean value onsale. If I just want to filter the containers who are > on sale, the statement: > > where "onsale = 1" > > causes the following error: > > ERROR: index 'top_container_core': sql_range_query: Column 'onsale' in > where clause is ambiguous (DSN=mysql://prod:*...@localhost:3306/ > prod_development). > > I guess its because of the acts as tree structure. How can I handle > this problem? > > Thanks > Markus > > -- > 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. > -- 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.
