The remove first prepend is intended to remove the first prepend of a 
sub-condition.
For exemple:
    <iterate prepend="," removeFirstPrepend="true"  property="name">
      <isNotNull prepend="removeMe" property="name[]">
           substr(upper(#name[].firstName#),1,1)||upper(#name[].lastName#)
      </isNotNull>
    </iterate>

What you want is:
    <iterate separator=","  property="name">
           substr(upper(#name[].firstName#),1,1)||upper(#name[].lastName#)
    </iterate>

Christian

-----Original Message-----
From: Trenton D. Adams [mailto:tre...@athabascau.ca] 
Sent: Friday, December 11, 2009 6:32 PM
To: user-java
Subject: iterate not working

Hi Guys,

I am using 2.3.0.

I'm wondering why this does not work...
           IN (
    <iterate prepend="," removeFirstPrepend="true"  property="name">
           substr(upper(#name[].firstName#),1,1)||upper(#name[].lastName#)
    </iterate>
              )

But this does...
           IN (''
    <iterate prepend=","  property="name">
           substr(upper(#name[].firstName#),1,1)||upper(#name[].lastName#)
    </iterate>
              )


Trenton D. Adams
Systems Analyst/Web Software Engineer
Navy Penguins at your service!
Athabasca University
(780) 675-6195
:wq!

__ 
    This communication is intended for the use of the recipient to whom it
    is addressed, and may contain confidential, personal, and or privileged
    information. Please contact us immediately if you are not the intended
    recipient of this communication, and do not copy, distribute, or take
    action relying on it. Any communications received in error, or
    subsequent reply, should be deleted or destroyed.
---

---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org

Reply via email to