Sorry.
<isEqual prepend="and" property="maxprice" compareValue="1">
price BETWEEN #price# AND #maxprice#
</isEqual>
<isEqual prepend="and" property="maxprice" compareValue="0">
price =#price# OR price=#maxprice#
</isEqual>
_____
From: Sergey Livanov [mailto:[email protected]]
Sent: Friday, July 24, 2009 3:32 PM
To: [email protected]
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 <[email protected]>
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: [email protected]
For additional commands, e-mail: [email protected]
