hai,<br><br>I upgraded my dbflute to 0.9.5.<br><br>EmployeemasterCB empCB = employeemasterBhv.newMyConditionBean();<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; empCB.query().setEmployeecode_LikeSearch(&quot;<span style="background-color: rgb(255, 102, 102);">emp</span>&quot;, new LikeSearchOption() {<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; @Override<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; public ExtensionOperand getExtensionOperand() {<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return WayOfPostgreSQL.OperandOfLikeSearch.CASE_INSENSITIVE;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }.likePrefix());<br><br>if i give &quot;emp&quot; as search condition it retrieves only The values starts with emp.<br>
<br>InMy table i have the values<br><br>emp22<br>EMP22<br>emp20<br>EMP20<br>.........<br>.........<br>..........<br><br>The above coding retrieves only emp22 and emp20<br>I want to retrieve EMP22 and EMP20 also.<br><br><br>
Thanks<br>トマス<br><br><br><br><div class="gmail_quote">2009/6/9 thomas <span dir="ltr">&lt;<a href="mailto:jp.mcy.10@gmail.com">jp.mcy.10@gmail.com</a>&gt;</span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
hai,<br><br>Thanks for your helps!..<div><div></div><div class="h5"><br><br><br><br><div class="gmail_quote">On Tue, Jun 9, 2009 at 6:00 PM, kubo <span dir="ltr">&lt;<a href="mailto:dbflute@gmail.com" target="_blank">dbflute@gmail.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hello,<br>
<br>
Sorry! I mistook your DBFlute version.<br>
The method and class are supported since 0.9.5.<br>
So please upgrade DBFlute to 0.9.5 if possible.<br>
<div><div></div><div><br>
2009/6/9 thomas &lt;<a href="mailto:jp.mcy.10@gmail.com" target="_blank">jp.mcy.10@gmail.com</a>&gt;:<br>
&gt; hai,<br>
&gt;<br>
&gt; cb.query().setMemberName_<br>
&gt;&gt;<br>
&gt;&gt; LikeSearch(&quot;s&quot;, new LikeSearchOption() {<br>
&gt;&gt; &nbsp; &nbsp;@Override<br>
&gt;&gt; &nbsp; &nbsp;public ExtensionOperand getExtensionOperand() {<br>
&gt;&gt; &nbsp; &nbsp; &nbsp; &nbsp;return WayOfPostgreSQL.OperandOfLikeSearch.CASE_INSENSITIVE;<br>
&gt;&gt; &nbsp; &nbsp;}<br>
&gt;&gt; }.likePrefix());<br>
&gt;<br>
&gt; import org.seasar.dbflute.dbway.ExtensionOperand;//Error<br>
&gt;<br>
&gt; there is no class in org.seasar.dbflute.dbway like ExtensionOperand<br>
&gt;<br>
&gt;<br>
&gt;<br>
&gt; 2009/6/9 kubo &lt;<a href="mailto:dbflute@gmail.com" target="_blank">dbflute@gmail.com</a>&gt;<br>
&gt;&gt;<br>
&gt;&gt; Hello,<br>
&gt;&gt;<br>
&gt;&gt; Please watch this test case:<br>
&gt;&gt; The method is &#39;test_likeSearch_caseInsensitive_Tx()&#39;.<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt; <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><br>


&gt;&gt;<br>
&gt;&gt; cb.query().setMemberName_LikeSearch(&quot;s&quot;, new LikeSearchOption() {<br>
&gt;&gt; &nbsp; &nbsp;@Override<br>
&gt;&gt; &nbsp; &nbsp;public ExtensionOperand getExtensionOperand() {<br>
&gt;&gt; &nbsp; &nbsp; &nbsp; &nbsp;return WayOfPostgreSQL.OperandOfLikeSearch.CASE_INSENSITIVE;<br>
&gt;&gt; &nbsp; &nbsp;}<br>
&gt;&gt; }.likePrefix());<br>
&gt;&gt;<br>
&gt;&gt; This code uses &#39;ilike&#39; in the SQL.<br>
&gt;&gt; (But this way is only available at PostgreSQL)<br>
&gt;&gt;<br>
&gt;&gt; If you have many many points that must be without case sensitive,<br>
&gt;&gt; you should create CaseInsensitiveLikeSearchOption as your original class.<br>
&gt;&gt; Like this:<br>
&gt;&gt;<br>
&gt;&gt; public class CaseInsensitiveLikeSearchOption extends LikeSearchOption {<br>
&gt;&gt; &nbsp; &nbsp;@Override<br>
&gt;&gt; &nbsp; &nbsp;public ExtensionOperand getExtensionOperand() {<br>
&gt;&gt; &nbsp; &nbsp; &nbsp; &nbsp;return WayOfPostgreSQL.OperandOfLikeSearch.CASE_INSENSITIVE;<br>
&gt;&gt; &nbsp; &nbsp;}<br>
&gt;&gt; }<br>
&gt;&gt;<br>
&gt;&gt; 2009/6/9 thomas &lt;<a href="mailto:jp.mcy.10@gmail.com" target="_blank">jp.mcy.10@gmail.com</a>&gt;:<br>
&gt;&gt; &gt; Hai,<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt; I am using PostgresQL 8.3<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt; 2009/6/9 kubo &lt;<a href="mailto:dbflute@gmail.com" target="_blank">dbflute@gmail.com</a>&gt;<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt; Hello, this is jflute.<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt; For starters, there is one thing I want to confirm.<br>
&gt;&gt; &gt;&gt; What kind of database do you use?<br>
&gt;&gt; &gt;&gt; Oracle? MySQL? PostgreSQL? ...<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt; 2009/6/9 thomas &lt;<a href="mailto:jp.mcy.10@gmail.com" target="_blank">jp.mcy.10@gmail.com</a>&gt;:<br>
&gt;&gt; &gt;&gt; &gt; Hai,<br>
&gt;&gt; &gt;&gt; &gt;<br>
&gt;&gt; &gt;&gt; &gt; I want to retrieve data without case sensitive using condition Bean.<br>
&gt;&gt; &gt;&gt; &gt;<br>
&gt;&gt; &gt;&gt; &gt; dbflute version 0.9.4.1<br>
&gt;&gt; &gt;&gt; &gt;<br>
&gt;&gt; &gt;&gt; &gt; empCB.query().setEmployeecode_LikeSearch(empcodes,new<br>
&gt;&gt; &gt;&gt; &gt; LikeSearchOption());<br>
&gt;&gt; &gt;&gt; &gt;<br>
&gt;&gt; &gt;&gt; &gt; How to change this code to get case sensitive result?<br>
&gt;&gt; &gt;&gt; &gt;<br>
&gt;&gt; &gt;&gt; &gt; Please give steps to achieve this...<br>
&gt;&gt; &gt;&gt; &gt;<br>
&gt;&gt; &gt;&gt; &gt; Thanks in advance.<br>
&gt;&gt; &gt;&gt; &gt; トマス<br>
&gt;&gt; &gt;&gt; &gt;<br>
&gt;&gt; &gt;&gt; &gt;<br>
&gt;&gt; &gt;&gt; &gt; _______________________________________________<br>
&gt;&gt; &gt;&gt; &gt; Seasar-user mailing list<br>
&gt;&gt; &gt;&gt; &gt; <a href="mailto:Seasar-user@ml.seasar.org" target="_blank">Seasar-user@ml.seasar.org</a><br>
&gt;&gt; &gt;&gt; &gt; <a href="https://ml.seasar.org/mailman/listinfo/seasar-user" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-user</a><br>
&gt;&gt; &gt;&gt; &gt;<br>
&gt;&gt; &gt;&gt; &gt;<br>
&gt;&gt; &gt;&gt; _______________________________________________<br>
&gt;&gt; &gt;&gt; Seasar-user mailing list<br>
&gt;&gt; &gt;&gt; <a href="mailto:Seasar-user@ml.seasar.org" target="_blank">Seasar-user@ml.seasar.org</a><br>
&gt;&gt; &gt;&gt; <a href="https://ml.seasar.org/mailman/listinfo/seasar-user" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-user</a><br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt; _______________________________________________<br>
&gt;&gt; &gt; Seasar-user mailing list<br>
&gt;&gt; &gt; <a href="mailto:Seasar-user@ml.seasar.org" target="_blank">Seasar-user@ml.seasar.org</a><br>
&gt;&gt; &gt; <a href="https://ml.seasar.org/mailman/listinfo/seasar-user" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-user</a><br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt;<br>
&gt;&gt; _______________________________________________<br>
&gt;&gt; Seasar-user mailing list<br>
&gt;&gt; <a href="mailto:Seasar-user@ml.seasar.org" target="_blank">Seasar-user@ml.seasar.org</a><br>
&gt;&gt; <a href="https://ml.seasar.org/mailman/listinfo/seasar-user" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-user</a><br>
&gt;<br>
&gt;<br>
&gt; _______________________________________________<br>
&gt; Seasar-user mailing list<br>
&gt; <a href="mailto:Seasar-user@ml.seasar.org" target="_blank">Seasar-user@ml.seasar.org</a><br>
&gt; <a href="https://ml.seasar.org/mailman/listinfo/seasar-user" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-user</a><br>
&gt;<br>
&gt;<br>
_______________________________________________<br>
Seasar-user mailing list<br>
<a href="mailto:Seasar-user@ml.seasar.org" target="_blank">Seasar-user@ml.seasar.org</a><br>
<a href="https://ml.seasar.org/mailman/listinfo/seasar-user" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-user</a><br>
</div></div></blockquote></div><br>
</div></div></blockquote></div><br>