Re: Intermedia search fails on new records
Date: Fri, 22 Nov 2002 14:24:40 +0000 (UTC)
Message-ID: <arlen8$148$1_at_helle.btinternet.com>
Hey Harry Im developeing a system which would have to routinely scan word and excel documents, i was wondering if you could give me your thoughts on Intermedia.
Regards
Steve_at_Donsolaris.com
"Harry" <a_at_abc.com> wrote in message
news: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,
> 'manufacturers')> 0;
>
> If I add a new record with Word doc containing 'accommodation' word it
> fails i.e
>
> SELECT * FROM NHD_PUBLICATION WHERE CONTAINS (DOCUMENT,
> 'accommodation')> 0;
>
> I have to drop/recreate index to make it work!
>
> Surely this should work straight away?
>
> any ideas?
>
> thanks
>
> harry
Received on Fri Nov 22 2002 - 15:24:40 CET