ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "supriya .pelluru" <supriyanaidupell...@gmail.com>
Subject upper method is available in ibatis
Date Wed, 30 Apr 2008 10:23:57 GMT
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