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

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.


Andy (mod)
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.