c2scott wrote:
The method that was chosen was to match duration of the workout (time, meters) and the date. If you look at the ranking, date is available for input but not time-of-day. There are just a handful of complaints or comments about this each year. We are looking to improve this in the future, but I'm dependent on the web/ranking team to design and implement changes on the database before we can move forward with something on the PC end...
FWIW - I am a web database developer too, so I'm well familiar with the problem here. It seems to me that the issue relates to the workout session being kept in the database on the server does not have the Time-of-Day attached to it. If it did, then the problem is easy to fix. Most databases have a DATE data-type which allows a date AND time to be stored in one field. If that DATE data-type is already being used, then no database changes are required and the solution is to just populate the field with the full amount of data and apply logic to handle it. I understand though that it still requires modification on both ends - server & client.
Of course, if a DATE data-type is not being used, then that introduces added complexity to the problem.
Good luck - Brian
M 65 / 6'3" / 234lbs as of Feb 14, 2008...now 212
Started Rowing: 2/22/2008
Vancouver Rowing Club - Life Member(Rugby Section)
PB: 500m 1:44.0 2K 7:57.1 5K 20:58.7 30' 6866m