db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vladimir Figurov <vfigu...@asia-soft.kz>
Subject HowTo make Criteria with use function in WHERE clause?
Date Fri, 23 Jul 2004 14:45:25 GMT
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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message