[ic] sql order by

[Xavier GILLET]

Hello,


I try to order results from an sql query.
This is my query :

[query sql="select capacite_max from [scratch this_page]
 where
 initial_status = 'confirmee'
 and
 actual_status = 'En ligne'
 and
 sens = 'Offre'
 and
 departement = '[scratch dept_chiffre]'
 [scratch query_saison]
 group by capacite_max
 order by capacite_max asc"
        type=list]

and this is the result : 10 4 5 6

Order is supposed to be : 4 5 6 10

How can I force the order to use numeric ?

Merci.