ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Albert L. Sapp" <as...@uiuc.edu>
Subject Re: Using a like statement
Date Tue, 31 May 2005 14:18:25 GMT
Build your value before sending it to the select statement in your xml file.

I set my values in my action by using this: itemQuery.setDescription('%' + 
request.getParameter("description").toUpperCase() + '%')

I, then, pass the parameter itemQuery to my manager and DAO layers.

Hope this helps.

Al

At 06:34 AM 5/31/2005, you 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.


Mime
View raw message