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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
