Gossamer Forum
Home : General : Databases and SQL :

order by float numbers

Quote Reply
order by float numbers
Hi! I´m trying to sort upon a float column, but SQL is not doing it. Is there any restriction in sorting this type of data?
Quote Reply
Re: [ACB] order by float numbers In reply to
Hi,

Wrong forum Wink I've moved your post for you.

Regarding your question - from memory, the only way I've managed to sort FLOAT type numbers, is with a CHAR field, and then just do ORDER BY FieldName DESC.

Hope that helps.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Quote Reply
Re: [Andy] order by float numbers In reply to
Thanks! This is my first quotation.
I´ll try it that way.

Thanks again.