[ic] order by numeric field

[Xavier GILLET]

Bonjour !

I want to sort sql results using this code :

 [query
 type=list
 ml=10
 sql="select code, description, n_ventes from products where
 order by n_ventes desc
 "]

n_ventes field is in products :
Database  products  COLUMN_DEF   "n_ventes=decimal(10,0) DEFAULT '0' NOT
NULL"
Database  products  NUMERIC       n_ventes

Results are not sorted by numeric values.

1) 20
2) 100
3)10

Interchange 4.9.8