ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <larry.mead...@gmail.com>
Subject Re: upper method is available in ibatis
Date Wed, 30 Apr 2008 11:55:19 GMT
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