ibatis-user-cs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gilles Bayon" <ibatis....@gmail.com>
Subject Re: nested iterate
Date Mon, 13 Nov 2006 16:17:25 GMT
On 11/10/06, nicolas.theron@bnpparibas.com <nicolas.theron@bnpparibas.com>
wrote:
>
>
> Hi
>
> Is it possible to nest iterate tag in a select statement  ?


It is not supported

For instance, i expexted the following syntax but it does not work :(
>
> <select id ="select-book-ids-for-view" parameterClass="PViewCriteria">
>         SELECT BOOKID FROM
>         (
>                 <iterate property="CategoriesSet"  prepend="" conjunction=
> "INTERSECT" open="(" close=")">
>                         SELECT BOOKID FROM ORG_LINK_BOOK_CATEGORY
>                         <iterate prepend="WHERE" property="
> CategoriesSet[].ValuesSet" open="(" close=")" conjunction="OR">
>                                 VALUEID = #CategoriesSet[].ValuesSet[]#
>                         </iterate>
>                 </iterate>
>         )
> </select>
>
> Is there an alternative ?
>
> Thx
>
> NT
>
> This message and any attachments (the "message") is
> intended solely for the addressees and is confidential.
> If you receive this message in error, please delete it and
> immediately notify the sender. Any use not in accord with
> its purpose, any dissemination or disclosure, either whole
> or partial, is prohibited except formal approval. The internet
> can not guarantee the integrity of this message.
> BNP PARIBAS (and its subsidiaries) shall (will) not
> therefore be liable for the message if modified.
>
>                 ---------------------------------------------
>
> Ce message et toutes les pieces jointes (ci-apres le
> "message") sont etablis a l'intention exclusive de ses
> destinataires et sont confidentiels. Si vous recevez ce
> message par erreur, merci de le detruire et d'en avertir
> immediatement l'expediteur. Toute utilisation de ce
> message non conforme a sa destination, toute diffusion
> ou toute publication, totale ou partielle, est interdite, sauf
> autorisation expresse. L'internet ne permettant pas
> d'assurer l'integrite de ce message, BNP PARIBAS (et ses
> filiales) decline(nt) toute responsabilite au titre de ce
> message, dans l'hypothese ou il aurait ete modifie.
>
>
>


-- 
Cheers,
Gilles

<a href="http://www.amazon.com/gp/registry/6JCP7AORB0LE">Wish List</a>

Mime
View raw message