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
Veteran / Moderator (17297 posts)
Jan 30, 2008, 6:33 AM
Post #2 of 3
Views: 3459
Hi,
Wrong forum
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
IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
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
Wrong forum
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
IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
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

