query problem

[m.natz]

hi

I would like to offer a search function, that let the user choose in which columns to search, e.g. search for the word word1 in Title (or overall) and for the word word2 in Meta.

Now, I tried it with a query like this:
... WHERE Title\Meta\Body likep 'word1 @0' AND Meta likep '-test @0' AND Visited > 991747800

but the '-' in the second part let the webinator crash. if there is no '-' it works like desired. Is that a well known bug? Is there a other solution for solving my problem?

thanks for any hints.

Marcel

[John]

The '-' indicates that you don't want the word to occur, and queries are not allowed to contain only NOT logic sets. What are you actually trying to find? Did you want:

WHERE Title\Meta\Body likep 'word1' AND Meta NOT like 'test'

which would be the way to write Title\Meta\Body contains 'word1' and Meta does not have the word test in it.