Problems with CONTAINS() and WO
Problems with CONTAINS() and WO
- Subject: Problems with CONTAINS() and WO
- From: Pascal Robert <email@hidden>
- Date: Wed, 27 Nov 2002 16:19:20 -0500
Hi,
we're using Oracle 9i 9.1 and Apple's WebObjects together. One of our
applications is using ConText indexes and we have small problems with this.
ConText seems to think that dashes are wildcards, for example, if we do:
SELECT * FROM TABLE WHERE CONTAINS (FIELD,'33-99%',0) > 0
instead of fetching any text that have 33-99 in it, it fetch anything with
33 in it. In pure SQL, I can escape the dash by putting a slash in front:
'33\-99%'
but WebObjects is stripping the slash so I still have the problem. So,
finally, my question is: do you know of any other escape caracter that I can
use instead of a slash, or can I tell EO to NOT remove slashes ?
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.