The reason Top Times don’t sort correctly when an event spans less than a minute to greater than a minute or less than ten minutes or greater than 10 minutes is for a pretty simple reason: the times are actually stored as text, and when text is sorted, it is sorted by character, left to right, instead of by incremental value, like how time is counted. This results in “9:51.01″ showing up on the list later than “10:09.91.” 9 comes as the first character in the string, and comes after 1, which is the first character in the other string.
I think there are probably some pretty easy fixes for this, and if I recall correctly I actually use a fix for this in some areas of the site. Now I just need to figure out if that’s true. I also wonder if I should be storing it as time instead of text and then doing more conversions on the data for presentation to get it into and out of the database.
You’ll notice I am putting this in the cateogiry “Minor Bugs.” Unfortunately, there are other things that need to be fixed far more than this.
Have you been waiting for us to build a new feature? Let us know by posting comments here.
Please use the comments on this post to tell us what is broken.
I have little doubt that you have noticed all of the broken stuff on d3swimming.com, and the fact that we’ve been outpaced by the rest of the internet. While we are still the best source for Division III Swimming & Diving information and community, we have recognized the need for bug fixes, upgrades, and a general facelift to the site. This blog is designed to keep the d3swimming.com community informed and engaged while we pursue these three interrelated goals. To that end, you will find a few different categories of posts:
- From the Management
- Broken Feature
- Fixed Feature
- New Feature
- Site Design
- Your Feedback Requested
These are probably not the only categories we will use, but it is a starting point. The category “Your Feedback Requested” will be used for any posts where we know that you, the user of the feature, is the best person to tell us if it works in an intuitive and effective manner or not. As an example of this categorization, this post is in the category “From the Management,” “New Feature,” and “Your Feedback Requested.”
Additionally, we will use the post tags to identify which feature it is that we are talking about. Hopefully this organization will make it easier for us to communicate on this blog and keep track of what needs to be fixed, what has been fixed, and what’s coming up next.
-Derek
0
Back to top