Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Error using intermedia text
In article <915g90$ghq$1_at_nnrp1.deja.com>,
mconlin_at_my-deja.com wrote:
>
>
> I was trying to do a contains on a LONG field, this does not
> work, so that was my problem.
>
> In article <913b7i$qie$1_at_nnrp1.deja.com>,
> mconlin_at_my-deja.com wrote:
> > In article <20001204060824.20900.00003391_at_ng-fc1.aol.com>,
> > timkarnold_at_aol.com (TimKArnold) wrote:
> > > :I have text_enable True on the DB.
> > >
> > > set it to NO
> > >
> >
> > I am having the same error,
> > When I set text_enable = FALSE;
> >
> > When I run a query I always just get nothing in return.
> >
> > SELECT MANSWER FROM ANSWERDATA
> > WHERE CONTAINS(MANSWER, 'this') >0;
> >
> > Gives back nothing when my column MANSWER definantly has the
> > work "this" in it.
> >
> > Help ?!
> >
> >
-- It would work on the LONG field with the OMNIDEX database search engine. See http://www.disc.com/keyword.html or contact me. Cheryl Grandy cgrandy_at_disc.com 303 444-4000 DISC Get OMNIDEX for the fastest applications ever Sent via Deja.com http://www.deja.com/Received on Mon Dec 18 2000 - 10:52:10 CST
![]() |
![]() |