Intermedia search fails on new records
From: Harry <a_at_abc.com>
Date: Fri, 15 Nov 2002 15:00:41 GMT
Message-ID: <sf2atugf5pnvkbnn57mk8muv9nnqfsospk_at_4ax.com>
Date: Fri, 15 Nov 2002 15:00:41 GMT
Message-ID: <sf2atugf5pnvkbnn57mk8muv9nnqfsospk_at_4ax.com>
Using Oracle 8i (8.1.7.0) on win 2000 (sp3)
Each time I add a new record I have to drop & recreate Intermedia
index (using statement below, to allow searching on Word 97 Document
held in 'DOCUMENT' field
CREATE INDEX PUB_INDEX ON NHD_PUBLICATION(DOCUMENT) INDEXTYPE IS
CTXSYS.CONTEXT
This statement then works fine -
SELECT * FROM NHD_PUBLICATION WHERE CONTAINS (DOCUMENT,
If I add a new record with Word doc containing 'accommodation' word it
fails i.e
SELECT * FROM NHD_PUBLICATION WHERE CONTAINS (DOCUMENT,
I have to drop/recreate index to make it work!
'manufacturers')> 0;
'accommodation')> 0;
Surely this should work straight away?
any ideas?
thanks
harry Received on Fri Nov 15 2002 - 16:00:41 CET