[Zope-DB] Best practice for an OracleText CONTAINS query from ZOPE

getCITED support at getcited.org
Tue Aug 24 11:34:50 EDT 2004


Lest anyone get frustrated trying to execute this statement, permit me to
note that it requires >0 at the end:

SELECT foo FROM bar WHERE CONTAINS(bar.foo,'Search String') > 0


...michael


> Thorsten Henrici wrote at 2004-8-21 22:41 +0200:
> >I would like to issue a
> >
> >SELECT foo FROM bar WHERE CONTAINS(bar.foo,'Search String')
> >
> >As far as I know this can't be done with a ZSQL method.
>
> Try it ( ;-) ), it will work...
>
> --
> Dieter



More information about the Zope-DB mailing list