Did you try it? Larry
On Wed, Apr 30, 2008 at 4:23 AM, supriya .pelluru <[EMAIL PROTECTED]> wrote: > > > Hi to All > > > i am don this query in sql first , the query is > > > > select * from usersselections where status='N' > > and (request_status='N' OR request_status='y') > > > and upper(memberid)=upper(?) > > > > now i am changing into ibatis like this > > > <select id="select list of books based on status and request status" > resultMap="ReturnedBooksFormResult" parameterMap="selectbookid"> > select > * > > FROM IBATISUSERBOOK > WHERE STATUS='N' and (REQUEST_STATUS='N' OR REQUEST_STATUS='Y') > > and upper(MEMBERID)=upper(?) > > > </select> > > > when i am creating this i got dobut at upper() method > > if any on know solution for this query please reply me > > >
