ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sergey Livanov <sergey.liva...@gmail.com>
Subject Re: Ibatis sql question
Date Fri, 24 Jul 2009 12:32:02 GMT
<isNotEqual prepend="#parameter#" property="maxprice" compareValue="1">
       price BETWEEN #price# AND #maxprice#
</isNotEqual>
<isNotEqual prepend="#parameter#" property="maxprice" compareValue="0">
       price =#price# OR price=#maxprice#
</isNotEqual>




2009/7/24 Odelya YomTov <odelya@jpost.com>

> Hi!
>
> I would like to get a parameter in my sql and by that to decide if to use
> prepend="OR" or prepend="AND"
>
> <isNotEqual prepend="<here to write the parameter of the query>"
> property="maxprice"
>                                compareValue="0">
>                                price BETWEEN #price# AND #maxprice#
>                        </isNotEqual>
>
> How can I do it?
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>

Mime
View raw message