OraFAQ Forum: Text & interMedia » about WHERE CONTAINS.

Home » Server Options » Text & interMedia » about WHERE CONTAINS. (window xp, 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

about WHERE CONTAINS. [message #322768]

Mon, 26 May 2008 03:36

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

Report message to a moderator

Re: about WHERE CONTAINS. [message #322875 is a reply to message #322768]

Mon, 26 May 2008 09:42

Barbara Boehmer
Messages: 9106
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.

Report message to a moderator

Previous Topic:	Re: DRG-51030: wildcard query expansion resulted in too many terms
Next Topic:	Oracle Text - wildcard expansion too many rows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Aug 15 00:55:09 CDT 2025