HowTo make Criteria with use function in WHERE clause?

[Vladimir Figurov]

Hello!
I use Oracle 9i and try use Text Search in BLOB field.
A simple Oracle code for text search is "SELECT ... FROM table_content
WHERE contains(blob_field, 'search_string')>0

How to build Criteria?
Criteria crit = new Criteria(ContentsPeer.DATABASE_NAME);
crit.add(ContentsPeer.TABLE_NAME, "contains(CONTENT,'%five%')", new
Integer(0), Criteria.GREATER_THAN);
returned a BAD Criterion :
crit.toString() : SELECT  FROM contents WHERE
contents.contains(CONTENT,'%five%')>0
and Oracle is not understand this Select ;-((

--
Владимир Фигуров
ТОО "АЗИЯ-СОФТ"
Департамент разработки
ведущий специалист
ICQ:  332054482
офис: 8-3272-754400
моб:  8-300-7270789

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]