Woody selection list element and i18 translation question - cocoon 2.1.3

[anthony herve <an...@yahoo.fr>]

Hello,

I have a form with a wd:selection-list element 'country' filled from the content of a postgresql
table 'country' containing values in French.

<wd:field id="country" required="true">
  <wd:label><i18n:text i18n:catalogue="messages" i18n:key="Country">Pays:</i18n:text></wd:label>
  <wd:datatype base="string"/>
  <wd:selection-list src="cocoon://selectionCountry" dynamic="true"/>
</wd:field>

<wd:selection-list xmlns:wd="http://apache.org/cocoon/woody/definition/1.0">
  <wd:item value=""><wd:label></wd:label></wd:item>
  <esql:connection> 
  <esql:pool>maPool</esql:pool>
   <esql:execute-query>  
    <esql:query><xsp:expr>"SELECT id,text FROM country ORDER BY id"</xsp:expr></esql:query>       
           
     <esql:results>
      <esql:row-results> 
       <wd:item><xsp:attribute name="value"><esql:get-string column ="id"/></xsp:attribute>
        <wd:label><i18n:text><esql:get-string column="text"/></i18n:text></wd:label>
       </wd:item>
      </esql:row-results>
     </esql:results>
    </esql:execute-query>
   </esql:connection>
</wd:selection-list>

When I connect in French, the values are displayed in the following order from the sql request
(the table entries are in the correct alphabetical order) :
1-Afghanistan
2-Afrique du Sud
3-Albanie

When I connect in English, after i18 translation, the values are displayed in the following order
:
1-Afghanistan
2-South Africa
3-Albania

Do you know a way I could respect the alphabetical order in both languages ?

Thanks for your help.

Best regards.

Anthony




	

	
		
___________________________________________________________________________ 
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger 
Téléchargez cette version sur http://fr.messenger.yahoo.com

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org