db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Toru Suzuki <...@suzuki.email.ne.jp>
Subject Why? Criteria.LIKE
Date Tue, 25 Nov 2003 02:09:06 GMT
Hi all,

I used Torque3.0 and oracle

I'm trying to do

String note = "\*comment";
Criteria cri = new Criteria();
cri.add(PERSON.NOTE, (Object)(note + "%"), Criteria.LIKE);

SQL log is
SELECT PERSON.NAME, PERSON.NOTE FROM PERSON
WHERE PERSON.NOTE LIKE '\comment%'

I expected 
WHERE PERSON.NOTE LIKE '*comment%'

SqlExpression.buildLike(String columnName,String criteria,SqlEnum 
comparison,boolean ignoreCase,DB db,StringBuffer whereClause)
javadoc wrote
criteria = "50\%" -> columnName = '50%'

Why???

---------------------------------------------------------------------
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