RE: Ibatis sql question

2009-07-24 Thread Andrey Rogov
Sorry. price BETWEEN #price# AND #maxprice# price =#price# OR price=#maxprice# _ From: Sergey Livanov [mailto:[email protected]] Sent: Friday, July 24, 2009 3:32 PM To: [email protected] Subject: Re: Ibatis sql question price BETWEEN

RE: Ibatis sql question

2009-07-24 Thread Andrey Rogov
price =#price# OR price=#maxprice# price BETWEEN #price# AND #maxprice# That's better _ From: Sergey Livanov [mailto:[email protected]] Sent: Friday, July 24, 2009 3:32 PM To: [email protected] Subject: Re: Ibatis sql question

Re: Ibatis sql question

2009-07-24 Thread Sergey Livanov
price BETWEEN #price# AND #maxprice# price =#price# OR price=#maxprice# 2009/7/24 Odelya YomTov > Hi! > > I would like to get a parameter in my sql and by that to decide if to use > prepend="OR" or prepend="AND" > > property="maxprice" >compa

Ibatis sql question

2009-07-24 Thread Odelya YomTov
Hi! I would like to get a parameter in my sql and by that to decide if to use prepend="OR" or prepend="AND" price BETWEEN #price# AND #maxprice# How can I do it? - To