Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

order by float numbers

Jan 30, 2008, 6:15 AM
ACB
New User (2 posts)
Jan 30, 2008, 6:15 AM
Post #1 of 3
Views: 4580
Shortcut
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?
Jan 30, 2008, 6:33 AM
Andy
Veteran / Moderator (17619 posts)
Andy's avatar
Jan 30, 2008, 6:33 AM
Post #2 of 3
Views: 4537
Shortcut
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
Jan 30, 2008, 7:29 AM
ACB
New User (2 posts)
Jan 30, 2008, 7:29 AM
Post #3 of 3
Views: 4535
Shortcut
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.