It is in the FAQ: http://opensource.atlassian.com/confluence/oss/display/IBATIS

Larry


On 5/31/05, Steven Pannell <[EMAIL PROTECTED]> wrote:
> 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.
>

Reply via email to