ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "supriya .pelluru" <supriyanaidupell...@gmail.com>
Subject Re: upper method is available in ibatis
Date Wed, 30 Apr 2008 12:00:03 GMT
ya .  but i dont know that is working or not . becz i  have to  do  so much
coding   for test that one . thats y i am sended this query

On Wed, Apr 30, 2008 at 5:25 PM, Larry Meadors <larry.meadors@gmail.com>
wrote:

> Did you try it?
>
> Larry
>
>
> On Wed, Apr 30, 2008 at 4:23 AM, supriya .pelluru
> <supriyanaidupelluru@gmail.com> 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
> >
> >
> >
>

Mime
View raw message