Home » Server Options » Text & interMedia » about WHERE CONTAINS. (window xp, 10g)
about WHERE CONTAINS. [message #322768] Mon, 26 May 2008 03:36 Go to next message
Messages: 13
Registered: May 2008
Junior Member
from t_shop
where S_VALID='1' and CDM in
    FROM t_shop
    WHERE CONTAINS (s_name, p_query, 1) > 0 

can i do like this:
    FROM t_shop
    WHERE CONTAINS (s_name, p_query, 1) > 0 and S_VALID='1' 

it's very convenient, but error. why? thanks
Re: about WHERE CONTAINS. [message #322875 is a reply to message #322768] Mon, 26 May 2008 09:42 Go to previous message
Barbara Boehmer
Messages: 8922
Registered: November 2002
Location: California, USA
Senior Member
You need to post a copy and paste of an actual run, including all relevant parts, line numbers, and the complete error message. Otherwise, nobody can guess what the problem might be. The code that you posted, by itself, looks fine.
Previous Topic: Re: DRG-51030: wildcard query expansion resulted in too many terms
Next Topic: Oracle Text - wildcard expansion too many rows
Goto Forum:

Current Time: Sun Jan 24 01:33:34 CST 2021