ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steven Pannell <steven.pann...@zooplus.com>
Subject Using a like statement
Date Tue, 31 May 2005 11:34:50 GMT
Hi,

Is there an easy way to describe a 'like' statement in the iBatis xml file.
for example I have:

<select id='dd' parameter="string">
	select * from bush where bush_name like #value#
</select>

Using Oracle I have to make the value look like this:

	String value = "hello%" 

Can't I do this in the map something like:


<select id='dd' parameter="string">
	select * from bush where bush_name like #value#%
</select>


At present this won't work.

cheers,
Steve.

Mime
View raw message