Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Context Cartridge:Searching Reserved Words using Escape method not work.

Context Cartridge:Searching Reserved Words using Escape method not work.

From: TeiKing <kini_tei_at_canotec.co.jp>
Date: Fri, 20 Oct 2000 01:33:47 GMT
Message-ID: <8so7dr$2rn$1@nnrp1.deja.com>

Hi,all:
i am a beginner of the context cartridge,i want to search the reserved character,there are introduce that using escape method to do it,but it not work in my machine.

i have create an context index and this is the indexed data is stored in PTECHDESCRIPTION,here is the PTECHDESCRIPTION field's context: Main Catalog Main Category 22222 22222 testforescapekeyword: AT&T (-)

this is the test result i have get:

this query can work:
select ... from ... where ... contains(PTECHDESCRIPTION,'{AT&T}',1)>0

and query of here not work:
select ... from ... where ... contains(PTECHDESCRIPTION,'{(-)}',1)>0

query of this not work:
select ... from ... where ... contains(PTECHDESCRIPTION,'{&}',1)>0

it seems the reserved words cannot search correctly and i want to search the reserved words.

can anyone tell me what's the reason and how to make the second query works?

thanks.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 19 2000 - 20:33:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US