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: 8737
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: Text search
Next Topic: Phrase querying
Goto Forum:

Current Time: Tue Aug 22 02:29:58 CDT 2017

Total time taken to generate the page: 0.03531 seconds