[ic] sql order by

[Stefan Hornburg]

On Sat, 24 May 2003 01:47:49 +0200
"Xavier GILLET" <xavier.gillet.perso@wanadoo.fr> wrote:

> 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 ?

Is capacite_max a numeric field ?

Ciao
	Racke


-- 
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team