Sort Fail! in Bug Reports

ID:92198
 
Feb 27 2010, 2:09 pm
Not a bug
BYOND Version:N/A (Website Bug)
Operating System:Windows Vista Home Premium
Web Browser:Firefox 3.6
Applies to:Website
Status: Not a bug
This is not a bug. It may be an incorrect use of syntax or a limitation in the software. For further discussion on the matter, please consult the BYOND Developer forums.
Descriptive Problem Summary:
When you have commas (and/or letters) in "numerical" score data it screws up the sort. Only considering the numbers before the first comma.
http://www.byond.com/games/Falacy/DBZHU2?tab=scores
#1 Feb 27 2010, 2:30 pm
A numerical field is only meant to handle a single number. Non-numerical data or trying to use multiple numbers will definitely fail.
#2 Feb 27 2010, 2:32 pm
Lummox JR wrote:
Non-numerical data or trying to use multiple numbers will definitely fail.

Its still a single number. Its just like 10,000 instead of 10000. Which is sorting it as 10.
#3 Feb 27 2010, 3:02 pm
Ah. Unfortunately the sort is going to be limited to whatever the database can handle, and it doesn't grok numbers with commas. Changing this would not be a simple matter. You'll have to switch to a non-comma form for scores.