Great! You solved aswell my second issue! Thanks a lot! Markus
On 13 Jul., 16:49, Pat Allan <[email protected]> wrote: > 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 > > athttp://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.
