Subject: Equipment Tracker miles not adding up. I have 2 shoes listed in my Equipment Tracker:
1 ) Asics Gel-Kayano XI (BLK ) Current usage (44 miles )
2 ) Asics Gel-Kayano XI (WHT ) Current usage (6 miles )
For some reason the mileage on the second pair is off. It says I have 6 miles on the shoes but I have well over that. I wonder if the SQL query that derives the mileage is doing a "LIKE" comparison and picking up the first pair of "Asics Gel-Kayano XI" and not getting to the " (BLK )" and/or " (WHT )" which an "=" would do.
Just a thought.
Rob |