<isEqual prepend="#parameter#" property="maxprice" compareValue="0">
price =#price# OR price=#maxprice#
</isEqual>
<isEqual prepend="#parameter#" property="maxprice" compareValue="1">
price BETWEEN #price# AND #maxprice#
</isEqual>
That's better
_____
From: Sergey Livanov [mailto:sergey.liva...@gmail.com]
Sent: Friday, July 24, 2009 3:32 PM
To: user-java@ibatis.apache.org
Subject: Re: Ibatis sql question
<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 <ode...@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-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org
