Return-Path: Delivered-To: apmail-incubator-ibatis-user-java-archive@www.apache.org Received: (qmail 698 invoked from network); 15 Mar 2005 15:01:10 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 15 Mar 2005 15:01:10 -0000 Received: (qmail 4285 invoked by uid 500); 15 Mar 2005 15:01:08 -0000 Delivered-To: apmail-incubator-ibatis-user-java-archive@incubator.apache.org Received: (qmail 4259 invoked by uid 500); 15 Mar 2005 15:01:08 -0000 Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm Precedence: bulk Reply-To: ibatis-user-java@incubator.apache.org List-Help: List-Unsubscribe: List-Post: List-Id: Delivered-To: mailing list ibatis-user-java@incubator.apache.org Received: (qmail 4220 invoked by uid 99); 15 Mar 2005 15:01:08 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=HTML_60_70,HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from Unknown (HELO mailsrv.atlantico.com.br) (200.129.63.5) by apache.org (qpsmtpd/0.28) with ESMTP; Tue, 15 Mar 2005 07:01:07 -0800 Received: from IA123 (unknown [10.101.41.9]) by mailsrv.atlantico.com.br (Postfix) with ESMTP id A01ED1000A for ; Tue, 15 Mar 2005 12:00:57 -0300 (BRT) From: "Leonardo Holanda" To: Subject: RES: dynamic "prepend" problem Date: Tue, 15 Mar 2005 12:00:36 -0300 Message-ID: <000e01c5296f$be67a7a0$0929650a@virgo.atlantico.net.br> MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_NextPart_000_000F_01C52956.991A6FA0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 Importance: Normal In-Reply-To: <4236F730.3050604@ateikon.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N This is a multi-part message in MIME format. ------=_NextPart_000_000F_01C52956.991A6FA0 Content-Type: multipart/alternative; boundary="----=_NextPart_001_0010_01C52956.991A6FA0" ------=_NextPart_001_0010_01C52956.991A6FA0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Yes. Maybe we both have not understand how is works...=20 In my case, I cannot write a hardcoded OR becase if I did, I have to do in every case... Since there are many combination possibilities...=20 =20 -----Mensagem original----- De: Emiliano Armellin [mailto:earmellin@ateikon.com]=20 Enviada em: ter=E7a-feira, 15 de mar=E7o de 2005 11:55 Para: ibatis-user-java@incubator.apache.org Assunto: Re: dynamic "prepend" problem Leonardo Holanda ha scritto:=20 How can I correct this? For now, i'm writing a constant expression resulting 'false' after the opening parenthesis, but it's not very elegant way... Ibatis wasn't supposed to detect that this OR is unnecessary? Hello Leonardo, I've found the same problem writing the sql map described in my post some days ago (Dynamic Mapped Statements question - 2005-03-11). My solution was to add some extra test like:=20 OR it seems there is a problem using prepend=3D"AND|OR" after = parenthesis... or I haven't understand how it works.=20 Is there someone who can help us? --=20 Emiliano Armellin=20 *=09 W_ www.ateikon.com=20 *=09 @_ earmellin@ateikon.com=20 *=09 T_ +39 0422 452101=20 Get = Firefox! Get Thunderbird ------=_NextPart_001_0010_01C52956.991A6FA0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Mensagem
Yes.=20 Maybe we both have not understand how is works...
In my=20 case, I cannot write a hardcoded OR becase if I did, I have to do in = every=20 case... Since there are many combination possibilities... =
 
-----Mensagem original-----
De: = Emiliano Armellin=20 [mailto:earmellin@ateikon.com]
Enviada em: ter=E7a-feira, = 15 de mar=E7o=20 de 2005 11:55
Para:=20 ibatis-user-java@incubator.apache.org
Assunto: Re: dynamic = "prepend"=20 problem

Leonardo Holanda ha scritto:=20

How can I correct this? For now, i'm writing a = constant=20 expression resulting 'false' after the opening parenthesis, but it's = not=20 very elegant way... Ibatis wasn't supposed to detect that this OR is = unnecessary?

Hello Leonardo,
I've found = the same=20 problem writing the sql map described in my post some days ago = (Dynamic Mapped=20 Statements question - 2005-03-11). My solution was to add some extra = test=20 like:

<isNotEmpty=20 property=3D"company"> OR=20 </isNotEmpty>

it seems there is a problem using=20 prepend=3D"AND|OR" after parenthesis... or I haven't understand = how it=20 works.
Is there someone who can help us?


--
Emiliano Armellin=20
  • W_
  • www.ateikon.com=20
  • @_
  • earmellin@ateikon.com=20
  • T_+39=20 0422 452101
  • 3D"Get
    ------=_NextPart_001_0010_01C52956.991A6FA0-- ------=_NextPart_000_000F_01C52956.991A6FA0 Content-Type: image/gif; name="trust.gif" Content-Transfer-Encoding: base64 Content-ID: <609595714@15032005-1DD8> R0lGODlhWAAfAOYAAAAAAMXd3QBWnswzAKkXALWqnQAgZnCfnu/v71hcmXd8fNCERTk7O11hYQqk 1K5nQgAKSeBiDtPl5bPPz////wBOjw6MyMFNGeWdbOFaCnJ3d4aurhcaGjPM/+bm5udsJ9Xe3ik7 Zn+MjORSAb3OzicwXa2/wiRYfvOFOJIbEEhLS8luZSYpKeNkFPP39wA9dGPM7JbZ64mWlv+3d5yj o4BMOczMzN7s7MFhFABtqw4PD9NHB/BpH769twCZzGZmZpSmpsUgB/3srhBfhK+2tq94YKuahuxr G9qPbFhziPzKo87d3UKx3maZmcLHx6a3t/mMTzFxqu90Jd5sFqdVITN5pd6UZQAwd74WBwBAhz9E RNrV0sR4Pt/f31FTU/meVZu7u+Xv74+jo91/JD1ggs+8rN5KBup6GAAhPu/Aid9TCJU4Ea13Uuda CKJXM78xBxOv4MeebQBmmTMzMz4+dw91tMHW1gAzZqPE1B4fHxhzj9U7DMOffvBmE/KAMe+QWCH5 BAUUAB0ALAAAAABYAB8AAAf/gB2CE4SFhoeIiYqLjI2OhoKRhEsSlZaXmJmam5ydnpd2JiZ4pKSF knYuFKusra6vsLGys7SsJnQGLxUCvDk5dUx2Ex2EqrXHyMmxCHxbrGIGBlnTFbsCv8AkhBLK3d60 qlY4zmEJ0VdX01nW13VwMYQI3/P0rAVTZ2U2uOfo6klGaFRxByPeMhu0unSpp8yFCytnznChAyGa RXRJygiZQUaABThw7CwxRgGASQBaemihpUABw2QunHCJeKZGxRIhcoYwkmbGFy9ZcjgAKSGMK5Wr kMpbhWAhq5ZOKchDSIHqUlcIerBqurXL1VUujOA4MyVCBDdFMMxY+weKnz4P/+TksODAgQWSrJBS 6JFnTh4NFGjk+fu0rw4bCFAqsJFHyxwEOrrQAEDhxw++KlQEHvyjst+vLhCIbbFDzQcUKKBA+fJF Cg8efZLUne3ARRiHuHswcNhjjgfdLnT08AAAt4IfLn6ocAHAhgsVClwwEKGCRgPhDHoomAPCoXDi LhQsx+0QAYIiF/bsed2nvfvXPNo08OGD9o0lt3ET2e1if//dALDAAANOONRSeAA6xEB0x4nwgw4i KFCcByrowABxAhJ4IHm2eVDEG6WpYVYbJJLo3ggpyOEAffUJc4N55u0XIwMIyKgDDU3BqMEPCDTQ QGLmqfBDGNMxRqAOKoRRlP8EABBxo5JhaKBBGFRWeQMIReyQgYhmZVBiiX2oQUAKerDogyhFVbkf lWuuKRgDSVKpAQs6HBYGAFQ6kQcDLIAQRh4i/BnonAKG8WaSUlZpZQ9ctGDWFFN8KamYBKxRQw0q 6AHGBgHc4OmnoIZ6n6ikerpEqZ+emiqqV8YBaQRjjJHBCJJ++cYbAwywwxoqHHCAHZ8EK+ywmfSw gKywRkBrrSXuoOsHM6SRRBNNTEDstdhyUsAYEZgB6QgZRMAsiaalIUQPZORA7QRLtOvuu/DGK++8 7T4hAr3xygBEu3a4OsIIU2SQQVnj9hGBFUqIoIu61QbgMAkOR0yCCRI/HHH/ABNH/ETFG0ds2cMZ QwwxxkA4PEfJATixgFn/Ahwps0ccIYUUbNxRgVzr2iEMACbYwYIIInDAggp2iDGHHZbpbIcMQosg Bgdz6GDCBADMwYEWSnPAwQ9MsyDDHGLYAUDRV2vxhA5e29HDGJDOOgK3tfYRsxR++PHAEHIxPEHE WmhgAgAT6CBGAAA8YXQAHzusgwwR783C4DyLAYDHPwTwNMRgE444CxQHkHkAJrBxhrIjRDDFsiXO TTdqKJyQ97oRizCHCFoQXvIc+s6BeOUOA4DyE1BzUPLkQEzu8MdAzNHuyUsAsAQJWugwBwnML0GE G2e4XRbqfbTg/Qfgo/bF/wnX6O0uCSjJsMTizT9BAwtLNPCDu+yT8IPyc9DQ/BKTuWsZ/8pbAu7Q 97znAYAG+WtXAS5wutJ9q0RmwIIEsZACNKCBAVwg3zWoRQIQeBAE0fNg0FjgBRA4QXos4I4I0aYA GaCwhAAAwWQ+6MIGINCDDRAaB2jwAxakEAQ5FIEdFrgHcJmugW2I4ASxMIc73OEFuuCFADj4QRAo oIQftEEVtahFhSjEBl4EIxi9SMYujJGMYgyjGm2wwAGUjnT/asMAsBCEOgaBAVd4ATWkyEEv0oAD TiijIAdJyEIacpBbWKDAwtWyfw3AjkHYwwXusI5qVCMK1AKDBza5hU168qmToAylKEdJylImkgAD cBQcHZkr9eyhD1QIQSWrcQBqHaCUuPwkjHbJy1768pddKEAKgjAFEbntX650ZXtwoAJ1nKCWHWjC BkDwy2pa85rY7GUXiDDMKZihBQ38lxmSaYYMtKcFF3DDAzbQBEFQqwlgMAG+5FXFetrznvi85/MK sAIkWOGfALUCEgZK0IFiAAMFKEAt2xmJdzr0oRCNqEQnStGKWjSikQgEADs= ------=_NextPart_000_000F_01C52956.991A6FA0 Content-Type: image/png; name="thunderbird_small.png" Content-Transfer-Encoding: base64 Content-ID: <609595714@15032005-1DDF> iVBORw0KGgoAAAANSUhEUgAAAG4AAAAgCAYAAADzCU3nAAAABmJLR0QA/wD/AP+gvaeTAAAACXBI WXMAAAsTAAALEwEAmpwYAAAAB3RJTUUH1AUZDzg0nf1sjwAADttJREFUeNrtmntwVFWawH+3H7ef 6XR3Hp2QZ+fBIyQICdGAiLVkxAUcdXSYHRXZ2tXZWXVmd7Uc2S1ff6yjNeuWheVWuRazlu5o0FkZ EUeyCkGQQcAgEBPeodNJ59XdSTqd9PN233v3D7BreAQBdWZnN19V/3H6nO/Ud7/f+b7znXOvoKoq 0/KnJ7orVVj4xHsWb8/Q45FwZGvit4/+btqFfwLg/vqtvTkGjbqRIzvb8wpKq/Pn3mCsnDvTMOe7 99t7+8fSQ8FouD840Z+clPqSmx+cmHbvtyfC5abKJWte1tb/sGnb8Y+7lkZCY4dzZ1XW2ewW0Znv xNsXYMA/yUBgknA4qWpS8rBWVg/KE8n/NKDZNLbr7+VpV/8RwFmK1y2/6fvzHmu8fX7z8Ck/ismA JGhIptKEwgmGAhECY1E0goAjy4jZqEOr0aDTCIwEJg+IWYZfHHj2jnem3f0HAqdZvr7YPim/PKvA eMsDT61AMegYCycYnUgQCEaYGIvj8U8wEZWwWkRsFhGNRkCv1yKlZJzZRlQEtAKUZum4c24ueVb9 tNenljTQC7QD24EtVVVVwYuymWqGGX/zem1etmWbJpG8pam+hOISJwlJJhRO0HtqBHUoyshIlHBM wmzSYzLoUFQVrUZgbDyOyaBDAELjMQRBYNsXfn72bg+9Q8FpPJeuOSqBHwK/BDZ0d3c3Xza4O19q rS1x2bfbdPrZVlVmxS3z6B2Z5MSpEQ7u7sE4liQYkzgRnCAVSxANR0AAGS3jkSR6nYacbBNpWaWi xE46rWAQdchaePnD49N4Ll9uA569GLwLwC178KnKtNa8xSqKrqFDx6kpS6MryGZb63E+fKMD3WSa lEHLvv5RQmNx/IOTDB0f4mjbYfwdXUTiaYxGEaNRRyqtMBZOcLJ3jImJBPF4nD39Rl57b880ksuX a4Gfdnd3510SXGlV5YvZNou745MT1MbfZulML8d6J/h8WzfOjlepFr183B8hOC4jJbTIaRFZY0NK 2vB9NkBfaxujoSi7PuvD2z+O1zeOIqs4dDp6fWFiQ34+2J/G4+2bRnJlkXfrlOCu+95djZbya1Z2 dQyQ1b+X2xdGKbQMMTA0ipqIs7SpmAlXKb4TXsr9+5kZ2kvBeBcMe4j7h0jLED12iqEdn1Bdkcfk RILjJ4N094wS8E+SK4pIkQQx7wjvbjtyxdZHo9FvxSvRaBSPx/O19L+uBAIBAoHApYZ8Z8oD+Pxb 7vnBcc+ocOqz49y3IEKpeyYRxcFwcJzKhWWcdjbSuesDnrJsZk5REFWRMNoLMBXM5aAnwSef++hX ZYLHxwkfX0Cxw050PIFZqyXbakQYn0DoCzAu6NjfoRBPJDAZjZd0nsVioauri5aWFh5//HFqamrQ arXfKDiPx8PPf/5zVq9ezZ133nlFuhs2bKCtrY0333zzArtaWlpoa2vjueeeIz8//5Lz7Nu3j5aW FtatW8eCBQsuNqRxSnCSPmdRJDyKJuhjzvUqZoeZHNe1nO47wqljX2A1RHiqqhtnloVo3IB7Vg01 dfMQRS1/riS5PzDMtr2f0n7oBBs/3YGxfgV6UYeYTJGbZaK3qxshEiOe5WAwaqLPN8is6opznHe+ LF26FJfLBYDX68XtdmO1Wr+VyBsdHSUYDJKXl3dFkQJw7NgxamtrL+hXVZXu7m7sdjuiKH7lfP39 /VRXV1/sGcumBNfV1V9y5HAQixQl32Wn4c9uYv9BH2Iywa+fX01g79uExstJJpNU11VT27gYORkl JcVQpTh5+W7+YlURoua/2DN0hGDqZorNBnwHOjiNSmBUQpNjR2OwYLGaGfIHM+AqKip45JFHOHz4 MDt27KC+vp45c+Zgt9vxer0AJBIJWltbMRgMNDU1kZ+fTzQapbOzE4vFQl1dHR6Ph56eHpqbmwkE Auzbt4/m5mba2toAaG5uxmKxANDZ2UlPT8+UUdjV1XWOTiAQoLOzE7fbTVdXF263OzP+4MGDeDwe 3G43dXV1ADQ1NaGqKg6Hg0AgwIkTJ87Rrauro62tjWg0it/vv6LryXMa/YPhLNkTQJEF8svrKJl3 F76+F4l4O3BV3Uu4bx4GtQer0UD1kptR9VrQmREMCYR0AlWR0OkEli1dyW/3/waPGdLRNBMDwySz ctBbbOhIQzKFzSoyPpk8JyU2NDQAsGPHDux2O/X19WRnZxMMnjn7bdq0KTP+o48+4oUXXsDj8bB+ /XruuOMO3G43GzdupLOzk/r6erZv386WLVvYvHkzsVgMgN7eXh588EHa29tZv379lGlr/fr1lJeX EwgE2L17N08++SQej4cNGzZgNpuJxWI89thjyPKZ27ytW7dm9NeuXcvKlSsztixfvpzTp09foPv6 66/T2tp6VdnhnOJkIiypZqMW0VVB0ugGJBavupfSyjx2vvM2hTXXYc0to3DuIgyuSrDkoc0pQldQ gWLOIxgR2Nl2mG27TlJV7iIyNsLQSBKdI4schwVblojZqEdNJDFlGYkmUucYo9VqMZlMmbYoilit VnS6M+tr2bJlPPHEExQWFjIyMpKJRIDx8XHi8XimPTAwkEk3TU1NrFu3DoDBwUGGh4fZsmULAPfc c88F+1pLSwtlZWWsWbOG2267DZ/Px9atWzO2lZWV8fTTT5+T+h566CHuu+8+AN5//31CoVCmz+/3 Z6L8S11FUWhtbcVsNvPoo4+yePHiqwennAqM5FhT/HhFGm/cASRAELnhB3+HFB2kt6eX0vobya2Y C1ongrmQkTGFTz74hHdb3qG9vZ2UCI3N17H6+7eS48zC4RDJcmbjKnUhyhLhkQjaXCdyWkaWUldk bGFhIS6Xi9zc3DN7siRdtl5xcXGmnUqlMoWQ2+2mrKzsgn2rt7eXZ555ho0bN55Z1BMTmagtLCzE arVSW1ubKUgcDgc33ngjAKFQKJMlLmaL1WrFYDAA4HK5sFgslJaWXv1rHc1kxBuZSMy8vsqBXTyA lKhCNFrRGxws+d4admz8FcXVNcgY6NjdxumOA8TCw+QX2mlYVEuO3YbVIKLXpPEGFIpmlRDaewRr rhObw8KpSBqNQY/RrMe77zjmeQVXnCJ+PyK/Kb3z+ywWCzabjWXLlmX+s9vtmbQIYDxbDf++fBmB RqPxkovqfF2TyYRGo7l6cKrB9vl4RF6etjVQUWshFh5BNNpAiWF1FrCweRkfv/UaUjKNzS4yq6aM 4pIFWIwGtIqMmk6ipBKQinMqXkhaipA8+THO+lsZC0YwZZsQ9VpiwyGio2HstspvrCIcGhri0KFD l30e+7Jg2bRpE9nZ2ef0NTU1ZYqGgoICDhw4wNq1axkYGJhyvq1bt7J9+3aAyzqy1NXVkZeXR09P D62trfh8vqsHlx7ZtV0/Y9k/HT4xxorv3gAooCRRZQmSKWaUVXL9zSoGvZbs7Cw0chpVllBSCWQp iSonEWSJlKwQCkVwdrxIrlGg42SMhsZ8YmMiyaRMJCZjchrIzbF9bWB1dXWsWLGC1tZWvF4vCxcu xOPxMDw8jCAIU67ku+++G5/Px7Fjx8jJycFkMjE+Pp7pi0ajbN68GYCGhgYGBwcvOlc0GsXpdHL0 6FESiQRNTU0sWbIEm+2rn+3hhx/m+eefZ9euXZSUlGTS7BRyesrXOoKgMxmsf9V5/bW5le+92oi1 ZAEIIqQSqKk4aiqJhjRqKomaSqCmJdS0BLKEmk5CWkKVU2iUNHI8xCtv/JJ//WAOWU1rKS4QaN/T D6qKIhgpNA7w78/eQlFR0QUWRiIRvF4vLpcrc6YKBoP4/X7Ky8uxWq14vV4ikUjm7OT3+wkGg+h0 OvLy8kgmk7hcLqLRKH19fRm9rq4urFYr5eXlyLKMz+cjEokgiiKyLGOz2SgqKkKWZYaHhzOOzM7O xuVyIUnSBbadPn0aWZYzP4fDQUFBAVqt9hw7L/Zc8Xgcn8+HJEmYTCbi8ThFRUU4HI7z3fJWVVXV XVO+jzMYFv+j0dT43E9Xn2bVd/KYVTMfW24lOlMuoD2TDqUYpJKocuoMNFk625YgnUKryoyNDfHp wVM88KKA7F6KHB5E5yhEiYXRW5wsyD3Jc//8wFXvWf8P5f6qqqr/uGiqPFNxHX5Fb533t//yVn7Z a5sOcX3DCZY2ZrPwmiIqKtw4ckrRGewgqCiqjCKnzkaaBGejL51OkePMIkUZIyNfoFGP4qosIRkd Q68ViPcc5Nrls6ehXb68B2yZco8DUJRYSG+s/Ad75V+2hPrGTL/e3sem7VK6KG9UVz/3GI3zLJON 80qzaqpnkONwotcYEFQBVU6hyEnUdApUBY1Wy76jUVJyAmPoFBOBbKTRPrQGGy7TIIsW3TuN4/Lk M+Cl89+ET/npgsFc/SOL/eZ/iwc6RVkeD6dIdENWDSQ67rh9SZM0OUhFYZxF19iYP7uA4rxcDIKI IKvoNCrDIZlVj3Ry+FgfRq0eEFAUFY1G5WePr+Kuu1d/45fF/0cj7aWqqqq2S1aV51w4x7tfVVR9 cVbZyqdS/i+y1WhvP0zsETCYF9Rf05RKz2V0NMTbu4d4478HmF3azQ0NTuqq8ih02Hhnj4zHN4mA ijXLTDwWR5EF6ubnsfzmZdPQLi6X/c3JJT8WEgQhVzSVPWC2LfxRcnQkX06H3wahXUCUABVUVUEm RcoIqWKzXpg9062dueqmuor2IzZD287PMRtEXK4c+n0jKERHUuqxHytq8jfTjL6efOXneYIgZIPQ qNXMWIRi0WvJGhbQpQDtGXhnzu6gqkki8RmuGbULFy74yc6P91li8Tg1sysYGgwRCvtHZU4+oZL4 laqq0WnXf8vgzsLTAEawGrWUODXYigVwgGoSQJ9GUWTS4WvraxvmzK74ydatv3MGx8eYW1VNPJHE 09/+IQRfgfROVVVD027/A4G7EKRLFLCZBUwWAfSOHKfjusb5jwiqZs2OnXtRVSVdUVaum4wEg31D n2+EiQ3ASVVVpWmX/xHBnS/VVQuawiHp/uBYf9RoMMbyc4tnhMLBwGTEtxvYDwRVVVWm3f2/DNzZ dGoArIJGQFVUBZCBpKqqyWk3f/PyP3Aj8lnGUUTOAAAAAElFTkSuQmCC ------=_NextPart_000_000F_01C52956.991A6FA0--