hai, Thanks for your helps!.. <div class="gmail_quote">On Tue, Jun 9, 2009 at 6:00 PM, kubo <<a href="mailto:dbflute@gmail.com">dbflute@gmail.com</a>> wrote: <blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> Hello, Sorry! I mistook your DBFlute version. The method and class are supported since 0.9.5. So please upgrade DBFlute to 0.9.5 if possible. <div><div></div><div class="h5"> 2009/6/9 thomas <<a href="mailto:jp.mcy.10@gmail.com">jp.mcy.10@gmail.com</a>>: > hai, > > cb.query().setMemberName_ >> >> LikeSearch("s", new LikeSearchOption() { >>    @Override >>    public ExtensionOperand getExtensionOperand() { >>        return WayOfPostgreSQL.OperandOfLikeSearch.CASE_INSENSITIVE; >>    } >> }.likePrefix()); > > import org.seasar.dbflute.dbway.ExtensionOperand;//Error > > there is no class in org.seasar.dbflute.dbway like ExtensionOperand > > > > 2009/6/9 kubo <<a href="mailto:dbflute@gmail.com">dbflute@gmail.com</a>> >> >> Hello, >> >> Please watch this test case: >> The method is 'test_likeSearch_caseInsensitive_Tx()'. >> >> >> <a href="https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-postgresql-example/src/test/java/com/example/dbflute/postgresql/dbflute/various/VendorCheckTest.java" target="_blank">https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-postgresql-example/src/test/java/com/example/dbflute/postgresql/dbflute/various/VendorCheckTest.java</a> >> >> cb.query().setMemberName_LikeSearch("s", new LikeSearchOption() { >>    @Override >>    public ExtensionOperand getExtensionOperand() { >>        return WayOfPostgreSQL.OperandOfLikeSearch.CASE_INSENSITIVE; >>    } >> }.likePrefix()); >> >> This code uses 'ilike' in the SQL. >> (But this way is only available at PostgreSQL) >> >> If you have many many points that must be without case sensitive, >> you should create CaseInsensitiveLikeSearchOption as your original class. >> Like this: >> >> public class CaseInsensitiveLikeSearchOption extends LikeSearchOption { >>    @Override >>    public ExtensionOperand getExtensionOperand() { >>        return WayOfPostgreSQL.OperandOfLikeSearch.CASE_INSENSITIVE; >>    } >> } >> >> 2009/6/9 thomas <<a href="mailto:jp.mcy.10@gmail.com">jp.mcy.10@gmail.com</a>>: >> > Hai, >> > >> > I am using PostgresQL 8.3 >> > >> > >> > >> > >> > 2009/6/9 kubo <<a href="mailto:dbflute@gmail.com">dbflute@gmail.com</a>> >> >> >> >> Hello, this is jflute. >> >> >> >> For starters, there is one thing I want to confirm. >> >> What kind of database do you use? >> >> Oracle? MySQL? PostgreSQL? ... >> >> >> >> 2009/6/9 thomas <<a href="mailto:jp.mcy.10@gmail.com">jp.mcy.10@gmail.com</a>>: >> >> > Hai, >> >> > >> >> > I want to retrieve data without case sensitive using condition Bean. >> >> > >> >> > dbflute version 0.9.4.1 >> >> > >> >> > empCB.query().setEmployeecode_LikeSearch(empcodes,new >> >> > LikeSearchOption()); >> >> > >> >> > How to change this code to get case sensitive result? >> >> > >> >> > Please give steps to achieve this... >> >> > >> >> > Thanks in advance. >> >> > トマス >> >> > >> >> > >> >> > _______________________________________________ >> >> > Seasar-user mailing list >> >> > <a href="mailto:Seasar-user@ml.seasar.org">Seasar-user@ml.seasar.org</a> >> >> > <a href="https://ml.seasar.org/mailman/listinfo/seasar-user" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-user</a> >> >> > >> >> > >> >> _______________________________________________ >> >> Seasar-user mailing list >> >> <a href="mailto:Seasar-user@ml.seasar.org">Seasar-user@ml.seasar.org</a> >> >> <a href="https://ml.seasar.org/mailman/listinfo/seasar-user" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-user</a> >> > >> > >> > _______________________________________________ >> > Seasar-user mailing list >> > <a href="mailto:Seasar-user@ml.seasar.org">Seasar-user@ml.seasar.org</a> >> > <a href="https://ml.seasar.org/mailman/listinfo/seasar-user" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-user</a> >> > >> > >> _______________________________________________ >> Seasar-user mailing list >> <a href="mailto:Seasar-user@ml.seasar.org">Seasar-user@ml.seasar.org</a> >> <a href="https://ml.seasar.org/mailman/listinfo/seasar-user" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-user</a> > > > _______________________________________________ > Seasar-user mailing list > <a href="mailto:Seasar-user@ml.seasar.org">Seasar-user@ml.seasar.org</a> > <a href="https://ml.seasar.org/mailman/listinfo/seasar-user" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-user</a> > > _______________________________________________ Seasar-user mailing list <a href="mailto:Seasar-user@ml.seasar.org">Seasar-user@ml.seasar.org</a> <a href="https://ml.seasar.org/mailman/listinfo/seasar-user" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-user</a> </div></div></blockquote></div>