db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Prakash, Anton" <A...@pge.com>
Subject RE: Why? Criteria.LIKE
Date Fri, 14 Nov 2003 19:39:46 GMT
unsubscribe

-----Original Message-----
From: Dave Newton [mailto:dave@solaraccess.com]
Sent: Friday, November 14, 2003 10:41 AM
To: Apache Torque Users List
Subject: Re: Why? Criteria.LIKE


On Mon, 2003-11-24 at 21:09, Toru Suzuki wrote:
> 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%'

Did this get answered?

Is it just a java string issue (need to backslash a backslash)?

Dave



---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


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