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
jimsang
Messages: 13
Registered: May 2008
Junior Member
select CDM,S_INFO,C_ID,C_SID
from t_shop
where S_VALID='1' and CDM in
(
    SELECT CDM
    FROM t_shop
    WHERE CONTAINS (s_name, p_query, 1) > 0 
)

can i do like this:
    SELECT CDM,S_INFO,C_ID
    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: 9077
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: Fri Mar 29 04:19:26 CDT 2024